2 5 6 7 5. 9 10 11 12 An analyst is given the task of interpreting the following data. Help her answer the questions. (20 marks) SUMMARY OUTPUT Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Statistics 0.850145561 0.722747474 0.707344556 404.5726843 20 df MS Regression 7680273.6 Residual 18 2946223.0 7680273.6 163679.06 46.9228 Significance F 2.073-06 Total 19 10626496.6 Coefficients Standard Error Intercept 948.7 187.9 Stot 5.048 P-value Lower 9506 Upper Lower Upper 95% 95.0% 95.09 0.00008 553.867 1343.5 553.867 1343.547 X1 Variable 107.5 15.7 6.850 0.0000021 74.507 140.4 74.507 140.428 10 11 12 Intercept 948.7 187.9 5.048 0.00008 553.867 1343.5 553.867 X1 Variable 107.5 15.7 6.850 0.0000021 74.507 140.4 74.507 a. Write down the regression model equation. (6 marks) b. What is the Y-intercept? (2 marks) c. Comment on the significance of each independent variable X1 and X2 at 1% level. (3.5+3.5-7 marks) Decision rule: X1: p-value Comment: d. Comment on the coefficient of determination. (5 marks) 2 3 4 5 6 9 10 11 12 An analyst is given the task of interpreting the following data. Help her answer the questions. (20 marks) SUMMARY OUTPUT Multiple R R Square Adjusted R Square Regression Statistics 0.850145561 0.722747474 0.707344556 Standard Error Observations 404.5726843 20 ANOVA df 55 Regression 1 7680273.6 MS 7680273.6 F 46.9228 Significance F 2.0736-06 Residual 18 Total 19 2946223.0 10626496.6 163679.06 Coefficients Standard Error Intercept 948.7 187.9 t Stat 5.048 P-value Lower 95% Upper 95%6 Lower Upper 95.0 95.0% 0.00008 553.867 1343.5 553.867 1343547 X1 Variable 107.5 15.7 6.850 0.0000021 74.507 140.4 74.507 140.428 1 2 3 4 5 6 7 9 10 11 12 Intercept 948.7 187.9 5.048 0.00008 553.867 1343.5 553.867 X1 Variable 107.5 15.7 6.850 0.0000021 74.507 140.4 74.507 a. Write down the regression model equation. (6 marks) b. What is the Y-intercept? (2 marks) c. Comment on the significance of each independent variable X1 and X2 at 1% level. (3.5+3.5-7 marks) Decision rule: X1: p-value, Comment: d. Comment on the coefficient of determination. (5 marks) TTT Arial 3(1200) T