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
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
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL