A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid in long-term planning, she gathers the following sales and advertising information from twelve of the companies for 2012 (in $ millions). Solve by excel and mega stat and answer the following questions:

 

ADVERTISING

SALES

12.5

148

3.7

55

21.6

338

60.0

994

37.6

541

6.1

89

16.8

126

41.2

18.4

26.3

48.7

58.4

379

232

312

442

513

 

 

1)                  Is the regression statistically significant? Let α = .05. Test for statistical significance by using both the critical t value and the p-value. What do you conclude?

2)                  Indicate the regression equation. If x = 40 what is an estimate for ŷ.

3)                  What is the Standard Error of the Estimate, Se.

4)                  What arethe 95% confidence and prediction intervals for the values of ŷ for X = 40.Interpret these intervals.

5)                  What isthe correlation coefficient,Interpret.

6)                  What is the coefficient of determination,Interpret.

7)                  Verify the coefficient of determination from the ANOVA table values.(Show the calculation).

8)                  Verify the standard error of the estimate from the ANOVA table values.(Show the                 calculation).

9)                  Verify the adjusted coefficient of determination from the ANOVA table values. (Show the calculation).

    • 7 years ago
    100% ACCURATE ANSWER RELIABLE A++ TUTORIAL PLAGIARISM FREE PERFECT GUIDE
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      assigned_problem.docx