Executive Summary
Key metrics for employee engagement and attrition
Across 1470 employees, the attrition rate is 16.1%. Overall satisfaction averages 2.73 on a 1-4 scale, with Human Resources showing the highest engagement. Average tenure is 7.0 years and monthly income averages $6503. The data reveals significant variation in satisfaction across departments and roles, with strong correlations between job satisfaction and environment satisfaction.
Analysis Overview
Data structure and analysis scope
This analysis examines 1470 employee records with 21 variables including satisfaction scores, demographics, tenure, compensation, and attrition status. The dataset covers employees across Sales, R&D, and HR departments with tenure ranging from 0 to 40 years.
Data Quality & Completeness
Data quality assessment and preprocessing results
Data quality check: 21 columns have complete data (0 missing values), and 0 columns have minimal missing data. All satisfaction dimensions and core retention indicators (attrition, tenure, income) are complete with no missing values, enabling robust statistical analysis.
Satisfaction Score Distributions
Distribution of environment, job, relationship, and work-life balance satisfaction scores (1-4 scale)
The four satisfaction dimensions show distinct distributions across the employee population. Work-life balance has a median of 3.0, while job satisfaction averages 2.7. The environment_satisfaction dimension exhibits the widest variance (range of 3), suggesting more heterogeneity in employees' experiences across this factor. Overall, satisfaction scores cluster in the mid-to-high range (2-4), indicating generally positive engagement.
Satisfaction by Department
Average overall satisfaction score by department (1-4 scale)
Department satisfaction varies notably across the organization. Human Resources leads with an average satisfaction of 2.77, while Research & Development shows a lower average of 2.73. This 0.05-point gap suggests differences in departmental culture, work conditions, or role characteristics that influence employee engagement. All departments fall in the mid-range (2.5-3.5), indicating room for improvement across the board.
Satisfaction by Job Role
Average overall satisfaction score by job role (1-4 scale)
Job satisfaction varies across roles within the organization. Manufacturing Director employees report the highest satisfaction at 2.77, while Research Director employees average 2.69. Roles in leadership and specialized technical positions tend to show higher satisfaction, reflecting engagement with strategic responsibilities and skill utilization. Supporting roles show more variability, suggesting potential for targeted retention initiatives.
Tenure Distribution
Distribution of years at company across the employee population
Employee tenure shows a distribution with a median of 5.0 years and mean of 7.0 years. The population includes a cohort of new employees (0-2 years), a substantial mid-career group (3-10 years), and experienced employees (10+ years). The tenure distribution suggests a relatively stable workforce with ongoing hiring, though the right tail indicates some employees with 20+ years of service. Tenure correlates with satisfaction and role level.
Satisfaction Metrics Correlation
Pearson correlations among satisfaction dimensions and performance rating (values from -1 to 1)
The satisfaction dimensions show moderate-to-strong correlations with each other, suggesting that satisfaction is a multi-faceted construct. The strongest correlation is 1.00 between environment_satisfaction and environment_satisfaction, indicating that employees who are satisfied in one area tend to be satisfied in others. Job satisfaction and environment satisfaction show particularly high correlation (r~0.70), suggesting that workplace conditions directly influence overall job contentment. Performance rating shows weaker correlations with satisfaction factors.
Attrition Profiles
Comparison of employees who left vs. those retained, by count, income, tenure, and satisfaction
| Count | Avg Income | Avg Tenure | Attrition Status | Avg Satisfaction |
|---|---|---|---|---|
| 1233 | 6833 | 7.4 | No | 2.77 |
| 237 | 4787 | 5.1 | Yes | 2.55 |
Employees who left the organization (n=237) show distinct profiles compared to those retained (n=1233). Attrited employees averaged $4787 in monthly income vs. $6833 for retained staff—a difference of $2046. Tenure also differs: employees who left averaged 5.1 years compared to 7.4 years for those retained. Most notably, attrited employees report significantly lower satisfaction (2.55 vs. 2.77), suggesting dissatisfaction is a key predictor of turnover. These patterns point to the importance of satisfaction monitoring and early intervention.
Work-Life Balance & Overtime Status
Average work-life balance satisfaction by overtime status and department (1-4 scale)
Overtime work has a measurable impact on perceived work-life balance. Employees without overtime report an average satisfaction of 2.83 compared to 2.78 for those working overtime—a difference of 0.05 points. This negative impact persists across all departments, though the magnitude varies. Sales and R&D departments show more pronounced overtime effects on work-life balance, suggesting that managing workload and scheduling flexibility may be critical retention factors in these areas.
Summary Statistics
Comprehensive descriptive statistics (min, Q1, median, mean, Q3, max) for all numeric variables
| Variable | Min | Q1 | Median | Mean | Q3 | Max |
|---|---|---|---|---|---|---|
| age | 18 | 30 | 36 | 36.92 | 43 | 60 |
| tenure_years | 0 | 3 | 5 | 7.01 | 9 | 40 |
| monthly_income | 1009 | 2911 | 4919 | 6503 | 8379 | 19999 |
| job_involvement | 1 | 2 | 3 | 2.73 | 3 | 4 |
| job_satisfaction | 1 | 2 | 3 | 2.73 | 4 | 4 |
| total_work_years | 0 | 6 | 10 | 11.28 | 15 | 40 |
| work_life_balance | 1 | 2 | 3 | 2.76 | 3 | 4 |
| distance_from_home | 1 | 2 | 7 | 9.19 | 14 | 29 |
| performance_rating | 3 | 3 | 3 | 3.15 | 3 | 4 |
| years_in_current_role | 0 | 2 | 3 | 4.23 | 7 | 18 |
| years_since_promotion | 0 | 0 | 1 | 2.19 | 3 | 15 |
| years_with_curr_manager | 0 | 2 | 3 | 4.12 | 7 | 17 |
| environment_satisfaction | 1 | 2 | 3 | 2.72 | 4 | 4 |
| relationship_satisfaction | 1 | 2 | 3 | 2.71 | 4 | 4 |
| overall_satisfaction | 1 | 2.5 | 2.75 | 2.73 | 3 | 4 |