Question: Case4. Job Performance Evaluation Mr. Ito is a personnel division manager of a corporation X that produces chemical producers such as cosmetics, treatments, additives, drugs
Case4. Job Performance Evaluation Mr. Ito is a personnel division manager of a corporation X that produces chemical producers such as cosmetics, treatments, additives, drugs etc. He is directed by his superior to analyze the 70 sales employees of the overall one-year performance and make a report summarizing the analysis. He is provided an attached file (File: Employee's Evaluation) which contains "Individual ID"(Column1), "Production Division ID(Column2), Gender (Column3), Quarterly Sales (thousand US dollars) (Column4-7, and sum in Column8), and test score (evaluating an individual potential capability, Column 9 full score is 100 points), Column 10 is job satisfaction, Column 11 is employee's evaluation of the superior (low 0 to high 5). Grading is required to evaluate an individual by five ranks with specified distribution from top notch A 10%, B:20%, C:30%, D:30%, to low grade E:10%.
a. Mr. Ito evaluates employees based on the superior's guidance to evaluate all 70 employees with "sales" whose weight is 2/3 and "test score weight 1/3. Use and report statistical notion such as the mean, standard deviation, percentile, and others to analyze. Show grade of ID 1-5.
b. What reservations and limitation should Mr. Ito present in his report? To simplify the analysis and to make a quick evaluation, can Mr. Ito use Q1 and Q2 sales instead of Q1- Q4 sales? Or can he use just only "test score" to achieve the same grading results as in a ?
c. When Mr. Ito attempts to use additional data in the file such as product division, job satisfaction, what evaluation he could make? In adopting a method to include other available data in this file evaluate employees and compare the results of ID 1-5 made in question a.
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| Employee ID | Product Group ID | Gender 0=femal, 1=male | Sale Q1 | Sale Q2 | Sale Q3 | Sale Q4 | Sale Sum | Test score (100) | Job satisfaction | Superior Satisfaction (1) |
| 1 | 1 | 0 | 2 | 3 | 3 | 3 | 11 | 63 | 4 | 1 |
| 2 | 1 | 0 | 1 | 2 | 2 | 1 | 6 | 61 | 3 | 4 |
| 3 | 1 | 1 | 0 | 1 | 2 | 0 | 3 | 46 | 1 | 5 |
| 4 | 1 | 1 | 1 | 3 | 3 | 2 | 9 | 62 | 4 | 5 |
| 5 | 1 | 0 | 3 | 1 | 2 | 3 | 9 | 56 | 0 | 5 |
| 6 | 1 | 1 | 0 | 1 | 1 | 0 | 2 | 57 | 5 | 3 |
| 7 | 1 | 0 | 2 | 3 | 1 | 1 | 7 | 59 | 3 | 4 |
| 8 | 1 | 0 | 2 | 1 | 2 | 2 | 7 | 67 | 0 | 1 |
| 9 | 2 | 1 | 2 | 1 | 0 | 2 | 5 | 66 | 1 | 0 |
| 10 | 2 | 0 | 2 | 6 | 4 | 4 | 16 | 51 | 3 | 3 |
| 11 | 2 | 1 | 2 | 2 | 2 | 1 | 7 | 48 | 3 | 1 |
| 12 | 2 | 0 | 1 | 1 | 1 | 4 | 7 | 71 | 5 | 0 |
| 13 | 2 | 1 | 0 | 1 | 2 | 1 | 4 | 53 | 4 | 4 |
| 14 | 2 | 0 | 2 | 2 | 1 | 3 | 8 | 53 | 4 | 1 |
| 15 | 2 | 0 | 2 | 2 | 3 | 4 | 11 | 68 | 5 | 4 |
| 16 | 2 | 1 | 3 | 2 | 3 | 3 | 11 | 63 | 3 | 5 |
| 17 | 2 | 0 | 1 | 0 | 1 | NA(2) | 2 | 72 | 0 | 3 |
| 18 | 2 | 1 | 3 | 2 | 3 | 3 | 11 | 74 | 2 | 1 |
| 19 | 2 | 0 | 4 | 2 | 1 | 2 | 9 | 64 | 1 | 5 |
| 20 | 2 | 1 | 4 | 6 | 3 | 4 | 17 | 55 | 5 | 2 |
| 21 | 2 | 1 | 1 | 3 | 2 | 2 | 8 | 71 | 5 | 0 |
| 22 | 2 | 1 | 1 | 2 | 1 | 1 | 5 | 52 | 0 | 4 |
| 23 | 2 | 0 | 5 | 3 | 2 | 3 | 13 | 61 | 5 | 3 |
| 24 | 2 | 0 | 1 | 1 | 1 | 2 | 5 | 67 | 3 | 1 |
| 25 | 2 | 1 | 1 | 2 | 3 | 2 | 8 | 72 | 4 | 4 |
| 26 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 2 | 1 |
| 27 | 2 | 0 | 2 | 0 | 1 | 2 | 5 | 46 | 3 | 0 |
| 28 | 2 | 0 | 4 | 2 | 3 | 6 | 15 | 66 | 0 | 5 |
| 29 | 2 | 1 | 4 | 2 | 5 | 3 | 14 | 70 | 1 | 5 |
| 30 | 3 | 0 | 2 | 2 | 1 | 2 | 7 | 52 | 4 | 1 |
| 31 | 3 | 1 | 2 | 2 | 0 | 1 | 5 | 31 | 3 | 3 |
| 32 | 3 | 1 | 3 | 3 | 3 | 4 | 13 | 20 | 3 | 2 |
| 33 | 3 | 0 | 2 | 1 | 2 | 0 | 5 | 61 | 4 | 0 |
| 34 | 3 | 1 | 1 | 0 | 2 | 2 | 5 | 57 | 5 | 3 |
| 35 | 3 | 0 | 4 | 1 | 2 | 0 | 7 | 65 | 1 | 2 |
| 36 | 3 | 1 | 1 | 3 | 4 | 3 | 11 | 69 | 5 | 5 |
| 37 | 3 | 0 | 2 | 3 | 2 | 1 | 8 | 62 | 2 | 3 |
| 38 | 3 | 1 | 3 | 3 | 1 | 2 | 9 | 68 | 1 | 4 |
| 39 | 3 | 0 | 2 | 1 | 2 | 3 | 8 | 59 | 2 | 2 |
| 40 | 3 | 0 | 1 | 1 | 4 | 4 | 10 | 66 | 0 | 3 |
| 41 | 3 | 1 | 2 | 2 | 2 | 4 | 10 | 70 | 0 | 0 |
| 42 | 3 | 0 | 0 | 2 | 4 | 1 | 7 | 55 | 0 | 5 |
| 43 | 3 | 1 | 1 | 2 | 1 | 3 | 7 | 40 | 0 | 4 |
| 44 | 3 | 0 | 1 | 5 | 1 | 2 | 9 | 68 | 0 | 5 |
| 45 | 3 | 0 | 0 | 2 | 2 | 2 | 6 | 54 | 3 | 5 |
| 46 | 3 | 0 | 4 | 4 | 3 | 6 | 17 | 69 | 5 | 3 |
| 47 | 3 | 1 | 1 | 2 | 1 | 3 | 7 | 67 | 1 | 2 |
| 48 | 3 | 1 | 3 | 1 | 1 | 0 | 5 | 70 | 5 | 1 |
| 49 | 4 | 0 | 5 | 5 | 2 | 3 | 15 | 73 | 3 | 2 |
| 50 | 4 | 0 | 2 | 1 | 3 | 2 | 8 | 71 | 4 | 5 |
| 51 | 4 | 1 | 3 | 2 | 2 | 1 | 8 | 72 | 4 | 5 |
| 52 | 4 | 0 | 2 | 1 | 1 | 4 | 8 | 30 | 0 | 0 |
| 53 | 4 | 1 | 1 | 3 | 5 | 4 | 13 | 39 | 2 | 2 |
| 54 | 4 | 0 | 2 | 3 | 2 | 2 | 9 | 63 | 4 | 4 |
| 55 | 4 | 0 | 5 | 4 | 4 | 6 | 19 | 72 | 2 | 0 |
| 56 | 4 | 0 | 4 | 2 | 2 | 1 | 9 | 54 | 4 | 2 |
| 57 | 4 | 1 | 8 | 3 | 3 | 1 | 15 | 52 | 5 | 0 |
| 58 | 4 | 0 | 8 | 6 | 3 | 3 | 20 | 60 | 0 | 5 |
| 59 | 4 | 1 | 1 | 1 | 1 | 2 | 5 | 59 | 3 | 1 |
| 60 | 4 | 1 | 4 | 3 | 5 | 3 | 15 | 70 | 1 | 0 |
| 61 | 4 | 1 | 5 | 2 | 5 | 4 | 16 | 78 | 0 | 3 |
| 62 | 5 | 0 | 3 | 3 | 3 | 2 | 11 | 70 | 0 | 2 |
| 63 | 5 | 1 | 2 | 1 | 2 | 2 | 7 | 71 | 0 | 5 |
| 64 | 5 | 0 | 2 | 2 | 1 | 2 | 7 | 76 | 2 | 1 |
| 65 | 5 | 1 | 1 | 1 | 2 | 3 | 7 | 15 | 5 | 5 |
| 66 | 5 | 0 | 3 | 2 | 2 | 3 | 10 | 65 | 1 | 5 |
| 67 | 5 | 1 | 2 | 2 | 1 | 1 | 6 | 61 | 5 | 2 |
| 68 | 5 | 1 | 0 | 1 | 1 | 1 | 3 | 55 | 5 | 3 |
| 69 | 5 | 1 | 2 | 2 | 2 | 3 | 9 | 50 | 1 | 3 |
| 70 | 5 | 1 | 4 | 6 | 2 | 6 | 18 | 75 | 1 | 5 |
| 70 | 70 | |||||||||
| AVERAGE | 8,9 | 59,3 | ||||||||
| MODE | 7,0 | 70,0 | ||||||||
| MEDIAN | 8,0 | 62,5 | ||||||||
| VAR.P | 18,0 | 205,8 | ||||||||
| VAR.S | 18,3 | 208,7 | ||||||||
| STDEV.P | 4,2 | 14,3 | ||||||||
| STDEV.S | 4,3 | 14,4 | ||||||||
| MAX | 20,0 | 78,0 | ||||||||
| Q3 | 11,0 | 70,0 | ||||||||
| Q2 | 8,0 | 62,5 | ||||||||
| Q1 | 6,0 | 53,8 | ||||||||
| MIN | 1,0 | 0,0 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts