Researchers studying pleasant touch sensations measured the firing frequency (impulses per second) of nerves that were stimulated by a lightbrushing stroke on the forearm and also recorded the subject's numerical rating of how pleasant the sensation was. The accompanying data wasread from a graph in a paper.Firing Frequency23242225t =262934343534Pleasantness Rating0.11.01.21.21.02.02.32.22.52.7(a) Estimate the mean change in pleasantness rating associated with an increase of 1 impulse per second in firing frequency using a 95%confidence interval. (Use technology to find the critical value. Round your answers to three decimal places.)Interpret the resulting interval.O We are 95% confident that the mean change in pleasantness rating associated with an increase of 1 impulse per second in firingfrequency is outside this interval.O We are 95% confident that the mean change in pleasantness rating associated with an increase of 1 impulse per second in firingfrequency is in this interval.O We are 95% confident that the mean change in firing frequency associated with an increase of 1 in pleasantness rating is outside thisinterval.O We are 95% confident that the mean change in firing frequency associated with an increase of 1 in pleasantness rating is in this interval.(b) Carry out a hypothesis test using a = 0.05 to decide if there is convincing evidence of a useful linear relationship between firing frequencyand pleasantness rating.Calculate the test statistic. (Round your answer to two decimal places.)Use technology to find the P-value for this test. (Round your answer to four decimal places.)P-value =What can you conclude?Fail to reject Ho. We do not have convincing evidence of a useful linear relationship between firing frequency and pleasantness rating.O Reject Ho. We have convincing evidence of a useful linear relationship between firing frequency and pleasantness rating.O Fail to reject Ho. We have convincing evidence of a useful linear relationship between firing frequency and pleasantness rating.O Reject Ho. We do not have convincing evidence of a useful linear relationship between firing frequency and pleasantness rating.

Question

Accepted Answer

By using excel regression 
Excel> data> data analysis> Regression> alpha0.05> input…