The following data give the selling price square footage num

The following data give the selling price, square footage, number of bedrooms, and age of houses that 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

84,000     1670sq/ft 2 bedrooms age 30years

79000     1339sq/ft 2 bedrooms age 25 years

91500     1712sq/ft 3 bedrooms age 30 yrs

120000     1840sq/ft 2 bedrooms age 40 yrs

127500     2300sq/ft 3 bedrooms age 18 yrs

132500     2234sq/ft 3 bedrooms age 30 years

145000     2311sq/ft 3 bedrooms age 19 years

164000     2377sq/ft 3 bedrooms age 7 years

155000     2736sq/ft 4 bedrooms age 10 years

168000     2500sq/ft 3 bedrooms age 1 year

172500     2500sq/ft 4 bedrooms age 3 years

174000    2479sq/ft 3 bedrooms age 3 years

175000    2400sq/ft 3 bedrooms age 1 year

177500     3124sq/ft 4 bedrooms 0 years

184000     2500sq/ft 3 bedrooms 2 years

195500     4062sq/ft 4 bedrooms 10 years

195000     2854sq/ft 3 bedrooms 3 years  

Solution

excel is used to do the analysis.

For sq ft

For number of bedrooms

For age

The first model is the best fit because the r value there is high.