Listed below is the number of movie tickets sold at the Library Cinema-Complex,
ID: 3125013 • Letter: L
Question
Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of .1, .1, .2, .3, and .3, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)
There is a regular (Click to select)decreaseincrease of approximately 0.2 per year.
Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2001 to 2013. Compute a five-year weighted moving average using weights of .1, .1, .2, .3, and .3, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)
Explanation / Answer
There is a regular decrease of approximately 0.2 per year.
Year Data Weighted Averages Formula Weights 2001 8.61 0.1 2002 8.14 0.1 2003 7.67 0.2 2004 6.59 0.3 2005 7.37 ROUND($H$4*C4+$H$5*C5+H6*C6+H7*C7+H8*C8,3) 7.397 0.3 2006 6.88 ROUND($H$4*C5+$H$5*C6+H7*C7+H8*C8+H9*C9,3) 5.769 2007 6.71 ROUND($H$4*C6+$H$5*C7+H8*C8+H9*C9+H10*C10,3) 3.637 2008 6.61 ROUND($H$4*C7+$H$5*C8+H9*C9+H10*C10+H11*C11,3) 1.396 2009 5.58 ROUND($H$4*C8+$H$5*C9+H10*C10+H11*C11+H12*C12,3) 1.425 2010 5.87 ROUND($H$4*C9+$H$5*C10+H11*C11+H12*C12+H13*C13,3) 1.359 2011 5.94 ROUND($H$4*C10+$H$5*C11+H12*C12+H13*C13+H14*C14,3) 1.332 2012 5.49 ROUND($H$4*C11+$H$5*C12+H13*C13+H14*C14+H15*C15,3) 1.219 2013 5.43 ROUND($H$4*C12+$H$5*C13+H14*C14+H15*C15+H16*C16,3) 1.145Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.