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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started