Free

80.2K

Verified Solution

Link Copied!

Selling Price        LivingArea (Sq Feet)       No. Bathrooms NoBedrooms    Age (Years)

$240,000             2,022    2.5         3             20

$235,000             1,578    2             3             20

$500,075             3,400    3             3             20

$240,000             1,744    2.5         3             20

$270,000             2,560    2.5         3             20

$225,000             1,398    2.5         3             20

$280,000             2,494    2.5         3             20

$225,000             2,208    2.5         4             20

$248,220             2,550    2.5         3             20

$275,000             1,812    2.5         2             20

$137,000             1,290    1             2             20

$150,000             1,172    2             2             20

$649,000             4,128    3.5         3             20

$195,000             1,816    2.5         3             97

$373,200             2,628    2.5         4             20

$169,450             1,254    2.5         3             20

$144,200             1,660    1.5         4             20

$189,900             1,850    1.5         3             20

$166,000             1,258    2             3             20

$160,000             1,219    2             3             20

$327,355             1,850    2.5         3             20

$247,000             2,103    2.5         3             20

$318,000             1,806    2.5         3             20

$341,000             1,674    1.5         2             17

$288,650             2,242    2.5         3             20

$157,000             1,408    1.5         3             20

$449,000             3,457    2.5         3             21

$142,000             1,728    1.5         3             21

$389,000             2,354    2.5         3             21

$476,000             2,246    2.5         3             21

$249,230             1,902    2.5         2             21

$139,900             1,178    1             3             21

$301,900             2,896    3.5         4             21

$425,000             2,457    3             3             41

$121,000             936        1             3             50

$150,000             934        1             2             21

$138,000             1,279    1             3             21

$199,900             1,888    2             3             26

$145,000             1,686    1.5         4             21

$465,000             2,310    3             2             21

$158,000             1,200    1.5         3             21

1.            Develop a multiple linear regression model to predict the price ofa house using the square feet of living area, number of bedrooms,number of bathrooms, and age as the predictor variables.

1.            Write the reqression equation.
2.            Discuss the statistical significance of the model as a whole usingthe appropriate regression statistic at a 95% level ofconfidence.
3.             Discuss the statistical significance of the coefficient for eachindependent variable using the appropriate regression statistics ata 95% level of confidence.
4.            Discuss the statistical significance of the coefficient for eachindependent variable using the appropriate regression statistics ata 90% level of confidence.

2.            Develop a multiple linear regression model to predict the price ofa house using the square feet of living area, number of bedrooms,and number of bathrooms as the predictor variables.

1.            Write the reqression equation.
2.            Discuss the statistical significance of the model as a whole usingthe appropriate regression statistic at a 95% level ofconfidence.
3.             Discuss the statistical significance of the coefficient for eachindependent variable using the appropriate regression statistics ata 95% level of confidence.
4.            Interpret the coefficient for each independent variable.
5.            What percentage of the observed variation in housing prices isexplained by the model?
6.             Determine the prediction interval of a house with 3,000 square feetof living area, 3 bedrooms, and 2.5 bathrooms, and comment on theprediction interval.

3.            In Case Study No.1 you ran a simple linear regression model forpredicting the price of a house based upon its living area insquare feet using a 95% level of confidence. Rerun that simplelinear regression model for predicting the price of a house basedupon its living area in square feet using the Case study 2 datausing a 95% level of confidence. Compare the regression statisticsfor this simple linear regression model with the statistics for thepreceding multiple linear regression model using square feet ofliving area, number of bedrooms, and number of bathrooms as thepredictor variables. Which model is the preferred model at a 95%level of confidence? Use the Significance F values, p-values forthe independent variables, R-squared or Adjusted R-squared values(as appropriate), and standard errors to explain yourselection.

Prepare a single Microsoft Excel file to document yourregression analyses. Prepare a single Microsoft Word document thatoutlines your responses for each portion of the case study.