First-Year Attrition Among New Hires
This people-analytics study follows 400 new hires from a 30-day engagement survey through 12-month exit outcomes, using time-to-event (survival) methods on months_to_exit to examine how engagement, function, and manager tenure relate to who leaves and when.
- To describe engagement_score, manager_tenure_months, and demographics across the four functions.
- To assess the reliability of the engagement items engagement_1, engagement_2, engagement_3, engagement_4, engagement_5, and engagement_6.
- To determine whether engagement_score differs across the four functions.
- To determine the relationship between engagement_score and manager_tenure_months.
- To estimate Kaplan-Meier survival curves for months_to_exit by function and compare using the log-rank test.
- To model months_to_exit using Cox regression on engagement_score and manager_tenure_months.
| Column | Kind | Missing | Distinct |
|---|---|---|---|
| months_to_exit | numeric | 0 | 96 |
| event_indicator | numeric | 0 | 2 |
| employee_id | text | 0 | 400 |
| function | categorical | 0 | 4 |
| role_level | categorical | 0 | 3 |
| manager_tenure_months | numeric | 0 | 68 |
| engagement_1 | numeric | 0 | 6 |
| engagement_2 | numeric | 0 | 6 |
| engagement_3 | numeric | 0 | 6 |
| engagement_4 | numeric | 0 | 6 |
| engagement_5 | numeric | 0 | 7 |
| engagement_6 | numeric | 0 | 6 |
| engagement_score | numeric | 0 | 29 |
Detected a survival design with 12 analyzable variable(s) and 6 analytical question(s). Recommended 12 statistical test(s). Estimated cost: 94 credits.
| n | max | min | std | mean | mode | range | median | variable | variance |
|---|---|---|---|---|---|---|---|---|---|
| 400 | 71 | 3 | 20.020 | 36.828 | 25 | 68 | 37 | manager_tenure_months | 400.815 |
| 400 | 7 | 2.170 | 0.963 | 4.990 | 5.170 | 4.830 | 5 | engagement_score | 0.927 |
Internal consistency is excellent (alpha = 0.939).
| item | loading |
|---|---|
| engagement_1 | 0.841 |
| engagement_2 | 0.847 |
| engagement_3 | 0.861 |
| engagement_4 | 0.847 |
| engagement_5 | 0.839 |
| engagement_6 | 0.855 |
Internal consistency (McDonald's omega) is excellent (omega = 0.939).
| n | std | mean | group |
|---|---|---|---|
| 172 | 0.861 | 5.310 | Engineering |
| 67 | 0.931 | 5.209 | Marketing |
| 69 | 0.949 | 4.648 | Operations |
| 92 | 0.893 | 4.489 | Sales |
The result is statistically significant (p = 0.0000 < 0.05).
| pair | p value | mean diff | significant |
|---|---|---|---|
| Engineering vs Marketing | 0.862 | 0.101 | false |
| Engineering vs Operations | 0.000 | 0.662 | true |
| Engineering vs Sales | 0.000 | 0.821 | true |
| Marketing vs Operations | 0.002 | 0.561 | true |
| Marketing vs Sales | 0.000 | 0.720 | true |
| Operations vs Sales | 0.680 | 0.159 | false |
Pairwise comparisons with family-wise error control (Tukey HSD).
The result is not statistically significant (p = 0.3566 >= 0.05).
| n | group | events | censored | median survival | restricted mean |
|---|---|---|---|---|---|
| 172 | Engineering | 114 | 58 | 5.800 | 0.595 |
| 67 | Marketing | 47 | 20 | 5.900 | 0.626 |
| 69 | Operations | 58 | 11 | 2.500 | 0.472 |
| 92 | Sales | 78 | 14 | 1.500 | 0.460 |
Observed 297 event(s) in 400 subject(s).
| n | group | events |
|---|---|---|
| 172 | Engineering | 114 |
| 67 | Marketing | 47 |
| 69 | Operations | 58 |
| 92 | Sales | 78 |
The result is statistically significant (p = 0.0000 < 0.05).
| coef | p value | hr ci low | predictor | hr ci high | hazard ratio |
|---|---|---|---|---|---|
| 0.052 | 0.765 | 0.750 | function_Marketing | 1.479 | 1.053 |
| 0.592 | 0.000 | 1.316 | function_Operations | 2.481 | 1.807 |
| 0.680 | 0.000 | 1.477 | function_Sales | 2.637 | 1.973 |
The result is statistically significant (p = 0.0000 < 0.05).
| n | group | events | censored | median survival | restricted mean |
|---|---|---|---|---|---|
| 400 | overall | 297 | 103 | 4 | 0.487 |
Observed 297 event(s) in 400 subject(s).
| coef | p value | hr ci low | predictor | hr ci high | hazard ratio |
|---|---|---|---|---|---|
| -0.003 | 0.361 | 0.991 | manager_tenure_months | 1.003 | 0.997 |
| -0.967 | 0.000 | 0.332 | engagement_score | 0.435 | 0.380 |
The result is statistically significant (p = 0.0000 < 0.05).
Publication-ready report
Tests used · Results · Discussion — generated from the computed statistics.
Download the exact Jupyter notebook or Python script that reproduces these results with widely-used libraries (scipy, statsmodels, lifelines).
Run your own study
Bring your problem statement, objectives, and a dataset — thericerca does the rest.
Get started →