Challenge, difficulty 3 of 3
Correcting for nonresponse
The engagement survey over-represents the more engaged departments. Estimate the mean answer to q6_intend_stay (“I intend to be working here in 12 months' time”, 1–5) for all employees by weighting:
- compute the mean of
q6_intend_stayin each department (ignore skipped answers); - weight each department mean by the department's headcount:
| Department | Headcount |
|---|---|
| Operations | 420 |
| Customer Service | 330 |
| Sales | 260 |
| Technology | 210 |
| Finance | 120 |
| Human Resources | 60 |
Give the weighted mean to 2 decimal places. (Treating the 1–5 codes as numbers is a simplification commonly used for tracking.)
Data: engagement_survey · Open in the lab to explore and calculate.