Question

In: Statistics and Probability

There are numerous variables that are believed to be predictors of housing prices, including living area...

There are numerous variables that are believed to be predictors of housing prices, including living area (square feet), number of bedrooms, and number of bathrooms. The data in the Case Study No. 2.xlsx file pertains to a random sample of houses located in a particular geographic area.

  1. Develop the following simple linear regression models to predict the sale price of a house based upon a 90% level of confidence. Write the regression equation for each model.
    1. Sale price based upon square feet of living area.
    2. Sale price based upon number of bedrooms.
    3. Sale price based upon number of bathrooms.
  2. Develop the following multiple linear regression models to predict the sale price of a house based upon a 90% level of confidence. Write the regression equation for each model.
    1. Sale price based upon square feet of living area and number of bedrooms.
    2. Sale price based upon square feet of living area and number of bathrooms.
    3. Sale price based upon number of bedrooms and number of bathrooms.
    4. Sale price based upon square feet of living area, number of bedrooms, and number of bathrooms.
  3. Discuss the joint statistical significance of each of the preceding simple and multiple linear regression models at a 90% level of confidence and 95% level of confidence.
  4. Discuss the individual statistical significance of the coefficient for each independent variable for each of the preceding simple and multiple linear regression models at a 90% level of confidence and 95% level of confidence.
  5. Compare any of the preceding simple and multiple linear regression models that were found to be jointly and individually statistically significant at a 90% level of confidence and select the preferred regression model. Explain your selection using the appropriate regression statistics.
  6. Interpret the coefficient for each independent variable (or variables) associated with your selected preferred regression model.
  7. Using the preferred regression model, predict the sale price of a house with the following values for the independent variables: 3,000 square feet of living area, 3 bedrooms, and 2.5 bathrooms.

Prepare a single Microsoft Excel file using a separate worksheet for each question and upload your Excel file for grading via the Blackboard submission link.

Selling Price Living Area (Sq Feet) No. Bathrooms No Bedrooms
$145,000 1,152 1 2
$103,000 1,290 1.5 3
$210,000 2,396 1.5 4
$559,000 3,090 4 4
$218,000 1,428 1 3
$262,138 1,631 2.5 3
$125,000 1,368 1 3
$130,000 1,134 1 3
$157,500 1,697 1.5 3
$193,000 1,666 2.5 3
$275,000 1,738 2.5 4
$240,000 1,457 1.5 2
$200,136 1,632 2.5 3
$395,000 2,186 2.5 3
$366,703 2,117 2.5 3
$103,150 936 1 3
$310,000 3,347 2.5 6
$142,900 1,824 2.5 4
$359,770 2,592 3 3

Solutions

Expert Solution

a.Sale price based upon square feet of living area.

The regression equation is given by

Y = 142.2543959X - 23064.61598

Y = Sales price in dollars

X = Square feet of living area.

b.Sale price based upon number of bedrooms.

The regression equation is given by

Y = 40113.90385X + 105696.5769

Y = Sales price in dollars

X = No of Bedrooms

c.Sale price based upon the number of bathrooms

The regression equation is given by

Y = 113369.8846X + 9854.809717

Y = Sales price in dollars

X = No of Bathrooms

a.Sale price based upon square feet of living area and number of bedrooms.

Regression equation is given by

Y = 213.9101105X1 - 74833.98496X2 + 90336.18553

Y = Sales price in dollars

X1 = Square feet of living area.

X2 = No of Bedrooms

b.Sale price based upon square feet of living area and number of bathrooms.

Regression equation is given by

Y = 73.07796607X1 + 71746.36155X2 - 40288.5095

Y = Sales price in dollars

X1 = Square feet of living area.

X2 = No of Bathrooms

c.Sale price based upon the number of bedrooms and number of bathrooms.

Regression equation is given by

Y = -6569.109081X1 + 116149.1231X2 + 25732.37296

Y = Sales price in dollars

X1 = No of Bedrooms

X2 = No of Bathrooms

d.Sale price based upon square feet of living area, number of bedrooms, and number of bathrooms

The regression equation is given by

Y = 148.2555647X1 - 61665.83682X2 + 55016.32877X3 + 57174.06061

Y = Sales price in dollars

X1 = Square feet of living area.

X2 = No of Bedrooms

X3 = No of Bathrooms

Question 3:

At 90% Significance

a. Sale price based upon square feet of living area, number of bedrooms, and number of bathrooms

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.904252688
R Square 0.817672923
Adjusted R Square 0.781207508
Standard Error 55765.64154
Observations 19
ANOVA
df SS MS F Significance F
Regression 3 2.09196E+11 69731957514 22.42324 8.49E-06
Residual 15 46647101649 3109806777
Total 18 2.55843E+11
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 90.0% Upper 90.0%
Intercept 57174.06061 52858.40362 1.081645617 0.296493 -55491 169839.1 -35489.4 149837.5
X Variable 1 148.2555647 40.52520877 3.658354124 0.00233 61.87813 234.633 77.21283 219.2983
X Variable 2 -61665.83682 22374.88195 -2.756029594 0.014707 -109357 -13974.9 -100890 -22441.5
X Variable 3 55016.32877 23821.56476 2.309517839 0.035564 4241.865 105790.8 13255.93 96776.73

At the significance of 95%

b.Sale price based upon square feet of living area, number of bedrooms, and number of bathrooms

Regression Statistics
Multiple R 0.904252688
R Square 0.817672923
Adjusted R Square 0.781207508
Standard Error 55765.64154
Observations 19
ANOVA
df SS MS F Significance F
Regression 3 2.09196E+11 69731957514 22.42324 8.49E-06
Residual 15 46647101649 3109806777
Total 18 2.55843E+11
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 57174.06061 52858.40362 1.081645617 0.296493 -55491 169839.1 -55491 169839.1
X Variable 1 148.2555647 40.52520877 3.658354124 0.00233 61.87813 234.633 61.87813 234.633
X Variable 2 -61665.83682 22374.88195 -2.756029594 0.014707 -109357 -13974.9 -109357 -13974.9
X Variable 3 55016.32877 23821.56476 2.309517839 0.035564 4241.865 105790.8 4241.865 105790.8

5.Preferred model is based on the regression equation is defined based on R2 value. Higher the value of R2 the better the model suitability explaining the variation in the dependent variable (i.e. Sales price). So the most preferred model is given by

Y = 148.2555647X1 - 61665.83682X2 + 55016.32877X3 + 57174.06061

6. Preferred regression equation is given by

Y = 148.2555647X1 - 61665.83682X2 + 55016.32877X3 + 57174.06061

Y = Sales price in dollars

X1 = Square feet of living area.

X2 = No of Bedrooms

X3 = No of Bathrooms

This means

Variation in Sales price is effected by 148.2 times in Square feet of living area.

Variation in Sales price is effected by -61665.8 times No of Bedrooms.

Variation in Sales price is effected by 55016.3 times No of Bathrooms

7. Regression equation is given by

Y = 148.2555647X1 - 61665.83682X2 + 55016.32877X3 + 57174.06061

Here X1 = 3000sqft

         X2 = 3 Bedrooms

        X3 = 2.5 Bathrooms

So Y = $454484.1


Related Solutions

MBA 6300 Case Study No. 2 There are numerous variables that are believed to be predictors...
MBA 6300 Case Study No. 2 There are numerous variables that are believed to be predictors of housing prices, including living area (square feet), number of bedrooms, and number of bathrooms. The data in the Case Study No. 2.xlsx file pertains to a random sample of houses located in a particular geographic area. Develop the following simple linear regression models to predict the sale price of a house based upon a 90% level of confidence. Write the regression equation for...
write a brief introduction about the profile of city of Langley including area, population and housing?
write a brief introduction about the profile of city of Langley including area, population and housing?
Are any variables not useful predictors of home price at a significance level of α =...
Are any variables not useful predictors of home price at a significance level of α = 0.05? State the P-values of these variables. Intuitively, what does this mean with respect to pricing properties? (Show your results)                                                    (8 Points) df SS MS F Significance F Regression 8 4.6E+12 5.75E+11 65.04884 7.3335E-50 Residual 186 1.64E+12 8.84E+09 Total 194 6.25E+12 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 184455.9 44755.82 4.121383 5.67E-05 96161.5757 272750.1 96161.58...
1. You have a number of variables -- a response variable and some proposed predictors. A...
1. You have a number of variables -- a response variable and some proposed predictors. A correlation matrix may help to give an idea of the strength of the linear relationships present. For the purposes of regression analysis, what would be desirable in terms of … a) …the observed correlation between each proposed predictor and the response variable? (2) b) …the observed correlations among the predictors themselves? (2) 2. Explain the fact that, over the course of a year, the...
The amount of income spent on housing is an important component of the cost of living....
The amount of income spent on housing is an important component of the cost of living. The total costs of housing for homeowners might include mortgage payments, property taxes, and utility costs (water, heat, electricity). An economist selected a sample of 20 homeowners in New England and then calculated these total housing costs as a percent of monthly income, five years ago and now. The information is reported below. At the .05 significance level, is it reasonable to conclude the...
Housing Prices and Land Prices A household located x = 10 km from the city center...
Housing Prices and Land Prices A household located x = 10 km from the city center occupies a pays an annual rent of $9,000 for a standard dwelling. The annual non-land cost per dwelling is $5,000, and there are 8 dwellings per hectare. The annual interest rate is 5 percent. At x = 10, the willingness to pay for land is $[____] per hectare per year and the market value (purchase price) of land is $[____] per hectare. Suppose we...
A regression analysis of college faculty salaries included several predictors, including a dummy variable for gender...
A regression analysis of college faculty salaries included several predictors, including a dummy variable for gender (male = 1) and a dummy variable for race (nonwhite = 1). Assume gender takes on the values male and female, and race takes on the values nonwhite and white. For annual income measured in thousands of dollars, the estimated coefficients were 0.76 for gender and 0.62 for race. At particular settings of the other predictors, the estimated mean salary for white females was...
31. Pick an area in your living area to apply the 5S method to. This could...
31. Pick an area in your living area to apply the 5S method to. This could be your work/study space, a gaming area, a room, or even the whole house/apartment. First, write the room/area that you will apply these methods to. For each bullet here, name the “S” and then write a very brief description of what you did. Please follow the correct order of the 5S methodology. This question is worth 10 total points, 2 for each S (naming...
Uncertainty enters into the maintenance and production of health in numerous ways, including (a) Whether and...
Uncertainty enters into the maintenance and production of health in numerous ways, including (a) Whether and when individuals will get sick; (b) Whether a given treatment will work for a given patient; (c) Whether on average a treatment will work for a whole class of patients; (d) Whether a specific doctor is competent to deliver treatment. Pick any two of these and describe the major mechanisms (Institutional arrangements) that our society has created to deal with the uncertainty. (For example...
There are numerous examples of cell and tissue modifications that amplify the surface area of specific...
There are numerous examples of cell and tissue modifications that amplify the surface area of specific structures. For each of the following structures identify the modification and briefly describe how it increases surface area with respect to the structure listed. What is the functional significance of the specialization? Confine your answers to the boxes.                                                                                                                                            The modification How does it increase functional                                                                                                                                                                         surface area Skeletal muscle fibers An epithelial cell Osteoclast Circulatory system structure
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT