Exercise for the Final (not graded] Ten sales regions of equal sales potential for a company were randomly selected. The advertising expenditures {in units o1$10,000} in these 10 sales regions were purposer set dun'ng July o1 last year at, respectively, 5, 6, T, 8, 9', 10, 11, 12, 13 and 14. The sales volumes (in units of$10,000] were then recorded for the 10 sales regions and found to be, respectively, 113, 116, 106, 105, 129, 114, 110, 110, 104, and 103. Assuming that the simple linear regression model is appropriate, it can be shown that be = 119.856?, in = -.9333. a] Is the slope signicant? Conduct a formal critical value test, and a formal P va lue test. b} Is the F test signicant? (2} Can you predict 1-; when X is 1? If yes, what is your prediction? (1] Can you predict 1.; when X is 11? If yes, what is your prediction? The following table is the output of multiple linear regression analysis. ANOVA SS dl MS F pvalue Regression 19,752.5919 1 19,762.5919 532.31 .0000 Residual 334.1354 9 311252 Total 20,096.727310 {a} Use the table to report the F statistic. What is its degrees offreedom? What is the number of observations? {b} Find the pvalue related to F on the computer output and report its value. Using the p-value, test the signicance of the regression model at the .10, .05, .01, and .001 levels of signicanoe. What do you conclude? 11-IE FUEL CDNSUMPHDN CASE Using the appropriate model, sample size n, and output below: Model: y = n + ora +1332 + r: Sample size: n = B S = .5561 RSq = 93.1% RSq(adj) = 90.3% Analysis of Variance Source DF 33 MS F P Regression 2 20.8141 10.40?0 33.66 .0013 Rem\" 5 1.5459 .3592 Error Total 1' 22.3500 {1] Report SSE, 32, and 5 as shown on the output. Calculate 52 from SSE and other numbers. {Round your answers to 4 decimal plaoes.] {2] Report the total variation, unexplained variation, and explained variation as shown on the output. [Round your answers to 3 decimal places.] Total variation 22-39\" Unexplained variation -5\"'5 WT Explained variation 20-314 {3] Report R2 and adjusted RE shown on the output. {Round your answers to 3 decimal places.} {4] Calculate the F_sta]istic. {T} Find the pvalue related to F_nn the output. Using the pvalue, test the signicance of the linear regression model by setting I: = .10, .05, .01, and .001