Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ECO301 - Regression Analysis I am trying to use excel regression for regression analysis for Milestone one, module 2-3 for regression analysis. When I run

ECO301 - Regression Analysis

I am trying to use excel regression for regression analysis for Milestone one, module 2-3 for regression analysis. When I run it, I am only getting these results:

image text in transcribedimage text in transcribed
SUMMARY OUTPUT Regression Statistics Multiple R 0.889784 R Square 0.791716 Adjusted R Square 0.778421 Standard Error 45.39571 Observations 51 ANOVA df SS MS F Significance F Regression 3 368163.6715 122721.2238 59.55115 4.83988E-16 Residual 47 96856.19835 2060.770178 Total 50 465019.8698 Coefficients Standard Error t Stat P-value Lower 95% Upper 95%ower 95.09pper 95.0% Intercept -18.4498 45.28617197 -0.407405649 0.68556 -109.5538676 72.65418 -109.554 72.65418 Price 0.138429 2.788582009 0.049641374 0.960619 -5.471474268 5.748332 -5.47147 5.748332 GDP 0.170079 0.03916474 4.34264555 7.45E-05 0.091289291 0.248868 0.091289 0.248868 Population 0.005281 0.001791238 2.948036043 0.004967 0.001677128 0.008884 0.001677 0.00888456 SUMMARY OUTPUT 57 58 Regression Statistics 59 Multiple R 0.052853 60 R Square 0.002793 61 Adjusted R Square -0.01756 62 Standard Error 2.333434 63 Observations 51 64 65 ANOVA 66 df SS MS F gnificance F 67 Regression 1 0.747374 0.747374 0.137261 0.712616 68 Residual 49 266.8007 5.444913 69 Total 50 267.5481 70 71 Coefficientsandard Err, t Stat P-value Lower 95%Upper 95%ower 95.09pper 95.0% 72 Intercept 16.0087 0.382473 41.8558 5.14E-40 15.24009 16.77731 15.24009 16.77731 73 X Variable 1 0.001268 0.003422 0.370487 0.712616 -0.00561 0.008144 -0.00561 0.008144

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Law Text and Cases

Authors: Kenneth W. Clarkson, Roger LeRoy Miller, Gaylord A. Jentz, F

11th Edition

324655223, 978-0324655223

Students also viewed these Economics questions