Listed below is the number of movie tickets sold at the Library Cinema-Complex,

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 0.15, 0.1, 0.3, 0.14, and 0.31, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)

  2001

8.61

  2002

8.04

  2003

7.27

  2004

6.49

  2005

7.47

  2006

6.68

  2007

6.81

  2008

6.81

  2009

5.68

  2010

5.57

  2011

5.84

  2012

5.59

  2013

5.63

The weighted moving averages are:

  

  

  

  

  

  

  

  

  

  

  There is a regular (Click to select)increasedecrease 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 0.15, 0.1, 0.3, 0.14, and 0.31, 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.15 2002 8.04 0.1 2003 7.27 0.3 2004 6.49 0.14 2005 7.47 ROUND($H$4*C4+$H$5*C5+H6*C6+H7*C7+H8*C8,3) 7.501 0.31 2006 6.68 ROUND($H$4*C5+$H$5*C6+H7*C7+H8*C8+H9*C9,3) 5.157 2007 6.81 ROUND($H$4*C6+$H$5*C7+H8*C8+H9*C9+H10*C10,3) 4.055 2008 6.81 ROUND($H$4*C7+$H$5*C8+H9*C9+H10*C10+H11*C11,3) 1.721 2009 5.68 ROUND($H$4*C8+$H$5*C9+H10*C10+H11*C11+H12*C12,3) 1.789 2010 5.57 ROUND($H$4*C9+$H$5*C10+H11*C11+H12*C12+H13*C13,3) 1.683 2011 5.84 ROUND($H$4*C10+$H$5*C11+H12*C12+H13*C13+H14*C14,3) 1.703 2012 5.59 ROUND($H$4*C11+$H$5*C12+H13*C13+H14*C14+H15*C15,3) 1.59 2013 5.63 ROUND($H$4*C12+$H$5*C13+H14*C14+H15*C15+H16*C16,3) 1.409

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.