Question

In: Statistics and Probability

A microeconomist wants to determine how corporate sales are influenced by capital and wage spending by...

A microeconomist wants to determine how corporate sales are influenced by capital and wage spending by companies. She proceeds to randomly select 26 large corporations and record information in millions of dollars. The Microsoft Excel output below shows results of this multiple regression.
SUMMARY OUTPUT
Regression Statistics
Multiple R_____0.830
R Square______0.689
Adj. R Square__0.662
Std. Error_____17501.643
Observations___26
ANOVA
__________df________SS___________MS_______F_____Signif F
Regression__2____15579777040__7789888520__25.432__0.0001
Residual___23_____7045072780___306307512
Total______25___22624849820
____________Coef_________StdError_____tStat___p-value
Intercept_____15800.0000___6038.2999___2.617___0.0154
Capital_______0.1245_________0.2045____0.609___0.5485
Wages_______7.0762_________1.4729_____4.804__0.0001
At the 0.01 level of significance, what conclusion should the microeconomist reach regarding the inclusion of Capital in the regression model?

1) Capital is significant in explaining corporate sales and should be included in the model because its p-value is less than 0.01.

2) Capital is significant in explaining corporate sales and should be included in the model because its p-value is more than 0.01.

3) Capital is not significant in explaining corporate sales and should not be included in the model because its p-value is less than 0.01.

4) Capital is not significant in explaining corporate sales and should not be included in the model because its p-value is more than 0.01

Solutions

Expert Solution

Solution:

A microeconomist wants to determine how corporate sales are influenced by capital and wage spending by companies.

The Microsoft Excel output below shows results of this multiple regression.

At the 0.01 level of significance, what conclusion should the Microeconomist reach regarding the inclusion of Capital in the regression model?

An independent variable in regression is significant or insignificant is determined by p-value corresponding to independent variable in regression analysis.

If p-value < given level of significance ,then null hypothesis H0: regression coefficient = 0 is rejected , that means regression coefficient is significantly different from 0. Thus corresponding independent variable is significant or should be included in the regression equation.

But if p-value > given level of significance ,then we fail to reject null hypothesis H0: regression coefficient = 0 , that means regression coefficient is not significantly different from 0. Thus corresponding independent variable is not significant or should not be included in the regression equation.

From above regression analysis output , we can see: p-value for Variable Capital is 0.5485 > 0.01 level of significance, thus we fail to reject null hypothesis H0: regression coefficient = 0 , that means regression coefficient is not significantly different from 0. thus the variable Capital is not significant or should not be included in the regression equation.

Thus correct option is:

4) Capital is not significant in explaining corporate sales and should not be included in the model because its p-value is more than 0.01


Related Solutions

A student used multiple regression analysis to study how family spending (y) is influenced by income...
A student used multiple regression analysis to study how family spending (y) is influenced by income (x1), family size (x2), and additions to savings (x3). The variables y, x1, and x3 are measured in thousands of dollars. The following results were obtained. Anova df ss regression 3 45.9634 residual 11 2.6218 Total coefficient Standard error intercept 0.0136 x1 0.7992 0.074 x2 0.2280 0.190 x3 -0.5796 0.920 Calculate the estimated regression equation for the relationship between the variables,coefficient of determination. What...
A student used multiple regression analysis to study how family spending (y) is influenced by income...
A student used multiple regression analysis to study how family spending (y) is influenced by income (x1), family size (x2), and additionsto savings(x3). The variables y, x1, and x3 are measured in thousands of dollars. The following results were obtained. ANOVA df SS Regression 3 45.9634 Residual 11 2.6218 Total Coefficients Standard Error Intercept 0.0136 x1 0.7992 0.074 x2 0.2280 0.190 x3 -0.5796 0.920 a. Write out the estimated regression equation for the relationship between the variables. (1 mark) b....
A sales analyst wants to determine whether there is difference in the mean monthly sales (in...
A sales analyst wants to determine whether there is difference in the mean monthly sales (in RM) of cosmetic company of six sales region in Johor. Several salespersons from each region are chosen and their monthly sales were recorded in Table Q2. Monthly sale (RM) Company A Company B Company C Company D Company E Company F 4250 3930 3960 4350 4150 3970 3980 4010 4020 4450 3890 4160 4020 4050 4130 3880 4568 4370 4130 4220 4350 4574 4480...
The US corporate sector cuts spending sharply due to expectations of low future sales and tight...
The US corporate sector cuts spending sharply due to expectations of low future sales and tight financial conditions. Use (appropriate variants of ) the DD–AA diagram to study the following scenarios related to this shock, in terms of US real activity (GDP) and the nominal exchange rate. Design a fiscal policy response, aimed at restoring full employment. What fiscal policy instrument would your plan use?
How might the capital budgeting activities of a nonprofit organization be different from the capital spending...
How might the capital budgeting activities of a nonprofit organization be different from the capital spending decisions of a company?
Describe how the readings and journalling activities influenced your views on workplace ethics and corporate social...
Describe how the readings and journalling activities influenced your views on workplace ethics and corporate social responsibility. Did you have a shift in your perspective? Do you consider ethics and/or corporate social responsibility to be important to business and society today? Explain your answer, and use examples from the activities. Please provide references as well.
In the model with uncertainty and capital, how is the equilibrium real wage determined?
In the model with uncertainty and capital, how is the equilibrium real wage determined?a It will adjust so that equilibrium profits equal zero.b It will equal the marginal product of labour.c It will adjust so that output equals consumption.d It will equal the marginal rate of substitution between consumption and leisure for the household. 
How does technological change influence the planning for capital spending decisions?
How does technological change influence the planning for capital spending decisions?
How does technological change influence the planning for capital spending decisions?
How does technological change influence the planning for capital spending decisions?
Based on the MM theory, explain how capital structure is influenced by taxes. Would the result...
Based on the MM theory, explain how capital structure is influenced by taxes. Would the result be different if considering bankruptcy costs? Illustrate.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT