| Year | Quarter | SPeClty |
| 2006 | 3 | 4480.77 |
| 4 | 5827.48 |
| 2007 | 1 | 5602.84 |
| 2 | 5269.74 |
| 3 | 4945.67 |
| 4 | 5124.22 |
| 2008 | 1 | 4996.31 |
| 2 | 5147.61 |
| 3 | 4903.32 |
| 4 | 4960.84 |
| 2009 | 1 | 4864.16 |
| 2 | 4785.21 |
| 3 | 4684.43 |
| 4 | 4732.58 |
| 2010 | 1 | 4947.63 |
| 2 | 4826.21 |
| 3 | 4801.46 |
| 4 | 4789.05 |
| 2011 | 1 | 4812.69 |
| 2 | 4787.65 |
| 3 | 4871.31 |
| 4 | 4756.61 |
| 2012 | 1 | 4583.15 |
| 2 | 4659.09 |
| 3 | 4587.55 |
| 4 | 4746.01 |
| 2013 | 1 | 4556.63 |
| 2 | 4632.57 |
| 3 | 4561.03 |
| 4 | 4719.49 |
| 2014 | 1 | 4516.85 |
| 2 | 4592.78 |
| 3 | 4521.24 |
| 4 | 4844.6 |
| 2015 | 1 | 4588.54 |
| 2 | 4571.84 |
| 3 | 4671.24 |
| 4 | 5011.6 |
| 2016 | 1 | 4821.54 |
| 2 | 4916.84 |
| 3 | 4791.31 |
| 4 | 5183.49 |
| 2017 | 1 | 5045.38 |
| 2 | 5138.97 |
| 3 | 4915.37 |
| 4 | 5369.34 |
| 2018 | 1 | 5379.83 |
| 2 | 5481 |
| 3 | 5265.31 |
| 4 | 5579.14 |
| 2019 | 1 | 5743.98 |
| 2 | 5750.01 |
| 3 | 5542.86 |
a) in a paragraph write about Trend andSeasonality of this store.
b) write about Regression model(s) and examinehypotheses
c) what is the least square regression line?
d) write about standard error and interpret it in a shortparagraph.
* please just do it with excel and explain how you are solvingit (preferred to use excel screenshots)
