Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The table below shows the Excel output of the autoregression of firm productivity on one-year lagged (1-lag) and two-year lagged (2-lag) productivity. SUMMARY OUTPUT Regression
The table below shows the Excel output of the autoregression of firm productivity on one-year lagged (1-lag) and two-year lagged (2-lag) productivity.
SUMMARY OUTPUT Regression Statistics Multiple R 0.991712579 R Square 0.98349354 Adjusted R Square 0.981659822 Standard Error 1.854872203 Observations 21 ANOVA of 55 MS F Significance F Regression 2 3689.997526 1844.998763 536.250973 9.09525E-17 Residual 18 61.92991603 3.440550891 Total 20 3751 927442 Coefficients Standard Error t Stat P-value Lower 956 Upper 95% Lower 95.0% Upper 95.0% Intercept -1.767168758 3.125522962 -0.56539938 0.5787823 -8.33364883 4.79931131 -8.33364883 4.79931131 1-lag 1.449348749 0.219641755 6.598694078 3.3859E-06 0.987898545 1.910798952 0.987898545 1.910798952 2-lag -0.415037817 0,230316209 -1.80203477 0.08831256 -0.89891422 0.068838582 -0.89891422 0.068838582Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started