Presented below are two sets of data. Firstly, review the absence data that is presented in Table 1 and provide analysis of it to show: a) trends across departments b) absence by type c) absence by gender d) total days lost through absence e) annual total costs through absence based on a 37-hour working week. Present your finding using appropriate diagrammatical forms and make justifiable recommendations based on your evaluations. Tahle 1 Ahcencedata Table 2 gives the rating feedback scores from employees that work for manager A. Provide scrutiny of the applied scores and present written commentary on any themes or patterns that might be occurring and present recommendations based on your findings. Table 2 - Feedback scores The ratings show represent statements on a scale of 15 where: 1 = fully agree, 2= agree, 3= not sure, 4= disagree, 5= strongly disagree Task Two-Quantitative and qualitative analysis With reference to a people practice issue, interpret analytical data using appropriate analysis tools and methods. (AC2.1) Wordcount: Approximately 400 words. Type here... analysis tools and methods. (Approximately 400 words) KFY FOCUS AREA. Examine the 2 sets of data in the assignment brief (Task 2) What does the data tell you? The people practice issue you are analysing is absence in Table 1 Review the data and provide an analysis that covers for example: - Percentage calculations how many men/women were absent overall? - Choose some departments- how many men/women were absent in those departments - Review which departments have had the most/least absence - Absence by type of reason-how many people have been absent with certain illnesses? - Or how many days have been lost for each illness - Cost-which department has incurred the most/least cost due to absence - What anomalies are there? Where is the data unusual? You might want to look at the marketing department data. You MUST complete the following analysis: - Calculate the total days lost (add up the days) - Annual total cost through absence based on a 37 -hour working week Length of working day x hourly rate= daily rate Daily rate x number of days absent for each employee= total cost of that person Total cost of each employee should then be added up tor an overall total cost of absence Summarise your findings in writing - Now look at Table 2 and present a written commentary on the themes and patterns that might be occurring Make justified recommendations based on evaluation of the benefits, risks and financial implications of potential solutions. (AC2.3) Wordcount: Approximately 400 words. Type here... Presented below are two sets of data. Firstly, review the absence data that is presented in Table 1 and provide analysis of it to show: a) trends across departments b) absence by type c) absence by gender d) total days lost through absence e) annual total costs through absence based on a 37-hour working week. Present your finding using appropriate diagrammatical forms and make justifiable recommendations based on your evaluations. Tahle 1 Ahcencedata Table 2 gives the rating feedback scores from employees that work for manager A. Provide scrutiny of the applied scores and present written commentary on any themes or patterns that might be occurring and present recommendations based on your findings. Table 2 - Feedback scores The ratings show represent statements on a scale of 15 where: 1 = fully agree, 2= agree, 3= not sure, 4= disagree, 5= strongly disagree Task Two-Quantitative and qualitative analysis With reference to a people practice issue, interpret analytical data using appropriate analysis tools and methods. (AC2.1) Wordcount: Approximately 400 words. Type here... analysis tools and methods. (Approximately 400 words) KFY FOCUS AREA. Examine the 2 sets of data in the assignment brief (Task 2) What does the data tell you? The people practice issue you are analysing is absence in Table 1 Review the data and provide an analysis that covers for example: - Percentage calculations how many men/women were absent overall? - Choose some departments- how many men/women were absent in those departments - Review which departments have had the most/least absence - Absence by type of reason-how many people have been absent with certain illnesses? - Or how many days have been lost for each illness - Cost-which department has incurred the most/least cost due to absence - What anomalies are there? Where is the data unusual? You might want to look at the marketing department data. You MUST complete the following analysis: - Calculate the total days lost (add up the days) - Annual total cost through absence based on a 37 -hour working week Length of working day x hourly rate= daily rate Daily rate x number of days absent for each employee= total cost of that person Total cost of each employee should then be added up tor an overall total cost of absence Summarise your findings in writing - Now look at Table 2 and present a written commentary on the themes and patterns that might be occurring Make justified recommendations based on evaluation of the benefits, risks and financial implications of potential solutions. (AC2.3) Wordcount: Approximately 400 words. Type here