Explore BrainMass

# Regression analysis of real estate data

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Refer to the data included in the Excel file, which report information on homes sold in the Somewhere, USA, during a recent year. Use the selling price of the home as the dependent variable and determine the regression equation with number of bedrooms, size of the house, whether there is a pool, whether there is an attached garage, distance from the center of the
city, and the number of bathrooms as independent variables.

i) Construct a 95% confidence interval estimate of the population slope between selling price and each of the following variables: number of bedrooms, size in sq. ft., distance to CBD, and number of bathrooms.
j) Compute and interpret the coefficients of partial determination.
k) Predict the selling price of a 2,500 square feet house that has 5 bedrooms, 3 bathrooms,
a 3-car attached garage, no pool, and is at 18 miles from the city center.
l) Rerun the analysis until only significant regression coefficients remain in the analysis. Identify these variables.

© BrainMass Inc. brainmass.com June 3, 2020, 10:45 pm ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/regression-analysis-of-real-estate-data-248352

#### Solution Summary

The solution provides step by step method for the calculation of regression model . Formula for the calculation and Interpretations of the results are also included.

\$2.19