IOSH forums home
»
Our public forums
»
OSH discussion forum
»
Can you Pro Rata AIR figures to compare monthly stats to HSE Figures
Rank: New forum user
|
I have started with a company that employes a lot of sub-contractors. Each month they are asking for a "rolling" monthly AIR figure in comparison to the HSE average AIR figure for construction (that being 330, as taken from the Home builders federation statistics ). my question is,, is this possible to do by pro rata'ing the 100,000 by 12 ?
Therefore the 100,000 divide by 12 , this would be = 8333. -- the company has had 3 x minor accidents during January and we have had 500 persons work for us during January .
Working this our would be 3 / 500 = 0.006 , times this by the pro rata'd rate , being 8333 = an AIR of 49.9.
If we then divide the HSE AIR figure of 330 by 12 it gives 27.5. therefore is it fair to state that for January our company had an AIR statistic of 49.9 against a monthly AIR from the HSE that would be 27.5
I hope that makes sense,, apologies if not as getting very confused
|
|
|
|
Rank: Super forum user
|
Simon
someone may know better but my undertsanding of a "rolling" AIR figure is that it increases each month.
and the end of your 12 month reporting period the 1st month drops off. If you have had 3 accidents in january and none in february you still have 3 accidents for that year - to try and take monthly averages will realy confuse your figures.
|
|
|
|
Rank: Super forum user
|
I'm with Brian on this. To me a rolling figure means the up to date figure for the last 12 months, regardless of calendar year. So each accident drops out of it after a year has elapsed. The "monthly" bit doesn't mean the accidents in the last month and doesn't involve any pro-rata, it just means you work it out each month, for the preceding 12 months. So once January is over, you work out the figure based on accidents in the period last February to January just gone. Once February is over, you do the same thing for last March to February just gone. And so on. You need a nice spreadsheet that will automate this.
|
|
|
|
Rank: Super forum user
|
Mathematically, you can do all sorts of things, and some of teh things you've done are correct, and some are not, but I'm not sure it's useful.
330 injuries per 100,000 workers per year is the same thing as 27.5 per 100,000 workers per month, yes.
However 3 injuries per 500 workers per month is equivalent to a rate of 600 injuries per 100,000 workers per month. So the figure for your company that you would compare to teh 27.5 (if you decided to) would be 600.
Any statistics built on a sample where you're only getting 3 isn't likely to be representative. If 'they' want a figure updated monthly I wouldn't give them a figure for just the month, I'd give them a figure for the preceding year recalculated each month, as the other replies have suggested. It's probably easier to make comparisons, and with a larger sample it will probably be more representative (though it will be slower to react to changes, good and bad).
|
|
|
|
IOSH forums home
»
Our public forums
»
OSH discussion forum
»
Can you Pro Rata AIR figures to compare monthly stats to HSE Figures
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.