run a regression in excel for this data set Find Time Series Data and Panel Data
ID: 3326394 • Letter: R
Question
run a regression in excel for this data set
Find Time Series Data and Panel Data.
Date E-Commerce Store Retail Mobile Subscriptions 2000-01-01 6854 19303 38.468091050 2001-01-01 8540 19065 44.690578740 2002-01-01 11115 18489 48.851038220 2003-01-01 14237 17889 54.846814090 2004-01-01 18092 17919 62.547195980 2005-01-01 22762 17948 68.317695070 2006-01-01 28196 17784 76.293538420 2007-01-01 33960 17493 82.064144790 2008-01-01 35466 16562 85.209165170 2009-01-01 36230 15577 88.623646110 2010-01-01 42293 15409 91.311652020 2011-01-01 49643 15296 94.440425960 2012-01-01 57390 14786 96.010376090 2013-01-01 64989 14234 97.077739390 2014-01-01 74403 14007 110.204193500 2015-01-01 84813 13686 117.586744400 2016-01-01 97419 12871 127.157935800Explanation / Answer
SUMMARY OUTPUT Regression Statistics Multiple R 0.972139 R Square 0.945055 Adjusted R Square 0.937205 Standard Error 6.430276 Observations 17 ANOVA df SS MS F Significance F Regression 2 9956.64 4978.32 120.3992 1.51E-09 Residual 14 578.8783 41.34845 Total 16 10535.52 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 157.9997 59.43853 2.658204 0.018727 30.51676 285.4827 30.51676 285.4827 E-Commerce 0.000483 0.000227 2.123226 0.052044 -4.9E-06 0.00097 -4.9E-06 0.00097 Store Retail -0.00587 0.003085 -1.9029 0.077823 -0.01249 0.000746 -0.01249 0.000746
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.