You just learned how to create a transition matrix in Excel. Now, it$$s time to apply your new skills to a different dataset,

which appears in the sheet called $$Practice$$ in the Excel workbook; the job titles contained within the $$Practice$$ sheet

are $($in descending order in terms of job level$)$: Floor Manager, Sales Associate, Cashier, and Product Runner. Once you

have created a transition matrix with raw values and a transition matrix with proportions, respond to the following

questions.

$1.$Which job$($s$)$ showed the most turnover $($left the organization$)$ from $2023$ to $2024?$

$2.$What other trends did you notice?

$3.$In terms of workforce planning, what will you recommend to the organization based on your interpretations of

the transition matrices?

EmployeeID $20232024$

EE$301$ Not in Organization Product Runner

EE$302$ Not in Organization Product Runner

EE$303$ Not in Organization Cashier

EE$304$ Not in Organization Cashier

EE$305$ Not in Organization Sales Associate

EE$306$ Not in Organization Sales Associate

EE$307$ Not in Organization Sales Associate

EE$308$ Not in Organization Sales Associate

EE$309$ Not in Organization Sales Associate

EE$231$ Sales Associate Sales Associate

EE$232$ Sales Associate Sales Associate

EE$233$ Sales Associate Sales Associate

EE$234$ Sales Associate Floor Manager

EE$235$ Sales Associate Floor Manager

EE$236$ Sales Associate Not in Organization

EE$237$ Floor Manager Floor Manager

EE$240$ Floor Manager Not in Organization

EE$241$ Floor Manager Not in Organization

EE$242$ Product Runner Not in Organization

EE$249$ Product Runner Product Runner

EE$271$ Product Runner Cashier

EE$272$ Product Runner Not in Organization

EE$273$ Product Runner Not in Organization

EE$274$ Product Runner Not in Organization

EE$279$ Cashier Cashier

EE$288$ Cashier Cashier

EE$289$ Cashier Sales Associate

EE$292$ Cashier Sales Associate

EE$293$ Cashier Not in Organization

EE$294$ Cashier Not in Organization