Statistic
Sheet2
| House Price | Square feet | ||||||||||
| 245 | 1400 | ||||||||||
| 312 | 1600 | SUMMARY OUTPUT | |||||||||
| 279 | 1700 | ||||||||||
| 308 | 1875 | Regression Statistics | |||||||||
| 199 | 1100 | Multiple R | 0.7621137132 | ||||||||
| 219 | 1550 | R Square | 0.5808173119 | ||||||||
| 405 | 2350 | Adjusted R Square | 0.5284194759 | ||||||||
| 324 | 2450 | Standard Error | 41.3303236503 | ||||||||
| 319 | 1425 | Observations | 10 | ||||||||
| 255 | 1700 | ||||||||||
| ANOVA | |||||||||||
| df | SS | MS | F | Significance F | |||||||
| Regression | 1 | 18934.934775692 | 18934.934775692 | 11.0847576166 | 0.0103940164 | ||||||
| Residual | 8 | 13665.565224308 | 1708.1956530385 | ||||||||
| Total | 9 | 32600.5 | |||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| Intercept | 98.2483296214 | 58.0334785847 | 1.6929595126 | 0.1289188121 | -35.5771118647 | 232.0737711075 | -35.5771118647 | 232.0737711075 | |||
| Square feet | 0.1097677378 | 0.0329694433 | 3.3293779624 | 0.0103940164 | 0.0337400654 | 0.1857954103 | 0.0337400654 | 0.1857954103 | |||
| RESIDUAL OUTPUT | |||||||||||
| Observation | Predicted House Price | Residuals | |||||||||
| 1 | 251.9231625835 | -6.9231625835 | |||||||||
| 2 | 273.8767101495 | 38.1232898505 | |||||||||
| 3 | 284.8534839325 | -5.8534839325 | |||||||||
| 4 | 304.0628380528 | 3.9371619472 | |||||||||
| 5 | 218.9928412345 | -19.9928412345 | |||||||||
| 6 | 268.388323258 | -49.388323258 | |||||||||
| 7 | 356.2025135221 | 48.7974864779 | |||||||||
| 8 | 367.1792873051 | -43.1792873051 | |||||||||
| 9 | 254.6673560293 | 64.3326439707 | |||||||||
| 10 | 284.8534839325 | -29.8534839325 |
Square feet Line Fit Plot
House Price 1400 1600 1700 1875 1100 1550 2350 2450 1425 1700 245 312 279 308 199 219 405 324 319 255 Predicted House Price 1400 1600 1700 1875 1100 1550 2350 2450 1425 1700 251.92316258351892 273.87671014953867 284.8534839325485 304.06283805281578 218.99284123448933 268.38832325803372 356.20251352211261 367.1792873051225 254.66735602927139 284.8534839325485Square feet
House Price