Question
The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the past
The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the past 6 months. Develop three regression models to predict the selling price based upon each of the other factors individually. Which of these is best?
SELLING PRICE ($) | SQUARE FOOTAGE | BEDROOMS | AGE (YEARS) |
---|---|---|---|
84,000 | 1,670 | 2 | 30 |
79,000 | 1,339 | 2 | 25 |
91,500 | 1,712 | 3 | 30 |
120,000 | 1,840 | 3 | 40 |
127,500 | 2,300 | 3 | 18 |
132,500 | 2,234 | 3 | 30 |
145,000 | 2,311 | 3 | 19 |
164,000 | 2,377 | 3 | 7 |
155,000 | 2,736 | 4 | 10 |
168,000 | 2,500 | 3 | 1 |
172,500 | 2,500 | 4 | 3 |
174,000 | 2,479 | 3 | 3 |
175,000 | 2,400 | 3 | 1 |
177,500 | 3,124 | 4 | 0 |
184,000 | 2,500 | 3 | 2 |
195,500 | 4,062 | 4 | 10 |
195,000 | 2,854 | 3 | 3 |
4-23 Use the data in Problem 4-22 and develop a regression model to predict selling price based on the square footage and number of bedrooms. Use this to predict the selling price of a 2,000-square-foot house with three bedrooms. Compare this model with the models in Problem 4-22. Should the number of bedrooms be included in the model? Why or why not?
4-24 Use the data in Problem 4-22 and develop a regression model to predict selling price based on the square footage, number of bedrooms, and age. Use this to predict the selling price of a 10-year-old, 2,000-square-foot house with three bedrooms.
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