MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

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
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman