Assume you ran a multiple regression to gain a better understanding of the relationship between lumber sales, housing starts, and commercial construction. The regression uses LumberSales (in $100,000s) as the response variable with HousingStarts (in 1,000s) and Commercial Construction (in 1,000s) as the explanatory variables. The results of the regression are as follows: df SS MS FSignificanceFRegression 2180,770 90,385 1030Residual 4539,375875 Total 47220,145 CoefficientsStandardError t-stat p-valueIntercept 5,371,713,140,0030Housing Starts 0,760,098,440,0000CommercialConstruction 1,250,333,780,0005Requirement:a. At the 5% significance level, are the explanatory variables jointly significant in explaining LumberSales? Explain.b. At the 5% significance level, is Commercial Construction significant in explaining LumberSales? Explain.c. At the 5% significance level, can you conclude that the slope coefficient attached to HousingStarts differs from 1? Explain. (please if can, show me in excel/spreadsheet)

Given : df SS MS F SignificanceF Regression 2 180,770 90,385 103 0 Residual 45…

Answered: Assume you ran a multiple regression to…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

Assume you ran a multiple regression to gain a better understanding of the relationship between lumber sales, housing starts, and commercial construction. The regression uses LumberSales (in $100,000s) as the response variable with HousingStarts (in 1,000s) and Commercial Construction (in 1,000s) as the explanatory variables. The results of the regression are as follows:

	df	SS	MS	F	SignificanceF
Regression	2	180,770	90,385	103	0
Residual	45	39,375	875
Total	47	220,145

	Coefficients	Standard Error	t-stat	p-value
Intercept	5,37	1,71	3,14	0,0030
Housing Starts	0,76	0,09	8,44	0,0000
Commercial Construction	1,25	0,33	3,78	0,0005

Requirement:

a. At the 5% significance level, are the explanatory variables jointly significant in explaining LumberSales? Explain.
b. At the 5% significance level, is Commercial Construction significant in explaining LumberSales? Explain.
c. At the 5% significance level, can you conclude that the slope coefficient attached to HousingStarts differs from 1? Explain.

(please if can, show me in excel/spreadsheet)

Expert Solution