jesssaymsu
New Member
- Joined
- Aug 12, 2014
- Messages
- 8
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:
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Headcount
<colgroup><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>
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>