Question
QUESTION 14 (House Selling Price) The data below show the selling price, square footage, bedrooms, and age of houses that have sold in a neighborhood
QUESTION 14
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of houses that have sold in a neighborhood in the last six months.
Selling price | Square footage | Bedrooms | Age |
64,000 | 1,670 | 2 | 30 |
59,000 | 1,339 | 2 | 25 |
61,500 | 1,712 | 3 | 30 |
79,000 | 1,840 | 3 | 40 |
87,500 | 2,300 | 3 | 18 |
92,500 | 2,234 | 3 | 30 |
95,000 | 2,311 | 3 | 19 |
113,000 | 2,377 | 3 | 7 |
115,000 | 2,736 | 4 | 10 |
138,000 | 2,500 | 3 | 1 |
142,500 | 2,500 | 4 | 3 |
144,000 | 2,479 | 3 | 3 |
145,000 | 2,400 | 3 | 1 |
147,500 | 3,124 | 4 | 0 |
144,000 | 2,500 | 3 | 2 |
155,500 | 4,062 | 4 | 10 |
165,000 | 2,854 | 3 | 3 |
Develop seven regression models as below using the corresponding Excel data. (Model 1) Y = selling price, X1 = square footage (House Selling Price Model 1 Data) (Model 2) Y = selling price, X2 = bedrooms (House Selling Price Model 2 Data) (Model 3) Y = selling price, X3 = age (House Selling Price Model 3 Data) (Model 4) Y = selling price, X1 = square footage, X2 = bedrooms (House Selling Price Model 4 Data) (Model 5) Y = selling price, X1 = square footage, X3 = age (House Selling Price Model 5 Data) (Model 6) Y = selling price, X2 = bedrooms, X3 = age (House Selling Price Model 6 Data) (Model 7) Y = selling price, X1 = square footage, X2 = bedrooms, X3 = age (House Selling Price Model 7 Data) (House Selling Price) ___ is the best for predicting the selling price of a house in this neighborhood.
A. | Model 4 | |
B. | Model 3 | |
C. | Model 2 | |
D. | Model 1 | |
E. | Model 6 | |
F. | Model 7 | |
G. | Model 5 |
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