Question

In: Statistics and Probability

Deseasonalize the data by calculating the centered moving average. Plot the deseasonalized data on the graph...

Deseasonalize the data by calculating the centered moving average. Plot the deseasonalized data on the graph created in (a). Calculate the seasonal index for each quarter. Write a short explanation of why the results make sense.

Period Sales
Mar-01 26.84
Jun-01 26.95
Sep-01 32.21
Dec-01 27.30
Mar-02 26.87
Jun-02 29.82
Sep-02 32.34
Dec-02 29.28
Mar-03 30.07
Jun-03 32.40
Sep-03 35.41
Dec-03 32.15
Mar-04 31.84
Jun-04 35.08
Sep-04 37.80
Dec-04 33.46
Mar-05 33.85
Jun-05 36.73
Sep-05 38.09
Dec-05 32.98
Mar-06 32.93
Jun-06 35.61
Sep-06 39.76
Dec-06 35.32
Mar-07 36.61
Jun-07 39.95
Sep-07 42.69
Dec-07 37.94
Mar-08 38.76
Jun-08 41.57
Sep-08 45.94
Dec-08 42.25
Mar-09 43.75
Jun-09 48.29
Sep-09 54.43
Dec-09 48.11
Mar-10 51.11
Jun-10 53.33
Sep-10 59.71
Dec-10 51.81
Mar-11 52.00
Jun-11 53.71
Sep-11 56.72
Dec-11 49.36
Mar-12 49.30
Jun-12 54.63
Sep-12 55.71
Dec-12 50.43
Mar-13 51.99
Jun-13 56.97
Sep-13 58.61
Dec-13 53.02
Mar-14 57.75
Jun-14 59.87
Sep-14 60.80
Dec-14 56.28
Mar-15 57.67
Jun-15 63.86
Sep-15 66.57
Dec-15 62.44
Mar-16 64.57
Jun-16 71.73
Sep-16 74.31
Dec-16 67.86

Solutions

Expert Solution

Data is given: Quarter-wise for each year.

Hence, seasonality is present quarter wise.

To calculate trend, we eliminate seasonality.

By using moving averages, we have 4- quarter moving average (as that will remove the effect of seasonality from years) and we will be able to obtain trend.

Then, we take centerd 4-quarter moving average (by taking average of 2 consecutive obs in 4-moving average)

Then, we assume it is multiplicative series, so we take ratio of original series to trend to obtain seasonal component or detrended series.

Table:

Period Sales Trend - 4MA Centered 4MA Detrended
Mar-01 26.84
Jun-01 26.95 28.33
Sep-01 32.21 28.33 28.33 1.14
Dec-01 27.30 29.05 28.69 0.95
Mar-02 26.87 29.08 29.07 0.92
Jun-02 29.82 29.58 29.33 1.02
Sep-02 32.34 30.38 29.98 1.08
Dec-02 29.28 31.02 30.70 0.95
Mar-03 30.07 31.79 31.41 0.96
Jun-03 32.40 32.51 32.15 1.01
Sep-03 35.41 32.95 32.73 1.08
Dec-03 32.15 33.62 33.29 0.97
Mar-04 31.84 34.22 33.92 0.94
Jun-04 35.08 34.55 34.38 1.02
Sep-04 37.80 35.05 34.80 1.09
Dec-04 33.46 35.46 35.25 0.95
Mar-05 33.85 35.53 35.50 0.95
Jun-05 36.73 35.41 35.47 1.04
Sep-05 38.09 35.18 35.30 1.08
Dec-05 32.98 34.90 35.04 0.94
Mar-06 32.93 35.32 35.11 0.94
Jun-06 35.61 35.91 35.61 1.00
Sep-06 39.76 36.83 36.37 1.09
Dec-06 35.32 37.91 37.37 0.95
Mar-07 36.61 38.64 38.28 0.96
Jun-07 39.95 39.30 38.97 1.03
Sep-07 42.69 39.84 39.57 1.08
Dec-07 37.94 40.24 40.04 0.95
Mar-08 38.76 41.05 40.65 0.95
Jun-08 41.57 42.13 41.59 1.00
Sep-08 45.94 43.38 42.75 1.07
Dec-08 42.25 45.06 44.22 0.96
Mar-09 43.75 47.18 46.12 0.95
Jun-09 48.29 48.65 47.91 1.01
Sep-09 54.43 50.49 49.57 1.10
Dec-09 48.11 51.75 51.12 0.94
Mar-10 51.11 53.07 52.41 0.98
Jun-10 53.33 53.99 53.53 1.00
Sep-10 59.71 54.21 54.10 1.10
Dec-10 51.81 54.31 54.26 0.95
Mar-11 52.00 53.56 53.93 0.96
Jun-11 53.71 52.95 53.25 1.01
Sep-11 56.72 52.27 52.61 1.08
Dec-11 49.36 52.50 52.39 0.94
Mar-12 49.30 52.25 52.38 0.94
Jun-12 54.63 52.52 52.38 1.04
Sep-12 55.71 53.19 52.85 1.05
Dec-12 50.43 53.78 53.48 0.94
Mar-13 51.99 54.50 54.14 0.96
Jun-13 56.97 55.15 54.82 1.04
Sep-13 58.61 56.59 55.87 1.05
Dec-13 53.02 57.31 56.95 0.93
Mar-14 57.75 57.86 57.59 1.00
Jun-14 59.87 58.68 58.27 1.03
Sep-14 60.80 58.66 58.67 1.04
Dec-14 56.28 59.65 59.15 0.95
Mar-15 57.67 61.10 60.37 0.96
Jun-15 63.86 62.64 61.87 1.03
Sep-15 66.57 64.36 63.50 1.05
Dec-15 62.44 66.33 65.34 0.96
Mar-16 64.57 68.26 67.30 0.96
Jun-16 71.73 69.62 68.94 1.04
Sep-16 74.31
Dec-16 67.86

Plot for original Series:

Plot for only trend (deseasonalised series) - Plotting colume (Centered 4MA):

Detrended plot for seasonality (plotting Detrended):

Short Explanation:

As, the data is given Quarter wise and seasonality is a component within year or of the duration 0-1 years. Hence, removing it by taking moving averages gave us the true picture of Trend over the years (as it can be seen in 2nd plot) and also, after removing trend from the series in column Detrended, its plot (3rd one) shows the seasonality pattern without trend. It can be seen that sales go up for month of June and go down for the month of September & December confirming our criteria for taking period of seasonality as 4.

Both the graphs 2nd and 3rd combine to make the 1st one.

2nd graph clearly shows only trend (no seasonality) as it is a smooth line moving upwards meaning that Sales are increasing over the years.

Please rate my answer and comment for doubt. It took a lot of effort, thanks.


Related Solutions

Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter...
Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter of 2017 is: Select one: a. 222.125 b. 333.875 c. 269.250 d. 243.625 Year QTR Revenue (in $1000) 2015 1 205 2 400 3 200 4 229 2016 1 236 2 219 3 211 4 200 2017 1 280 2 275 3 261 4 322 2018 1 500 2 230 3 310 4 400 2019 1 325 2 241 3 379 4 316
Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary).
Quarter Year 1 Year 2 Year 3 1 4 6 8 2 2 4 7 3 3 5 6 4 5 7 8 Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary). Year Quarter Time Series Value Four-Quarter Moving Average Centered Moving Average 1 1 4 2 2 3 3 4 5 2 1 6 2 4 3 5 4 7 3 1 8 2 7 3 6 4 8 Compute seasonal...
Periodic and Perpetual Systems —Calculating Ending Inventory and Cost of Sales using Average Cost, Moving Average,...
Periodic and Perpetual Systems —Calculating Ending Inventory and Cost of Sales using Average Cost, Moving Average, FIFO, LIFO, and Dollar-Value LIFO The inventory records of Mod Oil Company for January 2020 showed the following data for an item of its merchandise for sale (assume that the six transactions occurred in the order shown). Date Units Unit Cost Total Beginning inventory (Jan. 1) 900 $6.00 $5,400 Jan. 3 Purchases 1,080 6.10 6,588 Jan. 5 Sales (1,620 units) Jan. 10 Purchases 1,080...
Periodic and Perpetual Systems—Calculating Ending Inventory and Cost of Sales using Average Cost (Moving Average), FIFO,...
Periodic and Perpetual Systems—Calculating Ending Inventory and Cost of Sales using Average Cost (Moving Average), FIFO, and LIFO Undew Inc.’s inventory records showed the following data for an item it sells regularly. Date Units Unit Cost Jan 1 Inventory 2,000 $10.00 Jan 3 Purchases 18,000 10.40 Jan 7 Sales (at $26 per unit) 7,000 Jan 20 Purchases 6,000 11.00 Jan 22 Sales (at $27 per unit) 16,000 Jan 30 Purchases 3,000 12.00 a. Assuming that Undew maintains a periodic inventory...
The accompanying data file contains monthly observations for 5 years. a. Calculate the 12-month centered moving...
The accompanying data file contains monthly observations for 5 years. a. Calculate the 12-month centered moving average. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Calculate the ratio-to-moving average. (Do not round intermediate calculations.Round your answers to 2 decimal places.) Year Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec CMA:ybar Rate- to moving Average:y/ybar 1 28 30 19 10 28 10 39 31 26 28 18 22 2 20 21 39...
(a) Construct a time series plot. (b)Develop the three-week moving average forecasts for this time series.
Consider the following time series data. Week 1 2 3 4 5 6 Value 17 12 14 10 16 13 (a) Construct a time series plot. (b)Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 17 2 12 3 14 4 10 5 16 6 13 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use...
Moving average and weighed moving average. Report your findings
Moving average and weighed moving average. Report your findings
Plot the following data and determine the average rate for the loss of reactant at t...
Plot the following data and determine the average rate for the loss of reactant at t = 25 sec. Enter the numerical answer with 2 significant figures, no units and in scientific notation. For example; .00126 M/min would be entered as 1.3E-3 (no spaces) 2 A(g) → B 2(g) Time(sec) [A]: (mol/L) 0.0: 3.20x10-5 10.0: 2.42x10-5 20.0: 1.95x10-5 30.0: 1.63x10-5 40.0: 1.40x10-5 50.0: 1.23x10-5 60.0: 1.10x10-5
How do you graph outliers on a box plot when given a data set of numbers?...
How do you graph outliers on a box plot when given a data set of numbers? I found the median, lower and upper quartile numbers and have already plotted that but how do you plot outliers? Lets say the data is :1 2 3 4 5 6 7 8 9
what is a moving average?
what is a moving average?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT