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. (