What is, and should I use Weighted Average?
Good question!!
Never average the percentages.
Always get the totals and then calculate a percentage:
(5+5)/(10+100)=
10/110=
9.09%
--
Gary''s Student - gsnu200825
"ArcticWolf" wrote:
Hi,
I calculate Sickness and Absence (S&A) data for my company, by department.
Each department can have between 5 - 100 people in it. I currently do a S&A
% of the department and then as company as a whole.
Because in one team we could have 5/10 people off = 50% S&A rate, yet in
another department 5/100 = 5%.
Is there a better way of calculating the % S&A for each department that will
give more meaningful data?
Thanks in advance,
AW
|