solve

The calculations in this section will be performed in the section of the Excel spreadsheet titled "Turnover Analysis." Your first task is to determine the number of managers that left (e.g., turnover) in 2020. You need to calculate the number of trainees retained after each year, the probability of retention the following year, the number of employees remaining one year after that, and turnover losses each year. The following calculations are required: Total number of employees at the beginning of the year. This figure is calculated by counting the number of individuals who have a DOH. This can be computed using the = COUNTO function. The count function returns the number of cells that contain numeric data in a range of cells-it ignores empty or text cells. The COUNT function is used to count cells in a certain category. The function is written as follows: F COUNT (range) Where: range = the range of cells to count. Number of managers who left. This figure is calculated by counting the number of individuals who have a DOT date, using = COUNTO. Turnover rate is calculated by dividing the number of managers who left by the number of managers who worked for the organization at the beginning of the year. TurnoverRate=TotalNumberofTraineesmainingTotalNumberofTurnoverLosses Place this answer in cell D109. Average Tenure of Departures refers to the amount of time that an employee works for a given organization before leaving. It is determined by calculating the amount of time that passed between the employee's DOH and their DOT. This is done in EXCEL by subtracting DOH from DOT (column J). The result is the number of days that between date of hire and date of termination. Tenure in Days = DOT - DOH Calculate this value for each employee that left the organization in 2020 . Then average those values and place the answer in cell D112. Then divide this answer by 365 days per year to calculate the average tenure of departing employees in years. Round both of these answers to the first decimal place