Question

NARRBEGIN: SA_71_74
A carpet company, which sells and installs carpet, believes that there should be a relationship between the number of carpet installations that they will have to perform in a given month and the number of building permits that have been issued within the county where they are located. Below you will find a regression model that compares the relationship between the number of monthly carpet installations (Y) and the number of building permits that have been issued in a given month (X). The data represents monthly values for the past 10 months.
Summary measures
Multiple R0.5682
R-Square0.3229
StErr of Estimate9603.23
ANOVA table
SourcedfSSMSFp-value
Explained13518244793518244793.81500.0866
Unexplained873777552192221940
Regression coefficients
CoefficientStd Errt-valuep-value
Constant-115076.6982933.46-1.38760.2027
Permits53.46927.3751.95320.0866
NARREND
(A) Estimate the regression model. How well does this model fit the given data?
(B) Yes, there is a linear relationship between the number of carpet installations and the number of building permits issued at a = 0.10; The p-value = 0.0866 for the F-statistic. You can conclude that there is a significant linear relationship between these two variables.
(C) The Durbin-Watson statistic for this data was 1.2183. Given this information what would you conclude about the data?
(D) Given your answer in (C), would you recommend modifying the original regression model? If so, how would you modify it?

Answer

This answer is hidden. It contains 951 characters.