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
A biologist wishes to determine if there is a relationship between temperature and the number of...
2. (Sheet #2) (10 points) The table represents the Temperature in Fahrenheit and the number of cricket chirps per sec. Temp (x) 88.6 71.6 93.3 84.3 75.2 82 69.4 83.3 79.6 80.6 Chirps (y) 20 16 19.8 18.4 15.5 17.1 15.4 16.2 15 16 c. a. (2 pts) Create a scatter plot. b. (2 pts) Add a trendline with an equation and the coefficient of determination. Calculate the correlation coefficient. (2 pts) How do you describe the correlation between the...
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...
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)....
3. Naturalists have long known that you can use the rate at which crickets chirp to predict the temperature. Below are some data. Enter them in your trusty T Chirps in 1 minutes 882 1188 | 1104864 1200 ) 1032 1960 9oo Temperature (F69.7 93.3 84.3 76.3 88.6 82.6 716 79.6 a) What would be a good window for a scatter plot? b) Using that window, sketch the scatter plot. c). Find the equation of the regression bie d). Is...
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.)...
Steps Open the Heart Rate Dataset in Excel Using the classification of variables from Unit 1 assignment as qualitative, quantitative discrete, or quantitative continuous, match each of the 3 variables to the most appropriate graph type. (For example, qualitative data can best be displayed with a pie chart or bar graph; continuous numerical data can best be displayed using a histogram) Use the graphing functions in Excel to create an appropriate graph of the data for each variable. Remember to...