Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is, and should I use Weighted Average?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is, and should I use Weighted Average?
Haven't you answered the question yourself, calculate the average per
department based on the number in that department. Other than that, you have given us nothing to go on. -- __________________________________ HTH Bob "ArcticWolf" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is, and should I use Weighted Average?
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 You would use a weighted average for the company as a whole. With your example above, the company would have a S&A rate of 9.09%, which is calculated as total "off" / total people [(5 + 5) / (10 + 100)]. That would be different than if you would "average the averages" [(50% + 5%) / 2 = 27.5%]. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is, and should I use Weighted Average?
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 If you are trying to get to a company average others have steered you well. But you are asking about meaningful data for departments, and I think you are already there. If it is normal to have an S&A rate of 9% company wide, a department with a rate of 50% is clearly above normal, even within a reasonable margin of error, and despite that department having a staff of 10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weighted Average | Excel Worksheet Functions | |||
weighted average | Excel Worksheet Functions | |||
Weighted Average | Excel Discussion (Misc queries) | |||
Need help with weighted average | Excel Discussion (Misc queries) | |||
Weighted Average | New Users to Excel |