Prof Double R

12

Employee Attrition and Retention Analysis

The employee dataset offers an insight into the company’s human resource situation in view of an impending exit strategy. The data in the spreadsheet represents 1,470 employee records, of which 1,233 are currently employed, and 237 are former staff. Therefore, the percentage distribution of the data in the spreadsheet represents 83.9% current employees and 16.1 % former employees. The Status field, which distinguishes between current and former employees, forms the basis for all demographic and attrition comparisons in this analysis. Importantly, the report interprets relationships within the data as correlations, not causal links, since there is no clear reason for leaving. For a prospective buyer, the value lies in understanding the workforce structure, identifying patterns in turnover, and pinpointing areas where retention efforts could be strengthened.

Current Employee Demographics

The current staff structure may be considered relatively outstanding in terms of both professional experience and education. In particular, the average age of the workforce is 37.6 years, with the median at 36 years. At the same time, the average employee has about 11.9 years of experience, and the median is 10 years. The mean and median tenure are 7 years and 6 years, respectively. Overall, the workforce has both general and specialized professional experience.

As for the gender and marriage status, the majority of the current employees are men (59.4%), while women comprise 40.6%. In terms of marital status, 589 (47.8%) are married, 350 (28.4%) are single, and 294 (23.8%) are divorced. In terms of education, the largest group of employees possesses an undergraduate degree (473, 38.4%), followed by graduate students (340, 27.6%). Finally, 238 of the current employees (19.3%) have an associate degree, 139 (11.3%) – education through high school, and 43 (3.5%) hold doctorates.

The visualizations use different chart types because the variables have different purposes. The age histogram is appropriate for showing the distribution of a continuous variable and identifying the workforce’s concentration across age ranges. The horizontal education bar chart is better for comparing category sizes because the education categories have distinct labels and can be ranked easily. The clustered bar chart for marital status by gender provides a direct comparison of two categorical variables.

Figure 1. Current Employee Age Distribution

Figure 2. Current Employee Education Level

Figure 3. Current Employee Marital Status by Gender

Attrition Analysis

There is a significant number of risk patterns that are correlated with employee attrition. The top five factors associated with staff turnover were low work/life balance, sales representative job role, single marital status, long-distance travel, and job satisfaction. Employees with the lowest work/life balance score had the highest turnover rate of 31.3% compared to 14.2% for their colleagues at level 3. Sales representative’s job role was the most associated with attrition, at 39.8%. Employees who were single had the highest turnover rate of 25.5% followed by those who were married at 12.5% and divorced at 10.1%. Those who traveled frequently had an attrition rate of 24.9%, in contrast to 15% for rarely traveling and 8% for non-travelers. Those who were unsatisfied with their jobs had a turnover rate of 22.8% compared to 11.3% for their very satisfied counterparts.

It is important to note that the associations do not imply causation. For instance, the dataset could not establish whether there was an issue in the work environment that caused people to leave. Nevertheless, it is safe to conclude that the company has a turnover problem with areas like frequent travelers, and their retention strategy should address these issues. Research also supports paying attention to the work environment and employee satisfaction when designing retention strategies. A supportive work environment has been associated with employee retention, while job satisfaction has been linked to turnover intentions (Yusliza et al., 2020; Lin & Huang, 2021).

For employees who left, the median time since their last promotion was one year, while the average was about 1.95 years. The distribution therefore points to relatively recent promotion activity for many former employees, although some employees had much longer promotion gaps. The typical exit age was about 32 years, based on the median age of former employees, with an average age of 33.6 years. Tenure was even more revealing: former employees had a median of three years at the organization and an average of 4.7 years. The highest attrition rate occurred among employees with zero to one year of company tenure, at 34.9%. The rate declined to 18.4% over two to three years, 13.1% at four to five years, 12.2% at six to ten years, and 8.2% among employees with 11 or more years. This pattern indicates that early employment is the organization’s most important retention window.

Training results are also informative. Employees with no training in the previous year had a 27.8% attrition rate, while the rate was 17.9% for employees with two training events and 14.1% for employees with three. Five training events were associated with an 11.8% attrition rate. The data suggests that regular development may be associated with longer tenure and lower attrition. Former employees receiving two or three training events stayed at an average of 4.6 and 4.5 years, respectively, while current employees in those groups averaged about 7.0 and 7.2 years. Training should therefore be considered as part of a broader development and engagement strategy rather than as a stand-alone solution.

Figure 4. Highest-Observed Attrition Risk Factors

Figure 5. Former Employees: Age and Tenure at Exit

Figure 6. Training Frequency, Attrition, and Average Tenure

Retention and Organizational Stability

The current workforce does contain groups that resemble the historical attrition population, so some additional turnover should be expected if the organization does not intervene. For example, 208 current employees travel frequently, 223 reports being unsatisfied, 55 report the lowest work-life balance level, 350 are single, and 50 work as sales representatives. These groups are smaller than their total workforce categories, but each has a higher historical attrition rate than the organization-wide 16.1% rate. At the same time, the current workforce is more stable overall than the former employee group. Current employees have a median tenure of six years, compared with three years for former employees.

The strongest stability signal is the concentration of turnover early in employment.

Employees who remain beyond five or ten years show much lower historical attrition rates. This suggests that the organization has valuable retention strength once employees become established. The challenge is protecting the organization from losing newer employees before they build that organizational knowledge.

For a potential buyer, this workforce profile is both an asset and a risk. The organization has a large current employee base with meaningful experience and tenure, which supports continuity and knowledge retention. However, a buyer would likely examine the 16.1% historical attrition share and the unusually high turnover among early-tenure employees, sales representatives, frequent travelers, and dissatisfied employees. Career development, job satisfaction, and organizational support can improve employees’ intentions to stay (Kim & Park, 2020). The organization can therefore improve its perceived value by showing that it has identified retention risks and has a practical plan to address them before an acquisition.

Figure 7. Current vs. Former Employees by Company Tenure

Actionable Steps

First, the organization should develop a first-three-years retention program that would include a 30-, 60-, and 90-day check-in after the date of hire, a formal mentorship, and a six-monthly and annual career development discussion. This suggestion was made considering the sizeable 34.9% and 18.4% attrition rates among employees with zero to one year and one to two years of tenure, respectively. With this, it would be possible to ensure better onboarding experience and provide employees with more context about the firm’s expectations from them in exchange for their time and effort.

Second, the firm’s leadership should conduct a career and promotion audit in positions with higher turnover rates. The sales representative function area has a history of a substantially higher attrition rate (39.8%). As such, managers should deliberate on the timing and nature of promotions, developmental opportunities, workload, and overall satisfaction for these employees. The same practices should be applied to other employees who indicated low satisfaction with their current positions. Career development is a key factor that should be contemplated when trying to reduce turnover rates since it has been positively associated with employees’ intentions to stay (Kim & Park, 2020).

Thirdly, the organization needs to improve training and work-life balance. Individuals who have not received training recently had a 27.8% attrition rate compared to several groups that had regular training and had lower rates. It is essential to align training with individual career goals rather than attendance. It will be vital to consider the travel schedule and assess the flexibility of those constantly on the road or complain about their work-life balance. Creating the best environment can massively increase retention (Yusliza et al., 2020). It will help satisfy the buyer and ensure the organization has talented individuals even after the acquisition.

In summary, the organization has an invaluable human-capital asset. However, it needs to make changes to ensure it continues to have individuals with institutional knowledge. The recommendation highlights early retention, targeted support for high-turnover roles, improving individuals’ abilities, and encouraging better work-life balance as areas that can have immediate impact when improved. Improving these areas would imply a stable workforce to the board and potential buyers.

References

Kim, E.-J., & Park, S. (2020). Top management support for talent and culture on career changers’ organizational commitment and job satisfaction. Journal of Career Development, 47(6), 695–710. https://doi.org/10.1177/0894845318820967

Lin, C.-Y., & Huang, C.-K. (2021). Employee turnover intentions and job performance from a planned change: The effects of an organizational learning culture and job satisfaction. International Journal of Manpower, 42(3), 409–423. https://doi.org/10.1108/IJM-08-2018-0281

Yusliza, M. Y., Faezah, J. N., Ali, N., Noor, N. M. M., Ramayah, T., Tanveer, M. I., & Fawehinmi, O. (2020). Effects of supportive work environment on employee retention: The mediating role of person–organization fit. Industrial and Commercial Training, 53(3), 201–216. https://doi.org/10.1108/ICT-12-2019-0111