How much of the variation in the sample values of Sales does the model estimated in part (b) explain? Round your answer to two decimal places.

Analytical problems

Complete the 6 problems attached following the next guidelines:

1.Use formulas or functions in the spreadsheet to answer your questions.

2. Must show work for credit.

3. Answer all questions. Clearly identify your answers to each question part with a solid thick border around it.

4. Answer open ended questions in a comment or text box.

 PROBLEMS TO BE SOLVED:

b. How much of the variation in the sample values of Sales does the model estimated in part (b) explain? Round your answer to two decimal places.

c. Suppose that the population is 15. Estimate the Sales for your data. Zero decimal places

d. Preform a hypothesis test for the model with an significance of 0.05. State your conclusion. Put the two images below that you use with this test.

e. Preform a hypothesis test for each of the estimated coefficients being statistically different from zero at the 0.05 level of significance. State your conclusions. Put the two images below that you use with this test.

Last Completed Projects