betal [e10/d10] 0.40 Estimated grocery sales = 14 beta0 [b10-b14*(10] 0.907 y-hat = 2 +1.25X 3.28 Sum of Squares Period Y X (Y - Y-bar)^2 Y-hat (Y -Yhat)^2 (Y-hat - Y-bar)^2 6 15 16 14.0 64.00 16.0 4 9 36 8.56 20.78 2.1 16 40 36 36.67 427.43 711.5 6 20 16 18.53 157.12 72.8 13 25 9 23.07 101.40 170.8 9 25 1 23.07 197.96 170.8 10 15 0 14.00 16.00 16.0 16 35 36 32.14 260.48 490.2 10 23 150 1245.17 1650.2 Y-bar X-bar SST SSE SSR Coefficient of Determin: SSR/SST 1.33 Correlation coefficient cSORT of r-square 0.8066Question 1(b): Given the data on ads and grocery sales in question I(a), find the coefficient of determination. Calculate SST; SSE; and SSR. (Note: Round to three decimal places.) V X (Y-F) Y = bo + bix ( Y - Y ) ( Y - P ) 6.00 15.00 4.00 9.00 16.00 40.00 6.00 20.00 13.00 25.00 9.00 25.00 10.00 15.00 16.00 35.00 80.00 184.00 SST=? SSE=? SSR=? What is the coefficient of determination 12 = SSR/SST = ? What is coefficient of correlation? Question 1(c): Use Excel to run regression analysis for Table 1 data and interpret the results.Question I(a): The sales manager of a large departmental store feels the demand for groceries may be related to the number of newspaper ads placed during the previous month. He has collected the data shown in the accompanying table. Table 1. Ad and Sales Data Ads purchased, (X) Grocery Sales, (Y) 15 6 9 + 40 16 20 6 25 13 25 9 15 10 35 16 Calculate the following: Calculate EY and EX Calculate Y and X. Calculate E(X - X ) and E(X-X)(Y-F ) Calculate bi and bo and Y If the next number of ads purchased is 30, estimate grocery sales with the regression equation. (Note: Round to three decimal places.) Sales, Y Ads, X ( X-X )' ( X - X)( Y-F) 6 15 9 16 40 6 20 13 25 25 10 15 16 35 EY = EX = E(X- XY = E( X - X)( Y - Y ) =Ad and Sales Data Period Y X (X - X-bar)^2 (X - X-bar) (Y - Y-bar) 6 15 64 32 4 9 196 84 16 40 289 102 20 9 12 DO YOUIA WN P 13 25 4 6 9 25 4 -2 10 15 64 0 16 35 144 72 10 23 774 306 Y-bar X-bar sum of (X - X-bar) Sum of (X - X-bar)(Y - Y-bar) betal [e10/d10] 0.40 Estimated grocery sales = 14 beta0 [b10-b14*c10] 0.907 y-hat = 2 + 1.25X 3.28