MGMT8520 Data Analytics Assignment 2: Outlier Detection and Employee Absenteeism PARTICULARS In this assignment, you will determine two things: first, the employees who are outliers in absenteeism within our company, and second, the costs associated with absenteeism and how they affect our company's profitability. You will analyze department, position, and demographic patterns and use employee data to help measure the costs of absenteeism to Headgames Inc. Utilize Excel and RapidMiner for this assignment and prepare a Word memo to senior management containing recommendations based on your analysis. You may complete this assignment individually or in teams of two. There are eight main questions to answer using Excel, and you should create as many worksheet tabs as necessary. BACKGROUND Annually, the human resources department calculates employee absenteeism for department managers across all divisions of Headgames Inc. The current manual process takes two weeks on average, leading to numerous questions and suggestions from managers. You aim to standardize the calculation process and create a data model that allows for quicker calculations in the future. Use RapidMiner to create a data model for detecting outliers and Excel to calculate the costs of absenteeism and chart the results as needed. Build a comprehensive dataset