In: Statistics and Probability
year |
quarter |
period |
EMPLOYED INDIVIDUALS (2016-2019) |
|
1 |
1 |
1 |
4169189.0 |
|
1 |
2 |
2 |
4262978.0 |
|
1 |
3 |
3 |
4306669.0 |
|
1 |
4 |
4 |
4310845.0 |
|
2 |
1 |
5 |
4338992.0 |
|
2 |
2 |
6 |
4387124.0 |
|
2 |
3 |
7 |
4372602.0 |
|
2 |
4 |
8 |
4431912.0 |
|
3 |
1 |
9 |
4495638.0 |
|
3 |
2 |
10 |
4520797.0 |
|
3 |
3 |
11 |
4558422.0 |
|
3 |
4 |
12 |
4582166.0 |
|
4 |
1 |
13 |
4648638.0 |
|
4 |
2 |
14 |
4657061.0 |
|
4 |
3 |
15 |
4631183.0 |
|
4 |
4 |
16 |
4715879.0 |
|
Number of people |
With these time series:
Using time series decomposition, present a seasonally adjusted series for your assigned data (assume the multiplicative model).
Centered | |||||||
Moving | Ratio to | Seasonal | Data | ||||
t | Year | Quarter | Data | Average | CMA | Indexes | Deseasonalized |
1 | 1 | 1 | 4169189 | 1.002 | 41,59,833.1 | ||
2 | 1 | 2 | 4262978 | 1.002 | 42,56,048.2 | ||
3 | 1 | 3 | 4306669 | 4283646 | 1.005 | 0.999 | 43,11,405.0 |
4 | 1 | 4 | 4310845 | 4320389 | 0.998 | 0.997 | 43,22,857.5 |
5 | 2 | 1 | 4338992 | 4344149 | 0.999 | 1.002 | 43,29,255.1 |
6 | 2 | 2 | 4387124 | 4367524 | 1.004 | 1.002 | 43,79,992.4 |
7 | 2 | 3 | 4372602 | 4402238 | 0.993 | 0.999 | 43,77,410.5 |
8 | 2 | 4 | 4431912 | 4438528 | 0.999 | 0.997 | 44,44,261.9 |
9 | 3 | 1 | 4495638 | 4478465 | 1.004 | 1.002 | 44,85,549.5 |
10 | 3 | 2 | 4520797 | 4520474 | 1.000 | 1.002 | 45,13,448.1 |
11 | 3 | 3 | 4558422 | 4558381 | 1.000 | 0.999 | 45,63,434.9 |
12 | 3 | 4 | 4582166 | 4594539 | 0.997 | 0.997 | 45,94,934.6 |
13 | 4 | 1 | 4648638 | 4620667 | 1.006 | 1.002 | 46,38,206.2 |
14 | 4 | 2 | 4657061 | 4646476 | 1.002 | 1.002 | 46,49,490.6 |
15 | 4 | 3 | 4631183 | 0.999 | 46,36,275.9 | ||
16 | 4 | 4 | 4715879 | 0.997 | 47,29,020.2 | ||
Calculation of Seasonal Indexes | |||||||
1 | 2 | 3 | 4 | ||||
1 | 1.005 | 0.998 | |||||
2 | 0.999 | 1.004 | 0.993 | 0.999 | |||
3 | 1.004 | 1.000 | 1.000 | 0.997 | |||
4 | 1.006 | 1.002 | |||||
mean: | 1.003 | 1.002 | 1.000 | 0.998 | 4.003 | ||
adjusted: | 1.002 | 1.002 | 0.999 | 0.997 | 4.000 |
The graph is: