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

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter7: Distance And Approximation
Section7.3: Least Squares Approximation
Problem 31EQ
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
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL