Regression Statistics Multiple R 0.963342 R Square 0.928028 Adjusted R Square 0.913633 Standard 211.8374 Observations 13 ANOVA Significance df SS MS F F Regression 2 5786307 2893154 64.47129 1.93118E-06 Residual 10 448750.7 44875.07 Total 12 6235058 Standard Lower Coefficients Error t Stat P-value 95% 95% 95.0% Upper 95.0% Intercept 4599.576 1877.489 2.449855 0.034266 416.2699729 8782.882 416.27 8782.882062 Stock A 29.66921 39.44523 0.752162 0.469288 117.5586 -58.2202 117.5586475 Stock B 158.1959 14.20348 11.13783 5.87E-07 126.5485815 189.8432 126.5486 189.8432218 Analyze these 3 regressions to determine: Which is the most meaningful regression to determine the DJIA only stock A, only stock B or both stock A and B – Base your answer on an analysis of r, r2, adjusted r2, significance F and p-value where applicable. What are the regression equations for each ANOVA?
Regression Statistics Multiple R 0.963342 R Square 0.928028 Adjusted R Square 0.913633 Standard 211.8374 Observations 13 ANOVA df SS MS F Significance F Regression 2 5786307 2893154 64.47129 1.93118E-06 Residual 10 448750.7 44875.07 Total 12 6235058 Coefficients Standard Error t Stat P-value 95% 95% Lower 95.0% Upper 95.0% Intercept 4599.576 1877.489 2.449855 0.034266 416.2699729 8782.882 416.27 8782.882062 Stock A 29.66921 39.44523 0.752162 0.469288 117.5586 -58.2202 117.5586475 Stock B 158.1959 14.20348 11.13783 5.87E-07 126.5485815 189.8432 126.5486 189.8432218 Analyze these 3 regressions to determine: Which is the most meaningful regression to determine the DJIA – only stock A, only stock B or both stock A and B Base your answer on an analysis of r, r2, adjusted r2, significance F and p-value where applicable. What are the regression equations for each ANOVA?
SampleRegressionQuestion.docx