In: Statistics and Probability
. The amount spent in billions for online ads per year is shown below. Construct a time series plot of the data and describe the trend. please help with graphing and explaining
year | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 |
amount | $68.4 | $80.2 | $94.2 | $106.1 | $119.8 | $132.1 |
Year | Amount | t |
2010 | 68.4 | 1 |
2011 | 80.2 | 2 |
2012 | 94.2 | 3 |
2013 | 106.1 | 4 |
2014 | 119.8 | 5 |
2015 | 132.1 | 6 |
Mean | 100.1333 | 3.5 |
N | 6 | 6 |
Sum | 600.8 | 21 |
The trend is positive.
Y'=a+bX
Wher X= t (time series)
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.999789706 | ||||
R Square | 0.999579456 | ||||
Adjusted R Square | 0.99947432 | ||||
Standard Error | 0.550627348 | ||||
Observations | 6 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 2882.580571 | 2882.580571 | 9507.49 | 6.63E-08 |
Residual | 4 | 1.212761905 | 0.303190476 | ||
Total | 5 | 2883.793333 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | 55.21333333 | 0.512606164 | 107.7110211 | 4.46E-08 | 53.79011 |
t | 12.83428571 | 0.131625112 | 97.50636132 | 6.63E-08 | 12.46884 |