Managerial Statistics

Question 35 Not y 6 Excel was used to determine the least-squares regression equation. Part of the computer output is shown below. 2 ANOVA $5 MS F Significance F Regression 2 118.8474 59.4237 40.9216 0.0000 Residual 9 13.0692 1.4521 Total 11 131.9167 Coefficients Standard Error t Stat P-value Intercept 118.5059 33.5753 3.5296 0.0064 (x 1) -0.0163 0.0315 -0.5171 0.6176 (x2) -1.5726 0.3590 4.3807 0.0018 The equation that can be used to predict the price of the value of Y would be