Module 5 Chp 13 probelm 42 part c

Module 5 Chp 13 probelm 42 part c - 42 Consider the airline...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Does it make much of an improvement? file P13_01.xlsx. Month Year Tickets January 1 605 Part B: February 1 647 these data, using no holdout period and requesting March 1 636 12 months of future forecasts. Use the default April 1 612 smoothing constant of 0.1. May 1 714 June 1 765 Solution for Part B: July 1 698 Simple Exponential Smoothing August 1 615 Alpha Septembe 1 588 .10 October 1 685 November 1 711 t Tickets Smoothed Forecast % error December 1 664 663.2 * January 2 630 1 605 657.4 663 -9.6 February 2 696 2 647 656.3 657 -1.5 March 2 670 3 636 654.3 656 -3.1 April 2 671 4 612 650.1 654 -6.9 May 2 724 5 714 656.4 650 9.0 June 2 787 6 765 667.3 656 14.2 July 2 724 7 698 670.4 667 4.4 August 2 651 8 615 664.8 670 -8.9 Septembe 2 589 9 588 657.2 665 -13.1 October 2 697 10 685 659.9 657 4.1 November 2 750 11 711 665.0 660 7.2 December 2 705 12 664 664.9 665 -0.2 January 3 664 13 630 661.4 665 -5.6 February 3 704 14 696 664.9 661 5.0 March 3 691 15 670 665.4 665 0.7 April 3 672 16
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online