11-9 - 1.50 1.70 1.90 2.10 2.30 2.50 2.70 2.90 3.10 3.30...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Forecasting Home Selling Prices Forecasting Causal regression analysis Input Data Forecast Error Analysis Period Forecast Error Home 1 182.5 2.01 188.431 -5.931 5.931 35.178 3.25% Home 2 227.3 2.65 251.016 -23.716 23.716 562.460 10.43% Home 3 251.9 2.43 229.503 22.397 22.397 501.644 8.89% Home 4 325.2 2.89 274.486 50.714 50.714 2571.944 15.59% Home 5 225.1 2.55 241.237 -16.137 16.137 260.413 7.17% Home 6 315.0 3.00 285.242 29.758 29.758 885.510 9.45% Home 7 367.5 3.22 306.756 60.744 60.744 3689.818 16.53% Home 8 220.8 2.37 223.635 -2.835 2.835 8.039 1.28% Home 9 266.5 2.91 276.441 -9.941 9.941 98.832 3.73% Home 10 261.0 2.56 242.215 18.785 18.785 352.869 7.20% Home 11 177.5 2.25 211.901 -34.401 34.401 1183.396 19.38% Home 12 235.9 3.41 325.336 -89.436 89.436 7998.816 37.91% Average 30.400 1512.410 11.73% Intercept -8.125 MAD MSE MAPE Slope 97.789 SE 42.602 Forecast 295.0 3.10 Correlation 0.702 r-squared 0.493 Dep Variable (or) (Y) Indep Variable (or) (X) Absolute error Squared error Absolute % error Enter the (Y,X) pairs in cells shaded YELLOW. Enter new value of X at the bottom to forecast Y. Enter the (Y,X) pairs in cells shaded YELLOW. Enter new value of X at the bottom to forecast Y.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1.50 1.70 1.90 2.10 2.30 2.50 2.70 2.90 3.10 3.30 3.50 150.0 200.0 250.0 300.0 350.0 400.0 f(x) = 97.7892928172x - 8.125391113 Regression Line Independent Variable, X Dependent Variable, Y H o m e 1 2 3 4 5 6 7 8 9 150.000 200.000 250.000 300.000 350.000 400.000 Actual vs. Forecast Column B Column E Home Value Simple Regression Using Data Analysis SUMMARY OUTPUT Regression Statistics Multiple R 0.702 R Square 0.493 Adjusted R Square 0.443 Standard Error 42.602 Observations 12 ANOVA df SS MS F Regression 1 17670.281 17670.281 9.736 0.011 Residual 10 18148.916 1814.892 Total 11 35819.197 t Stat P-value Intercept-8.125 85.119-0.095 0.926 -197.781 181.531 Home size ('000 sq ft) 97.789 31.340 3.120 0.011 27.960 167.619 Signific-ance F Coeffi-cients Standard Error Lower 95% Upper 95%...
View Full Document

This note was uploaded on 12/10/2011 for the course INSY 4508 taught by Professor Graham during the Spring '10 term at Bentley.

Page1 / 4

11-9 - 1.50 1.70 1.90 2.10 2.30 2.50 2.70 2.90 3.10 3.30...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online