2. Imagine that there are four job titles of interest (in descending order in terms of...

  

Transcribed Image Text:

2. Imagine that there are four job titles of interest (in descending order in terms of job level): Civil Engineering Manager, Civil Engineering Associate, Assistant Civil Engineer, and Trainee. Use the Excel worksheet and create a transition matrix with raw values and a transition matrix with proportions, respond to the following questions. a. Which job(s) showed the most turnover (left the organization) from 2018 to 2019? b. What other trends did you notice? c. In terms of workforce planning, what will you recommend to the organization based on your interpretations of the transition matrices? C12 A X V fx Civil Engineering Associate A B D. 1 EmployeelD 2 EE301 2018 2019 Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Civil Engineering Associate CiMI Engineering Associate Civil Engineering Associate Cil Engineering Associate Civil Engineering Manager Civil Engineering Associate Civil Engineering Associate Civil Engineering Manager Civil Engineering Manager Civil Engineering Manager Not in Organization Trainee Trainee 3 EE302 4. EE303 Assistant Civil Engineer 5 EE304 5 EE305 7 EE306 Assistant Civil Engineer Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate 8 EE307 9 EE308 10 EE309 11 EE231 12 EE232 13 EE233 14 EE234 15 EE235 Civil Engineering Manager Not in Organization Civil Engineering Manager Not in Organization 16 EE236 17 EE237 18 EE240 19 EE241 20 EE242 Not in Organization Trainee 21 EE249 Trainee Trainee 22 EE271 Assistant Cvil Engineer Not in Organization Not in Organization Not in Organization Assistant Ovil Engineer Assistant Civil Engineer CiMl Engineering Associate Civil Engineering Associate Not in Organization Not in Organization Trainee 23 EE272 24 EE273 25 EE274 Trainee Trainee Trainee 26 EE279 Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer 27 EE288 28 EE289 29 EE292 30 EE293 31 EE294 32 33 34 35 36 01 2. Imagine that there are four job titles of interest (in descending order in terms of job level): Civil Engineering Manager, Civil Engineering Associate, Assistant Civil Engineer, and Trainee. Use the Excel worksheet and create a transition matrix with raw values and a transition matrix with proportions, respond to the following questions. a. Which job(s) showed the most turnover (left the organization) from 2018 to 2019? b. What other trends did you notice? c. In terms of workforce planning, what will you recommend to the organization based on your interpretations of the transition matrices? C12 A X V fx Civil Engineering Associate A B D. 1 EmployeelD 2 EE301 2018 2019 Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Not in Organization Civil Engineering Associate CiMI Engineering Associate Civil Engineering Associate Cil Engineering Associate Civil Engineering Manager Civil Engineering Associate Civil Engineering Associate Civil Engineering Manager Civil Engineering Manager Civil Engineering Manager Not in Organization Trainee Trainee 3 EE302 4. EE303 Assistant Civil Engineer 5 EE304 5 EE305 7 EE306 Assistant Civil Engineer Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate Civil Engineering Associate 8 EE307 9 EE308 10 EE309 11 EE231 12 EE232 13 EE233 14 EE234 15 EE235 Civil Engineering Manager Not in Organization Civil Engineering Manager Not in Organization 16 EE236 17 EE237 18 EE240 19 EE241 20 EE242 Not in Organization Trainee 21 EE249 Trainee Trainee 22 EE271 Assistant Cvil Engineer Not in Organization Not in Organization Not in Organization Assistant Ovil Engineer Assistant Civil Engineer CiMl Engineering Associate Civil Engineering Associate Not in Organization Not in Organization Trainee 23 EE272 24 EE273 25 EE274 Trainee Trainee Trainee 26 EE279 Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer Assistant Civil Engineer 27 EE288 28 EE289 29 EE292 30 EE293 31 EE294 32 33 34 35 36 01

Answer rating: 100% (QA)

A Transition Matrix is also called the Markov Matrix which helps to understand the movement of people within different jobs in a company We will find ... View the full answer