SST SSR Calculation
xoon
bs350_unit_4_assignment_data.xlsxHospital Data
| Y: Total Expenses (millions) | X: Admissions (thousands) | (X-X)² | (X-X) (Y-Y) | ||
| 57 | 77 | (77-77)²= | 0 | (77-77)(57-53) = | 0 |
| 127 | 160 | (160-77)²= | 6889 | (160-77)(127-53)= | 6142 |
| 157 | 230 | (230-77)²= | 23409 | (230-77)(157-53) = | 15912 |
| 24 | 43 | (43-77)²= | 1156 | (43-77)(24-53)= | 986 |
| 14 | 9 | (9-77)²= | 4624 | (9-77)(14-53)= | 2652 |
| 93 | 155 | (155-77)²= | 6084 | (155-77)(93-53) = | 3120 |
| 45 | 53 | (53-77)²= | 576 | (53-77)(45-53) = | 192 |
| 6 | 6 | (6-77)²= | 5041 | (6-77)(6-53) = | 3337 |
| 99 | 159 | (159-77)²= | 6724 | (159-77)(99-53) = | 3772 |
| 12 | 18 | (18-77)²= | 3481 | (18-77)(12-53) = | 2419 |
| 11 | 16 | (16-77)²= | 3721 | (16-77)(11-53) = | 2562 |
| 15 | 29 | (29-77)²= | 2304 | (29-77)(15-53) = | 1824 |
| 21 | 28 | (28-77)²= | 2401 | (28-77)(21-53) = | 1519 |
| 63 | 98 | (98-77)²= | 441 | (98-77)(63-53)= | 210 |
| ΣY = 53 | ΣX = 77 | Σ(X-X)²= | 4775.0714285714 | Σ(X-X)(Y-Y)= | 3189.0714285714 |
| b₁ = | 0.67 | ||||
| b₀ = | 1.41 | ||||
| Ῠ= | 1.41+.67X |
Housing Data
| Y | X1 | X2 |
| Selling Price ($) | Square Feet | Age (Years) |
| 64000 | 1670 | 30 |
| 59000 | 1339 | 25 |
| 61500 | 1712 | 30 |
| 79000 | 1840 | 40 |
| 87500 | 2300 | 18 |
| 92500 | 2234 | 30 |
| 95000 | 2311 | 19 |
| 113000 | 2377 | 7 |
