• make a time series/line graph that shows the number of B&W pages and the number of color pages printed per month.
• Add linear trendlines to the graph. Paste the graph into the template.
• Forecast the number of pages of each type that will be printed over the next 3 months using:

1. Simple trend line
2. Holt-Winter model (You may use the Forecast Sheet in Excel 2016 or the Holt-winter forecast is R.)

• Paste the Forecast graph into your solution template
• Comment on which forecast you think would be most accurate and why

Months Black and White Pages Colored Pages Jun-06 122329 16577 Jun-07 162037 22614 Jun-08 152292 26111 Jun-09 801692 99974 Jun-10 704929 81971 Jun-11 728592 84733 Jun-12 533515 54124 Jul-01 718345 86584 Jul-02 743960 93526 Jul-03 648232 105529 Jul-04 672623 94510 Jul-05 442140 63181 Jul-06 331952 49881 Jul-07 301991 51574 Jul-08 680509 116343 Jul-09 680623 81354