96%(27)26 out of 27 people found this document helpful
This preview shows page 1 - 2 out of 2 pages.
The preview shows page 1 - 2 out of 2 pages.
9/22/19BUSI 1013Emily ThompsonFinal ExamQuestion 1 (8 points)Shown below is a portion of an Excel output for regression analysis relating Y (dependentvariable) and X (independent variable).ANOVAdfSSRegression139947.80Residual (Error)108280.81Total1148228.61CoefficientsStandard Errort StatP-valueIntercept69.19026.9342.5690.02795X2.4410.3516.9460.000041.What is the estimated regression equation that relates Y to X? (2 Points)
Get answer to your question and much more
2.Is the regression relationship significant? Use the p-value approach and alpha = 0.05 toanswer this question. (