Chapter 3 Regression demonstrations

Chapter 3 Regression demonstrations - LINEST $ 500,000 $...

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

View Full Document Right Arrow Icon
Lot number House Price Trend Residuals SUMMARY OUTPUT 145 2620 $266,500 281020 -14520 144 2635 $266,900 283927 -17027 Regression Statistics 119 3019 $364,500 358339 6161 Multiple R 0.9490215179 136 3049 $384,900 364152 20748 R Square 0.9006418414 7 3141 $389,900 381980 7920 Adjusted R Square 0.8882220716 114 3141 $399,900 381980 17920 Standard Error 20997.6710326837 97 3264 $439,000 405815 33185 Observations 10 90 3319 $405,000 416473 -11473 108 3403 $414,500 432751 -18251 ANOVA 200 3578 $442,000 466663 -24663 df SS MS F Significance F Regression 1 31972811489.63 31972811490 72.51679012 2.777838E-005 Residual 8 3527217510.374 440902188.8 Total 9 35500029000 Coef icients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -226688.024728376 71237.89072053 -3.18212713 0.0129559346 -390962.89531 -62413.15414 -390962.8953 -62413.15414 b a House Size (ft2) 193.7816499498 22.7558657652 8.5156790758 2.77784E-005 141.306529395 246.2567705 141.30652939 246.2567705 LINEST 193.7816 -226688 Correlation Coefficient 0.949022 RESIDUAL OUTPUT R-square 0.900642 Observation Predicted House Price Residuals 1 281019.898139969 -14519.89814 2 283926.622889215 -17026.6228892 3 358338.776469919 6161.223530081
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Chapter 3 Regression demonstrations - LINEST $ 500,000 $...

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

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