11-10 - Regress button 1 2 3 4 5 6 7 8 9 10 11 12 150.000...

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

View Full Document Right Arrow Icon
Forecasting Home Selling Prices (Revisited) Forecasting Multiple regression Input Data Forecast Error Analysis Y x 1 x 2 Forecast Error Home 1 182.5 2.01 0.40 188.912 -6.412 6.412 41.113 3.51% Home 2 227.3 2.65 0.60 225.603 1.697 1.697 2.879 0.75% Home 3 251.9 2.43 0.65 226.650 25.250 25.250 637.540 10.02% Home 4 325.2 2.89 1.10 288.250 36.950 36.950 1365.287 11.36% Home 5 225.1 2.55 0.75 240.719 -15.619 15.619 243.966 6.94% Home 6 315.0 3.00 1.50 336.614 -21.614 21.614 467.178 6.86% Home 7 367.5 3.22 1.70 364.325 3.175 3.175 10.083 0.86% Home 8 220.8 2.37 0.45 202.361 18.439 18.439 339.979 8.35% Home 9 266.5 2.91 0.80 254.169 12.331 12.331 152.055 4.63% Home 10 261.0 2.56 1.00 269.691 -8.691 8.691 75.528 3.33% Home 11 177.5 2.25 0.50 205.547 -28.047 28.047 786.632 15.80% Home 12 235.9 3.41 0.70 253.358 -17.458 17.458 304.771 7.40% Average 16.307 368.918 6.65% Regression Line MAD MSE MAPE Intercept 99.919 Slopes 21.383 115.030 SE 22.179 multiple-r 0.936 r-squared 0.876 Absolute error Squared error Absolute % error Enter the data in the cells shaded YELLOW. Then click the Regress button. Enter the data in the cells shaded YELLOW. Then click the
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: Regress button. 1 2 3 4 5 6 7 8 9 10 11 12 150.000 200.000 250.000 300.000 350.000 400.000 Actual vs. Forecast Column B Column F Home Value Multiple Regression Using Data Analysis SUMMARY OUTPUT Regression Statistics Multiple R 0.936 R Square 0.876 Adjusted R Square 0.849 Standard Error 22.179 Observations 12 ANOVA df SS MS F Regression 2 31392.185 15696.093 31.910 0.000 Residual 9 4427.011 491.890 Total 11 35819.197 t Stat P-value Intercept 99.919 48.807 2.047 0.071-10.490 210.329 (X1) Home size ('000 sq ft) 21.383 21.805 0.981 0.352-27.944 70.710 (X2) Land area (acres) 115.030 21.779 5.282 0.001 65.762 164.297 Signific-ance F Coeffi-cients Standard Error Lower 95% Upper 95% (Y) Selling price ($'000) 1.000 (X1) Home size ('000 sq ft) 0.702 1.000 (X2) Land area (acres) 0.929 0.663 1.000 (Y) Selling price ($'000) (X1) Home size ('000 sq ft) (X2) Land area (acres)...
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-10 - Regress button 1 2 3 4 5 6 7 8 9 10 11 12 150.000...

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