Question

NARRBEGIN: SA_79_81
The information below represents the relationship between the selling price (Y, in $1,000) of a home, the square footage of the home (), and the number of rooms in the home (). The data represents 60 homes sold in a particular area of East Lansing, Michigan and was analyzed using multiple linear regression and simple regression for each independent variable. The first two tables relate to the multiple regression analysis.
Summary measures
Multiple R0.941
R-Square0.885
Adj R-Square0.866
StErr of Estimate20.84
Regression coefficients

Coefficient
Constant-13.9705
Size7.4336
Number of Rooms5.3055
The following table is for a simple regression model using only size. (= 0.8812)
CoefficientStd Errt-valuep-value
Constant14.77119.6910.75020.4665
Size7.8160.7969.81900.0000
The following table is for a simple regression model using only number of rooms. (= 0.3657)
CoefficientStd Errt-valuep-value
Constant-93.460108.269-0.86320.4037
Number of Rooms41.29215.0822.73790.0169
NARREND
(A) Use the information related to the multiple regression model to determine whether each of the regression coefficients are statistically different from 0 at a 5% significance level. Summarize your findings.
(B) Test at the 5% significance level the relationship between Y and X in each of the simple linear regression models. How does this compare to your answer in (A)? Explain.
(C) Is there evidence of multicollinearity in this situation? Explain why or why not.

Answer

This answer is hidden. It contains 911 characters.