Crickets make a chirping noise by sliding their wings rapidly over each other. The following table lists the temperature (in C) and the number of chirps per second. We use the temperature to predict the chirps per second.[7 marks]

Temperature Chirps Per Second

31 20

34 19.8

27 17.1

21 14.7

26 15

25 14

a. Create the appropriate graph in Excel. Include the line of best fit and regression equation on the graph. Graphs should be done and labeled for full marks.[3 marks]

b. Use the regression equation you just obtained to predict the number of cricket chirps per second in Excel when the temperature is 30C. Express answer to 1 decimal place.[2 marks]

c. Calculate and interpret the coefficient of correlation in Excel. Express coefficient to 3 decimal places.[2 marks]