Hr · Employees · Engagement Eda P1778698833
Executive Summary

Executive Summary

Key metrics for employee engagement and attrition

Employees Analysed
1470
Attrition Rate
16.1
Avg Overall Satisfaction
2.73
Avg Tenure (Years)
7
Avg Monthly Income
6503
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.
Interpretation

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.

Overview

Analysis Overview

Data structure and analysis scope

Employees Analysed1470
Attrition Rate16.1
Avg Overall Satisfaction2.73
Avg Tenure (Years)7
Avg Monthly Income6503
Interpretation

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 Preparation

Data Quality & Completeness

Data quality assessment and preprocessing results

Employees Analysed1470
Attrition Rate16.1
Avg Overall Satisfaction2.73
Avg Tenure (Years)7
Avg Monthly Income6503
Interpretation

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.

Visualization

Satisfaction Score Distributions

Distribution of environment, job, relationship, and work-life balance satisfaction scores (1-4 scale)

Interpretation

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.

Visualization

Satisfaction by Department

Average overall satisfaction score by department (1-4 scale)

Interpretation

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.

Visualization

Satisfaction by Job Role

Average overall satisfaction score by job role (1-4 scale)

Interpretation

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.

Visualization

Tenure Distribution

Distribution of years at company across the employee population

Interpretation

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.

Visualization

Satisfaction Metrics Correlation

Pearson correlations among satisfaction dimensions and performance rating (values from -1 to 1)

Interpretation

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.

Data Table

Attrition Profiles

Comparison of employees who left vs. those retained, by count, income, tenure, and satisfaction

CountAvg IncomeAvg TenureAttrition StatusAvg Satisfaction
123368337.4No2.77
23747875.1Yes2.55
Interpretation

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.

Visualization

Work-Life Balance & Overtime Status

Average work-life balance satisfaction by overtime status and department (1-4 scale)

Interpretation

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.

Data Table

Summary Statistics

Comprehensive descriptive statistics (min, Q1, median, mean, Q3, max) for all numeric variables

VariableMinQ1MedianMeanQ3Max
age18303636.924360
tenure_years0357.01940
monthly_income1009291149196503837919999
job_involvement1232.7334
job_satisfaction1232.7344
total_work_years061011.281540
work_life_balance1232.7634
distance_from_home1279.191429
performance_rating3333.1534
years_in_current_role0234.23718
years_since_promotion0012.19315
years_with_curr_manager0234.12717
environment_satisfaction1232.7244
relationship_satisfaction1232.7144
overall_satisfaction12.52.752.7334
Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing