Question

Question: The data below were obtained to predict the sound frequency to which a person’s ear will respond ...

The data below were obtained to predict the sound frequency to which a person’s ear will respond based upon the length of time a person has been exposed to a high level of noise. Here “length of exposure” is the amount of time in weeks that a person has been living close to a major airport and the “hearing range” is reported in thousand cycles per second.

Length of exposure In weeks	Hearing range In thousand cycles per second
47	15.1
56	14.1
116	13.2
178	12.7
19	14.6
75	13.8
160	11.9
31	14.8
12	15.3
164	12.6
43	14.7
74	14.0

1. Find the correlation coefficient r.
2. Identify our x, explanatory variable and y, response variable and construct a scatter plot of y vs x.
3. Determine least squares equation that can be used for predicting a value of y based on a value of x.
4. Does this slope (in c) differ significantly from 0. Use alpha=0.05.
5. Use your model to predict y when x is i)5, ii)100.
6. Provide 95% confidence intervals for the means (e, ii).
7. Provide 95% prediction intervals for (e, ii).
8. Comment on your findings in (f) and (g).
1. What were the basic assumptions for the model in (c)?
10. Would you consider the model in (b) to be a good model? Why or why not?

PLEASE PROVIDE STEP BY STEP INSTRUCTIONS ON HOW TO FIND THE CONFIDENCE/PREDICTION INTERVALS. IF EXCEL CAN BE USED, PLEASE PROVIDE THE FORMULA AND STEPS USED.

Answer 1