Scribd
Upload
11 views3 pages

Book 1

Uploaded by

a2024pgdm4375
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views3 pages

Book 1

Uploaded by

a2024pgdm4375
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.664037
R Square 0.440945
Adjusted R Square 0.329134 y=a+bx
Standard Error 5.329165
Observations 7

ANOVA
df SS MS F Significance F
Regression 1 112 112 3.943662 0.103797
Residual 5 142 28.4
Total 6 254

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 82 4.503967 18.20617 9.189E-06 70.42219 93.57781 70.42219 93.57781
time period (x) 2 1.007118 1.985866 0.103797 -0.588878 4.588878 -0.588878 4.588878
Upper 95.0%
year time period (x) prod. (y) estimated value forecasting error
2000 1 80 84 5%
2001 2 90 86 4%
2002 3 92 88 4%
2003 4 83 90 8%
2004 5 94 92 2%
2005 6 99 94 5%
2006 7 92 96 4%
2007 8 98 98
2008 9 100 100
2009 10 102 102
2010 11 104 104
2011 12 106
2012 13 108
2013 14 110
2014 15 112
2015 16 114
2016 17 116
2017 18 118
2018 19 120

You might also like