31 (a) Show calculations using the Data Analysis Add-In for Microsoft Excel (b) State answers within a complete sentence so that the understanding of applying the results of the computations can be shown. (c) Include work for the computations. Problem 31 (a) Show calculations using the Data Analysis Add-In for Microsoft Excel (b) State answers within a complete sentence so that the understanding of applying the results of the computations can be shown. (c) Based on the results of the computer output, discuss how accurate this model is. (d) Include work for the computations. Payroll ($Mil) Number of Victories 209.1 89 138.7 74 133.4 95 121.2 89 79 81 67.2 68 48 75 119.2 100 118 61 98.6 86 62.2 88 58.2 75 43.8 97 68.2 79 SUMMARY OUTPUT Regression Statistics Multiple R 0.1758 R Square 0.0309 Adjusted R Square -0.0499 Standard Error 11.6175 Observations 14 ANOVA df Regression Residual Total Intercept Payroll ($Mil) 1 12 13 Coefficients 78.3907 0.0436 SS MS 51.6325 51.6325 1619.5818 134.9651 1671.2143 Standard Error 7.5434 0.0705 F Significance F 0.3826 0.5478 t Stat P-value 10.3919 0.0000 0.6185 0.5478 Lower 95% Upper 95% Lower 95.0% 61.9549 94.8264 61.9549 -0.1100 0.1973 -0.1100 Upper 95.0% 94.8264 0.1973 Problem 31 (a) Show calculations using the Data Analysis Add-In for Microsoft Excel (b) State answers within a complete sentence so that the understanding of applying the results of the computations can be shown. (c) Based on the results of the computer output, discuss how accurate this model is. (d) Include work for the computations. Payroll ($Mil) Number of Victories 209.1 89 138.7 74 133.4 95 121.2 89 79 81 67.2 68 48 75 119.2 100 118 61 98.6 86 62.2 88 58.2 75 43.8 97 68.2 79 SUMMARY OUTPUT Regression Statistics Multiple R 0.1758 R Square 0.0309 Adjusted R Square -0.0499 Standard Error 11.6175 Observations 14 ANOVA df Regression Residual Total Intercept Payroll ($Mil) 1 12 13 Coefficients 78.3907 0.0436 SS MS 51.6325 51.6325 1619.5818 134.9651 1671.2143 Standard Error 7.5434 0.0705 F Significance F 0.3826 0.5478 t Stat P-value 10.3919 0.0000 0.6185 0.5478 Lower 95% Upper 95% Lower 95.0% 61.9549 94.8264 61.9549 -0.1100 0.1973 -0.1100 Upper 95.0% 94.8264 0.1973