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:
