**PLEASE COMPLETE IN EXCEL & SHOW FORMULA'S**

Outdoorsy people know that the crickets chirp faster when the temperature is warmer. Some evidence for this can be found in a book published in 1948 by Harvard physics professor George W. Pierce. Pierce's book includes the table below, which relates the average number of cricket chirps per minute to the temperature at which the data were recorded. Plot the data in an Excel graph and use regression to determine the approximate) relation between the number of chirps per second and the temperature. If you detect 19 chirps per second, what would you guess the temperature to be? What about 22 chirps a second? (We know this problem has nothing to do with finance, but it's interesting!) (y = 3.2911X+25.232; R^2 = 0.6975) Chirps per second 20.0 16.0 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15.0 17.2 16.0 17.0 14.4 Temperature in Farenheit 88.60 71.60 93.30 84.30 80.60 75.20 69.70 82.00 69.40 83.30 79.60 82.60 80.60 83.50 76.30