Capstone project · HR · about 180 minutes
Engagement survey study: from fieldwork to a funded decision
Run a complete survey study: judge the design and response, audit response quality, summarise Likert items properly, weight for nonresponse with honest intervals, compare groups without fishing, and cost a retention programme.
The brief
Palmstone Group (a fictional services company with 1,400 employees in six departments) invited every employee to its annual engagement survey: a census design, open for three weeks. 778 people responded (55.6%).
The executive committee is worried about retention. Item q6 asks “I intend to be working here in 12 months' time” (1 = strongly disagree … 5 = strongly agree). The Chief People Officer has a proposal on the table: a retention and workload programme for the departments with the weakest intent to stay, costing SAR 120,000 in fixed design costs plus SAR 1,500 per employee covered. For this scenario, assume that replacing a leaver costs about SAR 40,000 (recruitment, onboarding and lost productivity). These costs are planning assumptions for a fictional company, not industry figures; real replacement costs vary widely by role.
You are the people-analytics lead. The committee wants a written study, not a dashboard:
- Can the survey be trusted? Who responded, how well, and what the design implies for next year.
- What do staff say about staying and about workload? Summarised in a way that respects the 1–5 scale.
- What is the company-wide picture once each department counts in proportion to its size, and how uncertain is it?
- Do groups differ (departments; remote vs onsite staff) — without fishing through dozens of tests?
- Should the programme be funded, for whom, and how will we know whether it worked?
Constraints. Results are reported by department only (no group under 10 people is ever shown), individual answers are confidential, and the programme budget must be approved before the next survey cycle.
The data. engagement_survey has one row per respondent (department, tenure band, work mode, six Likert items stored as codes 1–5 with some items skipped, completion time in seconds, submission date). engagement_population has each department's headcount, responses and response rate. Both datasets are synthetic — generated for teaching, describing no real company or employee — so none of the results is evidence about real workplaces.
Stakeholders. The executive committee (decides the budget), the Chief People Officer (sponsor of the programme), department heads (whose teams will be compared), and employees (who were promised confidentiality and action).
Dataset
Employee engagement survey
778 rows · one row = one survey response (one employee) · synthetic data
| Response | Department | Tenure | Work arrangement | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Completion time (seconds) | Submitted |
|---|---|---|---|---|---|---|---|---|---|---|---|
| R0001 | Customer Service | 1-3 years | Onsite | 3 | 2 | 1 | 2 | 1 | 2 | 216 | 2024-10-07 |
| R0002 | Customer Service | 1-3 years | Onsite | 3 | 2 | 3 | 2 | 3 | 2 | 299 | 2024-10-14 |
| R0003 | Technology | 3-5 years | Remote | 5 | 3 | 4 | 4 | 3 | 4 | 541 | 2024-10-10 |
| R0004 | Sales | 1-3 years | Onsite | 4 | 3 | 4 | 4 | 3 | 2 | 506 | 2024-10-19 |
| R0005 | Customer Service | 1-3 years | Onsite | 3 | 1 | 3 | 2 | 1 | 3 | 305 | 2024-10-06 |
| R0006 | Sales | 5-10 years | Hybrid | 4 | 4 | 4 | 4 | 4 | 4 | 63 | 2024-10-06 |
Included with a Formula Quest membership
This capstone has 6 stages and 23 graded tasks, ending with a written report.
View Formula Quest memberships