You just learned how to create a transition matrix in Excel. Now, its time to apply your new skills to a different dataset, which appears in the sheet called Practice in the Excel spreadsheet; 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.

EmployeeID	2017	2018
EE301	Not in Organization	Product Runner
EE302	Not in Organization	Product Runner
EE303	Not in Organization	Cashier
EE304	Not in Organization	Cashier
EE305	Not in Organization	Sales Associate
EE306	Not in Organization	Sales Associate
EE307	Not in Organization	Sales Associate
EE308	Not in Organization	Sales Associate
EE309	Not in Organization	Sales Associate
EE231	Sales Associate	Sales Associate
EE232	Sales Associate	Sales Associate
EE233	Sales Associate	Sales Associate
EE234	Sales Associate	Floor Manager
EE235	Sales Associate	Floor Manager
EE236	Sales Associate	Not in Organization
EE237	Floor Manager	Floor Manager
EE240	Floor Manager	Not in Organization
EE241	Floor Manager	Not in Organization
EE242	Product Runner	Not in Organization
EE249	Product Runner	Product Runner
EE271	Product Runner	Cashier
EE272	Product Runner	Not in Organization
EE273	Product Runner	Not in Organization
EE274	Product Runner	Not in Organization
EE279	Cashier	Cashier
EE288	Cashier	Cashier
EE289	Cashier	Sales Associate
EE292	Cashier	Sales Associate
EE293	Cashier	Not in Organization
EE294	Cashier	Not in Organization

1.Which job(s) showed the most turnover (left the organization) from 2017 to 2018? What might this be attributed to?

2.What other trends did you notice? Look and comment beyond the obvious information and data shown.

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

4. Discuss the value and potential for the use of "Transition Matrices" in an organization. How can these benefit an organization, or YOUR organization.

Be sure to submit your assignment correctly, and include the properly formatted cover page, etc. (your entire submission needs to be in just ONE file)