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 |