Use the ADDITIVE DECOMPOSITION method to forecast attendance for games 1 - 4 for 2007. 2. Add
Question:
Use the ADDITIVE DECOMPOSITION method to forecast attendance for games 1 - 4 for 2007.
2. Add up the total attendance for each of the 5 years. Using these annual totals, create and find the 2-period MOVING AVERAGE forecast for total 2007 attendance.
3. Using the total attendance for the 5 years, create a 2-period WEIGHTED MOVING AVERAGE forecast for total 2007 attendance (set the weights to 10 for the last period and 5 for the prior period).
4. Using the total attendance for the 5 years, create an EXPONENTIAL SMOOTHING forecast for 2007 attendance (use alpha of .50).
5. Using the total attendance for the 5 years, create a TIME SERIES forecast for 2007 attendance.
6. Compare and contrast each of the 5 models you created, noting the graphs, and the MAD & MSE. Which forecast would you be most likely to accept for 2007 total attendance? Would you believe the forecast from the Additive Decomposition model? Why or why not?
7. Using the actual attendance for 2007 as shown below, how well did each model do?
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw