Listed 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 the thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of 0.1, 0.15, 0.25, 0.12, and 0.38, respectively. Decribe the trend in yield.

2001 8.61, 2002 8.44, 2003 7.27, 2004 6.49, 2005 7.27, 2006 9.78, 2007 6.81, 2008 6.71, 2009 5.38, 2010 5.67, 2011 5.94, 2012 5.49, 2013 5.53.

The weighted moving averages are :

Solution

Year Data Weighted Averages Formula Weights 2001 8.61 0.1 2002 8.44 0.15 2003 7.27 0.25 2004 6.49 0.12 2005 7.27 ROUND($H$4*C4+$H$5*C5+H6*C6+H7*C7+H8*C8,3) 7.486 0.38 2006 9.78 ROUND($H$4*C5+$H$5*C6+H7*C7+H8*C8+H9*C9,3) 5.476 2007 6.81 ROUND($H$4*C6+$H$5*C7+H8*C8+H9*C9+H10*C10,3) 4.463 2008 6.71 ROUND($H$4*C7+$H$5*C8+H9*C9+H10*C10+H11*C11,3) 1.74 2009 5.38 ROUND($H$4*C8+$H$5*C9+H10*C10+H11*C11+H12*C12,3) 2.194 2010 5.67 ROUND($H$4*C9+$H$5*C10+H11*C11+H12*C12+H13*C13,3) 2 2011 5.94 ROUND($H$4*C10+$H$5*C11+H12*C12+H13*C13+H14*C14,3) 1.688 2012 5.49 ROUND($H$4*C11+$H$5*C12+H13*C13+H14*C14+H15*C15,3) 1.478 2013 5.53 ROUND($H$4*C12+$H$5*C13+H14*C14+H15*C15+H16*C16,3) 1.389