Question: How do you run a multiple regression analysis on the below dataset with missing data? Home price should be the dependent variable and the rest
How do you run a multiple regression analysis on the below dataset with missing data? Home price should be the dependent variable and the rest would be independent variables.
| Price | Beds | Baths | Square Feet | Acres | Years Old | DoM |
| 330 | 3 | 2 | 1771 | 0.23 | 4 | 127 |
| 416 | 3 | 2.5 | 1884 | 0.18 | 16 | 105 |
| 420 | 3 | 2 | 1922 | 0.29 | 103 | |
| 496 | 4 | 2.5 | 1858 | 0.52 | 9 | 39 |
| 230 | 2 | 1200 | 21 | 211 | ||
| 448 | 3 | 2 | 2002 | 0.18 | 18 | 126 |
| 160 | 1 | 768 | 0.29 | 37 | 67 | |
| 252 | 3 | 2 | 1160 | 17 | ||
| 372.6 | 2 | 2 | 1300 | 0.67 | 158 | |
| 378 | 3 | 2.75 | 1816 | 0.1 | 18 | 191 |
| 474 | 4 | 2.5 | 1700 | 0.25 | 19 | |
| 165 | 2 | 1440 | 0.45 | 62 | ||
| 228 | 4 | 1598 | 0.32 | 14 | 45 | |
| 290 | 4 | 2 | 3250 | 0.5 | 19 | 94 |
| 290 | 2 | 1.75 | 1040 | 26 | 126 | |
| 312 | 4 | 1348 | 0.11 | 23 | 121 | |
| 320 | 3 | 2 | 2000 | 1 | 4 | 20 |
| 384 | 3 | 2 | 2160 | 0.125 | 20 | 54 |
| 420 | 3 | 2.5 | 2240 | 0.25 | 13 | 87 |
| 235 | 2 | 2 | 1590 | 0.49 | 15 | 54 |
| 300 | 3 | 2 | 1456 | 0.24 | 172 | |
| 321 | 4 | 2.5 | 1600 | 19 | 16 | |
| 364 | 3 | 2.75 | 2100 | 0.125 | 20 | 126 |
| 518 | 2016 | 0.68 | 23 | 63 | ||
| 388 | 3 | 2 | 2464 | 0.96 | 3 | 61 |
| 190 | 2 | 1058 | 0.5 | 62 | ||
| 300 | 2 | 2 | 1500 | 0.25 | 35 | 92 |
| 330 | 4 | 2 | 2000 | 0.33 | 15 | 45 |
| 470 | 4 | 2.5 | 1800 | 0.24 | 12 | 76 |
| 530 | 4 | 2700 | 1.2 | 15 | 85 | |
| 660 | 4 | 2950 | 0.67 | 4 | 135 | |
| 524 | 3 | 2755 | 0.23 | 23 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
