
2. (Sheet #2) (10 points) The table represents the Temperature in Fahrenheit and the number of...
A biologist wishes to determine if there is a relationship between temperature and the number of chirps per second of crickets. Below is the data of 15 crickets at various temperatures. Chirps/sec Temperature 20 88.6 16 71.6 19.8 93.3 18.4 84.3 17.1 80.6 15.5 75.2 14.7 69.7 17.1 82 15.4 69.4 16.2 83.3 15 79.6 17.2 82.6 16 80.6 17 83.5 14.4 76.3 Then the linear formula is: Chirps =___+___ *Temperature
Use only the Excel functions (no calculator). I need to see all Excel formulas to give you a full credit. 1. (Sheet #1) (10 points) Use the following categorical frequency distribution to answer each problem. Top Cell Phone Providers Verizon US Cellular T-Mobile Sprint Other AT&T Number of Students 271 87 206 177 35 224 a. (4 pts) Create a pie chart and pareto chart. b. (3 pts) Add two more columns: Relative Frequency (rf) and Cumulative Relative Frequency (ert)....
Use only the Excel functions (no calculator). I need to see all
Excel formulas to give you a full credit. Give answers to the 4th
decimal place.
1. (Sheet #1) (10 points) Use the following categorical
frequency distribution to answer each problem. a. (4 pts) Create a
pie chart and pareto chart. b. (3 pts) Add two more columns:
Relative Frequency (rf) and Cumulative Relative Frequency (crf).
Calculate rf and crf. c. (1 pt.) Find a mean. d. (1 pt.)...
ONLY A TO C
ONLY A TO C
ONLY A TO C
ONLY A TO C
QUESTION 4 Crickets make a chirping noise by sliding their wings rapidly over each other. Perhaps you have noticed that the number of chirps seem to increase with the temperature. The following data list the temperature (in degrees Fahrenheit) and the number of chirps per second for striped cricket. Temperature, .x Chirps per second, 88.6 20.0 93.3 19.8 80.6 17.1 69.7 14.7 69.4 15.4...
1. Contin 1. Crickets make a chirping noise by sliding their wings rapidly over each other. Perhaps you have noticed that the number of chirps seems to increase with the temperature. The following data list the temperature (in degrees Fahrenheit) and the number of chirps per second for the striped ground cricket. Temperature, Chirps per Temperature, Chirps per Second, Second, 88.6 20.0 16.0 933 716 79.6 80. 6 16. 01 153 17.0 76. 3 144 Source: George W. Pierce. The...