Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |