Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / The following data give the selling price square footage number of bedrooms, and age of h...

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

 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 (in excel) 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

2) Use the data in Problem 1 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 3 bedrooms.
Compare this model with the models in Problem 1. Should the number of bedrooms
be included in the model? Why or why not?

Jun 19 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions