Can I have some help with the following assignment? I have contacted Course hero twice about the below assignment and I keep getting a response that I am missing information. I have added all the information that I am given but no response from a tutor for the assignment below. Please advise. I have started working the assignment but have gotten stuck on how to find the yhat and the other formulas. Can you offer a step by step solution on how to find the y hat?

A soft-drink company monitored its television advertising over an eight-week period to evaluate the effect on sales (in millions of dollars) with respect to the number of 30-second spots aired in that week. Estimate the regression equation. The data are as follows:

Week 1 2 3 4 5 6 7 8

Number of Spots 8 12 16 10 8 12 16 10 Sales 25 34 39 32 22 30 43 31

• Estimate the regression line for sales on spots.
• Test whether the slope is significantly different from zero, using = 0.10.
• Compute S (the standard error of estimate, p. 218) and R2 (the coefficient of determination, p. 219) and interpret the results.
• The company has reserved 20 spots for Week Nine. Forecast the sales and construct a 90 percent prediction interval.
• Comment on the level of accuracy this analysis provides.