Question 1047173: Please assist me in solving the following question? I do not know where to begin in solving this equation. Thank you for assisting.
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.2, 0.15, 0.25, 0.12, and 0.28, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)
2001 8.71
2002 8.24
2003 7.57
2004 6.69
2005 7.37
2006 6.88
2007 6.81
2008 6.41
2009 5.38
2010 5.67
2011 5.84
2012 5.59
2013 5.33
The weighted moving averages are:
Answer by Theo(13342)   (Show Source):
You can put this solution on YOUR website! the following calculator does it all for you.
the results are shown below.
the box on the right shows the 5 day weighted rolling average.
the weights are applied to each 5 data element set.
0.2, 0.15, 0.25, 0.12, 0.28
8.71, 8.24, 7.57, 6.69, 7.37, 6.88
the first weighted average would be:
.2 * 8.71 + .15 * 8.24 + .25 * 7.57 + .12 * 6.69 + .28 * 7.37
this is equal to 7.7369 which was rounded in the calculator to 7.737
the second weighted average would be:
.2 * 8.24 + .15 * 7.57 + .25 * 6.69 + .12 * 7.37 + .28 * 6.88
this is equal to 7.2668 which was rounded in the calculator to 7.267
the trend in the rolling 5 day weighted average looks like it's going down.
here's the link to where i got the calculator.
http://www.had2know.com/finance/weighted-moving-average-calculator.html
|
|
|
