USE ECXEL FORMULAS

The owner of Showtime Movie Theaters, Inc., would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Television Advertising ($1000S) 3.5 2.5 4 2.5 Predictor Constant Newspaper Advertising ($1000S) 3.3 2.3 4.2 1.5 2 1.5 2.5 2.5 Weekly Revenue ($1000S) Television Advertising ($1000s) Newspaper Advertising ($1000s) 0.642587 R sq - 91.9* R lysis of Variance 98 97 97 93 98 95 97 Coeff 86.230 2.2902 1.3010 Sg (adj ) SE coef . 574 c. 3041 c. 3207 gg.7* 0.002 54.79 7.53 4.06 o. ccc o. CCI o. CIO Source Regress zon Residual Error Total Source ss 23.435 25. soo seq SS 16.640 Television Advertising ($1000s) Newspaper Advertising ($1000s) 1 1 a) b) c) d) e) t) g) h) Write down what the estimated regression equation is that relates weekly revenue equation with both television advertising and newspaper advertising as the independent variables. Interpret the slope coefficients for each of the independent variables. Complete the ANOVA Table Conduct Hypothesis tests on Regression and Individual coefficients at 0.05 level of significance. What are the values of Coefficient of Multiple Determination and Adjusted Coefficient of Multiple Determination? Comment on Goodness of Fit between the dependent variable and the two independent variables. How are R-Sq and R-Sq (adj) calculated? What is the gross revenue expected for a week when $3500 is spent on television advertising and S 1800 is spent on newspaper advertising?