{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 3 Regression demonstrations

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

This preview shows pages 1–3. Sign up to view the full content.

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 Coefficients 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 4 364152.225968412 20747.77403159 5 381980.137763789 7919.862236211 6 381980.137763789 17919.86223621 7 405815.280707608 33184.71929239 8 416473.271454844 -11473.2714548 9 432750.930050624 -18250.9300506 10 466662.71879183 -24662.7187918 House Size (ft 2 ) 2500 2700 2900 3100 3300 3500 3700 \$0 \$50,000 \$100,000 \$150,000 \$200,000 \$250,000 \$300,000 \$350,000 \$400,000 \$450,000 \$500,000 f(x) = 193.7816499498x - 226688.024728376 R² = 0.9006418414 House Size (sq ft) House Price (\$) 2500 2700 2900 3100 3300 3500 3700 -30000 -20000 -10000 0 10000 20000 30000 40000 Residuals 2400 2600 2800 3000 3200 3400 3600 3800 -30000 -20000 -10000 0 10000 20000 30000 40000 House Size (ft2) Residual Plot House Size (ft2) Residuals

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

View Full Document
Lot number House Price 145 2620 \$51,500 \$266,500 144 2635 \$52,000 \$266,900 119 3019 \$72,500 \$364,500 136 3049 \$82,000 \$384,900 7 3141 \$67,000 \$389,900 114 3141 \$72,500 \$399,900 97 3264 \$78,000 \$439,000 90 3319 \$68,500 \$405,000 108 3403 \$58,000 \$414,500 200 3578 \$78,000 \$442,000 a LINEST 1.6915738273 158.1707885899 -230719.55121 SUMMARY OUTPUT
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

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

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

View Full Document
Ask a homework question - tutors are online