Homework SourseListed below is the number of movie tickets sold at the Libr
Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 1998 to 2010. Compute a five-year weighted moving average using weights of 0.15, 0.2, 0.25, 0.15, and 0.25, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)
| Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 1998 to 2010. Compute a five-year weighted moving average using weights of 0.15, 0.2, 0.25, 0.15, and 0.25, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.) |
Solution
Moving Averages are calculated using :
MA for n th value =
0.15 * (n-4) th value + 0.2 * (n-3) th value + 0.25 * (n-2) th value + 0.15 * (n-1) th value + 0.25 * (n) th value
The trend is decreasing over the years.
| Moving Averages | ||
| 1998.00 | 8.81 | |
| 1999 | 8.24 | |
| 2000 | 7.77 | |
| 2001 | 6.69 | |
| 2002 | 7.37 | 7.758 |
| 2003 | 6.58 | 7.213 |
| 2004 | 6.71 | 7.010 |
| 2005 | 6.71 | 6.806 |
| 2006 | 5.88 | 6.576 |
| 2007 | 5.97 | 6.381 |
| 2008 | 5.84 | 6.174 |
| 2009 | 5.49 | 5.924 |
| 2010 | 5.33 | 5.692 |
