Question: Ch12A: Condo Case Multivariate Regression due Due 10/16 - 20 points Attached Files: File CONDO.xls (32 KB) File Ch12CondoCaseGettingStarted.xlsx (243.561 KB) Respond to The Condo
Ch12A: Condo Case Multivariate Regression due Due 10/16 - 20 points Attached Files: File CONDO.xls (32 KB) File Ch12CondoCaseGettingStarted.xlsx (243.561 KB) Respond to The Condo Sales Case starting on p778. Perform a descriptive analysis of the data with correlations and build and test a regression model. Write a brief business communication as a report. a common way to describe regression studies is to show the final regression equation (or at least the coefficients labeled by the variable values they multiply and R-square and discuss your interpretation - then in an appendix show the descriptive statistics and correlations, pointing out strong correlations - then show at least the initial regression with all the plots and mention potential problems - then briefly list.show any transformations what you did to improve R-square leading to the final model - it is not necessary to show all the intermediate regressions unless they show something interesting
CONDO:
PRICE100 FLOOR DISTANCE VIEW END FURNISH AUCTION
| 215 | 8 | 3 | 1 | 0 | 1 | 1 |
| 175 | 8 | 3 | 0 | 0 | 0 | 1 |
| 195 | 8 | 4 | 1 | 0 | 0 | 1 |
| 170 | 8 | 4 | 0 | 0 | 0 | 1 |
| 185 | 8 | 5 | 1 | 0 | 0 | 1 |
| 175 | 8 | 5 | 0 | 0 | 0 | 1 |
| 175 | 8 | 6 | 1 | 1 | 0 | 1 |
| 175 | 8 | 6 | 0 | 0 | 0 | 1 |
| 205 | 8 | 9 | 1 | 0 | 1 | 1 |
| 165 | 8 | 9 | 0 | 0 | 0 | 1 |
| 200 | 8 | 10 | 1 | 0 | 0 | 1 |
| 175 | 8 | 10 | 0 | 0 | 0 | 1 |
| 205 | 8 | 11 | 1 | 0 | 0 | 1 |
| 190 | 8 | 12 | 1 | 0 | 0 | 1 |
| 205 | 8 | 13 | 1 | 0 | 1 | 1 |
| 195 | 8 | 14 | 1 | 0 | 0 | 1 |
| 150 | 3 | 13 | 0 | 0 | 1 | 0 |
| 140 | 5 | 1 | 1 | 0 | 1 | 0 |
| 130 | 5 | 2 | 0 | 0 | 1 | 0 |
| 182 | 6 | 5 | 1 | 0 | 1 | 0 |
| 175 | 5 | 1 | 0 | 0 | 1 | 0 |
| 164 | 5 | 14 | 1 | 0 | 1 | 0 |
| 249 | 4 | 1 | 1 | 0 | 1 | 0 |
| 215 | 7 | 13 | 1 | 0 | 1 | 0 |
| 199 | 2 | 12 | 0 | 0 | 1 | 0 |
| 190 | 8 | 5 | 0 | 0 | 1 | 0 |
| 295 | 1 | 13 | 1 | 0 | 1 | 0 |
| 217 | 2 | 13 | 0 | 0 | 1 | 0 |
| 265 | 3 | 10 | 1 | 0 | 1 | 0 |
| 202 | 4 | 1 | 0 | 0 | 1 | 0 |
| 177 | 4 | 4 | 0 | 0 | 1 | 0 |
| 189 | 8 | 11 | 0 | 0 | 1 | 0 |
| 197 | 3 | 12 | 0 | 0 | 1 | 0 |
| 205 | 3 | 1 | 0 | 0 | 1 | 0 |
| 206 | 2 | 13 | 0 | 0 | 1 | 0 |
| 231 | 7 | 4 | 1 | 0 | 1 | 0 |
| 255 | 4 | 10 | 1 | 0 | 1 | 0 |
| 250 | 7 | 14 | 1 | 0 | 1 | 0 |
| 230 | 1 | 14 | 0 | 0 | 1 | 0 |
| 279 | 4 | 12 | 1 | 0 | 1 | 0 |
| 215 | 6 | 1 | 0 | 0 | 1 | 0 |
| 306 | 3 | 15 | 1 | 0 | 1 | 0 |
| 190 | 3 | 6 | 0 | 0 | 1 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help