Rank: Guest 
|
Posted By Deebee
Happy New Year to one and all.
I produce a monthly report of HS&E stats, including basic charts on such things as current LTI rate, reportable cases, near misses, year to date incidents etc.
I am concerned it's a little basic and would like this year to improve it by giving some trend type charts / analysis etc over the last few years.
Can anyone point me in the right direction please? eg providing me with a proforma, or if not, suggesting a suitable SIMPLE (!) training course...
Much appreciated
Thanks in advance
Dee
|
|
|
|
|
|
Rank: Guest
|
Posted By Chris Packham
Dee
If you have monthly statistics, one simple way of indicating trends is what is called a "moving average". You can decide on what period the average should cover, but say you decide to do a 12 month moving average, what you do is to add together the month and preceding 11 months, then divide by 12. You do this for each successive month and plot a graph. This smooths out monthly variations and gives you a good idea as to whether the trend is up or down. Plot it on the same chart as the monthly figures and you can easily see when in a single month the result is above or below the trend. This can then be investigated.
Obviously, there are more sophisticated methods, but I have found that this works well and does not take much time. Easy to set up on Excel.
Chris
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.