12 month moving average

[jesssaymsu]

I need help calculating a 12 month rolling average for employee turnover for the month of January. After I get the turnover, then I need to display this in a graph or sort.

I'm lost. I know how to do the rolling average for each the turnover and the headcount, then calculate Jan turnover, BUT i'm not sure I'm showing my director what they are expecting. What's expected to show the Jan 2014 vs. the Jan 2015 turnover for the rolling average.

Could someone please help!! I have attached my data.. i'm so lost

Data:

Terminations
Year	Termination Date	Total	12 Month Rolling Sum	12 Month /12
2014	Jan	63
Feb	56
Mar	49
Apr	69
May	99
Jun	93
Jul	84
Aug	102
Sep	78
Oct	136
Nov	76
Dec	64
2013	Jan	46	952	79.3333333
Feb	38	934	77.8333333
Mar	51	936	78
Apr	46	913	76.0833333
May	91	905	75.4166667
Jun	48	860	71.6666667
Jul	63	839	69.9166667
Aug	78	815	67.9166667
Sep	84	821	68.4166667
Oct	77	762	63.5
Nov	52	738	61.5
Dec	56	730	60.8333333
2015	Jan	84	768	64
Feb	16	746	62.1666667
Grand Total	1799

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>

Headcount

Headcount
Years	HC Month	Total	12 monthrolling Sum	12 month / 12		% of Turnover
2013	Jan	2919
Feb	2933
Mar	2957
Apr	3010
May	3047
Jun	3041
Jul	3091
Aug	3135
Sep	3161
Oct	3178
Nov	3164
Dec	3166
2014	Jan	3168	37051	3087.58333		30%
Feb	3154	37272	3106		30%
Mar	3182	37497	3124.75		29%
Apr	3213	37700	3141.66667		28%
May	3251	37904	3158.66667		28%
Jun	3274	38137	3178.08333		26%
Jul	3299	38345	3195.41667		25%
Aug	3388	38598	3216.5		24%
Sep	3407	38844	3237		24%
Oct	3435	39101	3258.41667		22%
Nov	3385	39322	3276.83333		22%
Dec	3420	39576	3298		21%
2015	Jan	3520	39928	3327.33333		22%
Grand Total	79898

<colgroup><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[jumbledore]

could you pls put this data in a workbook and upload it. you can upload it through a 3rd party website like upload.com and paste the link

 

[MARK858]

@jumbledore, the data the OP provided copies and pastes perfectly well into an Excel spreadsheet

 

[MARK858]

@ jesssaymsu I am just about to go to work and so don't have time to look at this now but will take a look tonight if nobody else has responded (but expect questions).

 

[jesssaymsu]

@ jesssaymsu I am just about to go to work and so don't have time to look at this now but will take a look tonight if nobody else has responded (but expect questions).

Thank you! I appreciate any support

 

[jumbledore]

@jumbledore, the data the OP provided copies and pastes perfectly well into an Excel spreadsheet

thanks

@jesssaymsu you need to correct the way the years are displayed. it should be start with the year 2013 and then 2014 and so on. your calculations appear to be correct. I am not sure how you calculated the % of Turnover. But I think you just need to show a graph of the 12 month rolling average for the months of 2014 and till feb 2015.