Clothing Sales Data at Self-Help Stores in 2010-2014 (in Units) Years Q 1 Q 2 Q 3 Q 4 Annual 2010 46 53 64 61 224 2011 56 62 69 68 255 2012 70 76 91 85 322 2013 75 81 96 90 342 2014 88 101 97 95 381 Linear Trend Equation (Annual): Shirt Sales = 184.5 + 40.1 * T Quadratic Trend Equation (Annual): Shirt Sales = 169.0 + 53.4 * T - 2.21 * T2 a. Determine the best annual trend equation, is it a linear trend or a quadratic trend? b. Using the best trend equation, project clothes sales at Self-Help Stores for 2015 and 2016! c. Determine the value of the season variation from the number of clothes sold in the table above!
Clothing Sales Data at Self-Help Stores in 2010-2014 (in Units)
|
Years |
Q 1 |
Q 2 |
Q 3 |
Q 4 |
Annual |
|
2010 |
46 |
53 |
64 |
61 |
224 |
|
2011 |
56 |
62 |
69 |
68 |
255 |
|
2012 |
70 |
76 |
91 |
85 |
322 |
|
2013 |
75 |
81 |
96 |
90 |
342 |
|
2014 |
88 |
101 |
97 |
95 |
381 |
Linear Trend Equation (Annual): Shirt Sales = 184.5 + 40.1 * T
a. Determine the best annual trend equation, is it a linear trend or a quadratic trend?
b. Using the best trend equation, project clothes sales at Self-Help Stores for 2015 and 2016!
c. Determine the value of the season variation from the number of clothes sold in the table above!
d. Determine the season index value of the number of clothes sold in the table above! What is the meaning of the obtained index value?
e. Determine the missing moving average values in 2010: 1, 2010: 2, 2014: 3, and 2014: 4!
Step by step
Solved in 3 steps
