Share
Explore BrainMass

Regression analysis of heating in SPSS

Salsberry Realty sells homes along the east coast of the U.S. One of the questions most frequently asked by prospective buyers is: If we purchase this home, how much can we expect to pay to heat it during the winter? The research department at Salsbury has been asked to develop some guidelines regarding heating costs for single-family homes. Three variables are thought to relate to the heating costs:

1) the mean daily outside temperature,
2) the number of inches of insulation in the attic, and
3) the age, in years, of the furnace.

To investigage, Salsbury's research department selected a random sample of 20 recently sold homes. It determined the cost to heat each home last January, as well as the January outside temperature in the region, the number of inches of insulation in the attic, and the age of the furnace. The sample information is reported on the next page:

(table attached)

a) What is the dependent variable? What are the independent variables?

b) Using SPSS to analyze the data and the corresponding output, what is the regression equation?

c) If the mean outside temperature for the month of January is 30 degrees, there are 5 inches of insulation in the attic, and the furnace is 10 years old, what is the estimated heating cost for January?

d) What is the regression coefficient for mean outside temperature? What relationship does it have with heating cost? Explain what happens to heating cost as the outside temperature increases.

e) If we increase temperature by 1 degree and hold the other variables constant, what can we expect will happen to the heating cost?

f) If the mean temperature in Boston is 25 degrees and it is 35 degrees in Philadelphia, all other things being the same, what can we expect the difference to be in heating cost?

g) What is the regression coefficient for attic insulation? What relationship does it have with heating cost?

h) What is the regression coefficient for age of furnace? What relationship does it have with heating cost?

Attachments

Solution Summary

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

$2.19