I have forecasting question, and I attached the data in SBUX. (Plese note that I also attached the class lecture, just in case).
iamnickok
sbux.xlsx
Annual-SBUX
| Year | Year Trend (X) | Total Revenue (Y) |
| 2008 | 1 | 10383 |
| 2009 | 2 | 9774.6 |
| 2010 | 3 | 10707.4 |
| 2011 | 4 | 11700.4 |
| 2012 | 5 | 13299.5 |
| 2013 | 6 | 14892.2 |
| 2014 | 7 | 16447.8 |
Quarter-SBUX
| | | X1 | X2 | X3 | X4 | Y |
| Year | Quarter | Trend | Quarter 1 | Quarter 2 | Quarter 3 | Sales |
| 2008 | 1 | 1 | 1 | 0 | 0 | 2767.6 |
| 2008 | 2 | 2 | 0 | 1 | 0 | 2526 |
| 2008 | 3 | 3 | 0 | 0 | 1 | 2574 |
| 2008 | 4 | 4 | 0 | 0 | 0 | 2515.4 |
| 2009 | 1 | 5 | 1 | 0 | 0 | 2615.2 |
| 2009 | 2 | 6 | 0 | 1 | 0 | 2333.3 |
| 2009 | 3 | 7 | 0 | 0 | 1 | 2403.9 |
| 2009 | 4 | 8 | 0 | 0 | 0 | 2422.2 |
| 2010 | 1 | 9 | 1 | 0 | 0 | 2722.7 |
| 2010 | 2 | 10 | 0 | 1 | 0 | 2534.7 |
| 2010 | 3 | 11 | 0 | 0 | 1 | 2612 |
| 2010 | 4 | 12 | 0 | 0 | 0 | 2838 |
| 2011 | 1 | 13 | 1 | 0 | 0 | 2950.8 |
| 2011 | 2 | 14 | 0 | 1 | 0 | 2785.7 |
| 2011 | 3 | 15 | 0 | 0 | 1 | 2932.2 |
| 2011 | 4 | 16 | 0 | 0 | 0 | 3031.7 |
| 2012 | 1 | 17 | 1 | 0 | 0 | 3435.9 |
| 2012 | 2 | 18 | 0 | 1 | 0 | 3195.9 |
| 2012 | 3 | 19 | 0 | 0 | 1 | 3303.5 |
| 2012 | 4 | 20 | 0 | 0 | 0 | 3364.2 |
| 2013 | 1 | 21 | 1 | 0 | 0 | 3793.2 |
| 2013 | 2 | 22 | 0 | 1 | 0 | 3549.6 |
| 2013 | 3 | 23 | 0 | 0 | 1 | 3735.3 |
| 2013 | 4 | 24 | 0 | 0 | 0 | 3788.7 |
| 2014 | 1 | 25 | 1 | 0 | 0 | 4239.6 |
| 2014 | 2 | 26 | 0 | 1 | 0 | 3873.8 |
| 2014 | 3 | 27 | 0 | 0 | 1 | 4153.7 |
| 2014 | 4 | 28 | 0 | 0 | 0 | 4180.7 |
