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. Note: the Excel results are for a standard two-tailed test. E Click the icon to view the results. - X What is the p-value for testing whether Wages have a negative impact on corporate sales? Output SUMMARY OUTPUT O A. 0.05 Regression Statistics 0.830 O B. 0,99995 Multiple R R Square Adjusted R Square Standard Error 0.689 0.662 Oc. 0,0001 O D. 0.00005 17501.643 Observations 26 ANOVA Signif F 25.432 0.0001 df SS MS F Regression Residual 2 15579777040 7789888520 23 7045072780 306307512 Total 25 22624849820 t Stat 2.617 Coeff StdError P-value Intercept Сapital Wages 0.0154 0.5485 0.0001 15800.0000 6038.2999 0.2045 1.4729 0.1245 0.609 7.0762 4.804 Print Done

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
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. Note: the Excel results are for a standard two-tailed test.
Click the icon to view the results.
What is the p-value for testing whether Wages have a negative impact on corporate sales?
Output
SUMMARY OUTPUT
O A. 0.05
Regression Statistics
O B. 0.99995
Multiple R
R Square
Adjusted R Square
0.830
O C. 0.0001
0.689
0.662
O D. 0.00005
Standard Error
17501.643
Observations
26
ANOVA
Sp
15579777040
Signif F
0.0001
MS
F
Regression
7789888520
25.432
Residual
23
7045072780
306307512
Total
25
22624849820
Coeff
StdError
t Stat
P-value
Intercept
Capital
Wages
15800.0000 6038.2999
2.617
0.0154
0.1245
0.2045
0.609
0.5485
7.0762
1.4729
4.804
0.0001
Print
Done
Transcribed Image Text: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. Note: the Excel results are for a standard two-tailed test. Click the icon to view the results. What is the p-value for testing whether Wages have a negative impact on corporate sales? Output SUMMARY OUTPUT O A. 0.05 Regression Statistics O B. 0.99995 Multiple R R Square Adjusted R Square 0.830 O C. 0.0001 0.689 0.662 O D. 0.00005 Standard Error 17501.643 Observations 26 ANOVA Sp 15579777040 Signif F 0.0001 MS F Regression 7789888520 25.432 Residual 23 7045072780 306307512 Total 25 22624849820 Coeff StdError t Stat P-value Intercept Capital Wages 15800.0000 6038.2999 2.617 0.0154 0.1245 0.2045 0.609 0.5485 7.0762 1.4729 4.804 0.0001 Print Done
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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