I'm producing a report on sickness absence and have been asked for an average (mean) figure by department.
Some areas are skewed by having a small number of absences over an extremely long term (i.e. one department has a total of 400 days absence across 7 employees, but over 180 days of this is...