Statistic

profilegiumag
ClassWorkweek7.xlsx

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.8534839325485

Square feet

House Price

Sheet3