Charts and graph

Human Resources and Attrition Analysis Report Your Name Subject and Section Professor’s Name November 8, 2024 In this report, the author of this article analyzes the workforce demography and attrition for the organization where he worked in the position of business development manager for one of the biggest life sciences organizations in the Midwest region. Specifically, the purpose of the analysis is to help make informed decisions about the company’s human resources with a specific focus on employees’ turnover and job stability. As would be shown later, such insights are useful when the possibility of an acquisition of the organization is being considered. Employees are an endearing capital and presenting evidence of the many qualified and talented employees on the organization’s payroll may potentially show the organization to be more valuable to a buyer, particularly one that operates in the life sciences sector. Overall, this corporate report also comprises the characterization of the current and ex-employees in terms of age, gender, education level and field of education in the form of the graphical data representation. Current Employee Demographics After conducting an analysis of the human resource data, the company found the portrayal of the employee status as pie chart which states the increased retention rate where there were about 1,233 current employee against to 237 ex-employees, which presents an 84% retention rate thereby suggesting the employees are “satisfied, engaged, and committed to the organization” (Memon et al., 2021). Accordingly, this is good for the organization since high turnover means that the organization is reliable for providing workforce hence will attract more buyers. Figure 1. Status Count of Employees. Moving forward to the age distribution, it can be deduced by constructing a box-plot diagram that the current employees possess an average age of about 37.6 while the former employees shop possess an average age of about 33.6 only. The observed lower average age among former employees point to a higher turnover rate of young employees, thus, the present study was consistent with previous workforce studies that have indicated that attrition varies with the age of the employee. However, the significance of this different should be tested with statistical tools to determine whether there is a high correlation between the age of the employees and their turnover rate. Figure 2. Gender Distribution among Employees. Third, gender was presented in the form of a stacked bar chart where it was observed that out of 1233 employees currently working in the organization; 732 are male employees, and 501 are female employees. The retention also seems blur across genders with a slightly higher number of retention in the male employees. Personally, the author believes that this balanced retention is encouraging because research shows that gender diversity might help improve stability of organisations, which is supported by other studies that are done in the same subject matter (Ferrary & Deo, 2023). Figure 3. Education Levels (Dark blue for Current; Light Blue for Former employees). Fourth, this study resulted in the grouped bar chart of the education levels whereby 473 current employees obtained undergraduate degrees, 340 acquired graduate degrees and 238 employees acquired associate degrees. It indicates that high educated employees are likely to have higher retention rates, which can be important in the acquisition situation, as the trained human capital is considered as an appeal. Figure 4. Education Field Distribution. Finally, the distribution of education field was presented in the form of a stacked bar chart. The results specifically show that; 327 of current and 45 of former employees are in Life Sciences; while 239 of current and 40 of former employees are in Medical fields; whereas non GE fields such as Marketing, Human Resource, and Technical Degrees are much fewer. High turnover in core competencies areas like Life Sciences and Medical is beneficial for the organizations’ valuati...