Consider the following sales data measured in millions of dollars. Date Time Sales (millions of dollars) MA
Fantastic news! We've Found the answer you've been seeking!
Question:
- Consider the following sales data measured in millions of dollars.
Date | Time | Sales (millions of dollars) | MA | CMA | Seasonal Factors | Seasonal Index |
2015Q1 | 1 | 14 | ||||
2015Q2 | 2 | 16 | ||||
2015Q3 | 3 | 18 | ||||
2015Q4 | 4 | 30 | ||||
2016Q1 | 5 | 17 | ||||
2016Q2 | 6 | 19 | ||||
2016Q3 | 7 | 19 | ||||
2016Q4 | 8 | 28 | ||||
2017Q1 | 9 | 12 | ||||
2017Q2 | 10 | 17 | ||||
2017Q3 | 11 | 20 | ||||
2017Q4 | 12 | 29 |
- Find a four-period moving average for each quarter.
b) Find the centered moving averages for the sample.
Find the seasonal factors for the sample.
Find the seasonal index. Interpret the index for each quarter.
Please describe how would you estimate the long-term trend and measure the cyclical factor (no need for computation, just explain).
Related Book For
Business Forecasting with Forecast X
ISBN: 978-0073373645
6th edition
Authors: Holton wilson, barry keating, john solutions inc
Posted Date: