*Please use Excel for this whole question!*

Ithas been said that one can use cricket chirps to estimate temperature. For this question use the following set of data points

Chirps in 1 minute	882	1188	1104	864	1200	1032	960	900
Temperature (F)	69.7	93.3	84.3	76.3	88.6	82.6	71.6	79.6

(a) Obtain a scatterplot of the data.

(b) Find the correlation coefficient.

(c) Follow the steps below to perform a hypothesis test to determine if the linear correlationis significantly different from 0 at the 5% level.

i. State the null and alternate hypothesis.

ii. Use the r value from your Excel output to compute the t test statistic as describedon page 543.

iii. State the appropriate degrees of freedom.

iv. Use Excel to find the pvalue for determining whether the correlation coefficient is significantly different from 0.

v. Based on the pvalue, do we to reject or not reject the null hypothesis? What can you say about the existence of a linear relationship between cricket chirps per minute and temperature (F)?

(d) Use Excels Data Analysis to obtain the regression analysis.

(e) State the regression equation. Provide a brief sentence that interprets the value of the slope.

(f) Find the best predicted value when a cricket chirps 3000 times in 1 minute. What is wrong with this predicted value?