Question: Problem #1. Create charts Using Excel or by hand Given the data above, create a histogram of the Employee ages in the plant in five
Problem #1.
Create charts Using Excel or by hand
- Given the data above, create a histogram of the Employee ages in the plant in five year increments.
- Given the data above, create a pareto chart of Employee ages in the plant in five year increments.
- On the histogram, draw and label a line showing the mean age of all employees (show calculation below the chart).
- On the pareto chart draw and label a line showing the approximate median age of all employees (show calculation below the chart)
- Create a second pareto chart of the years of service of the employees in the plant in five year increments.
- Create a second histogram of the years or service of the employees in the plant in five year increments.
- On the second histogram, draw and label a line showing the mean age of all employees (show calculation below the chart).
- On the second pareto chart draw and label a line showing the approximate median age of all employees (show calculation below the chart)
For all charts in Problems #1 & #2, be sure to clearly label the X & Y axis
Create charts Using Excel or by hand
Date & Shift Source Plan Nb Shift Ave per Total Shift Week per Status G G G G G G G 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 2 shifts 2 shifts 2 shifts 2 shifts 2 shifts Rework 170 158 181 185 158 174 181 170 171 174 183 175 Rework 1,428 2,117 2.206 1,984 2,089 1,895 2.083 1,879 2.041 1,371 1,415 994 1,053 784 G G G G G G Y 167 1,148 Y Wk01 (3 w 1264 Wk02 640 Wk03 1156 Wk04 1120 Wk05 1056 Wk06 1176 Wk07 1100 EDI Wk08 876 Wk09 872 Wk10 1180 Wk11 760 Wk12 1028 Wk13 1080 Wk14 (4working days) 1264 Production Wk15 1225 Planning Wk15 1225 Wk16 1225 Wk17 1400 Wk18 (1 bank holiday) 1050 Wk19 (2 bank holiday) 1050 Wk20 1575 Wk21 1225 Wk22 1575 Wk23 1750 Wk24 1050 Production Wk25 1750 Planning Wk26 1400 Wk27 1225 Wk28 1575 Wk29 1575 Wk30 1575 Wk31 1400 Wk32 1575 Wk33 1575 Wk34 1575 Wk35 1400 Wk36 2100 Wk37 2625 Wk38 2450 Wk39 1925 Wk40 2275 Wk41 1925 Wk42 1925 Y G G Y Y G Y Y Y G 7 shifts a week 7 shifts a week 7 shifts a week 8 shifts a week 6 shifts a week 6 shifts a week 9 shifts a week 7 shifts a week 9 shifts a week 10 shifts a week 6 shifts a week 10 shifts a week 8 shifts a week 7 shifts a week 9 shifts a week 9 shifts a week 9 shifts a week 8 shifts a week 9 shifts a week 9 shifts a week 9 shifts a week 8 shifts a week 12 shifts a week 15 shifts a week 14 shifts a week 11 shifts a week 13 shifts a week 11 shifts a week 11 shifts a week 167 190 192 165 173 175 171 169 174 177 175 178 178 178 178 164 159 172 181 190 174 174 175 173 173 172 137 162 1,148 1,345 1.538 1,040 1,038 1,575 1,133 1,521 1,740 1,064 1,752 1,550 1,282 1,679 1,600 1,432 1,210 1,544 1,513 1,726 1,394 1,500 2,620 2,425 1,875 2,297 1,506 1,951 G Y Y Y Y G Y R G G G G Y G Date & Shift Source Plan Nb Shift Ave per Total Shift Week per Status G G G G G G G 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 3 shifts 2 shifts 2 shifts 2 shifts 2 shifts 2 shifts Rework 170 158 181 185 158 174 181 170 171 174 183 175 Rework 1,428 2,117 2.206 1,984 2,089 1,895 2.083 1,879 2.041 1,371 1,415 994 1,053 784 G G G G G G Y 167 1,148 Y Wk01 (3 w 1264 Wk02 640 Wk03 1156 Wk04 1120 Wk05 1056 Wk06 1176 Wk07 1100 EDI Wk08 876 Wk09 872 Wk10 1180 Wk11 760 Wk12 1028 Wk13 1080 Wk14 (4working days) 1264 Production Wk15 1225 Planning Wk15 1225 Wk16 1225 Wk17 1400 Wk18 (1 bank holiday) 1050 Wk19 (2 bank holiday) 1050 Wk20 1575 Wk21 1225 Wk22 1575 Wk23 1750 Wk24 1050 Production Wk25 1750 Planning Wk26 1400 Wk27 1225 Wk28 1575 Wk29 1575 Wk30 1575 Wk31 1400 Wk32 1575 Wk33 1575 Wk34 1575 Wk35 1400 Wk36 2100 Wk37 2625 Wk38 2450 Wk39 1925 Wk40 2275 Wk41 1925 Wk42 1925 Y G G Y Y G Y Y Y G 7 shifts a week 7 shifts a week 7 shifts a week 8 shifts a week 6 shifts a week 6 shifts a week 9 shifts a week 7 shifts a week 9 shifts a week 10 shifts a week 6 shifts a week 10 shifts a week 8 shifts a week 7 shifts a week 9 shifts a week 9 shifts a week 9 shifts a week 8 shifts a week 9 shifts a week 9 shifts a week 9 shifts a week 8 shifts a week 12 shifts a week 15 shifts a week 14 shifts a week 11 shifts a week 13 shifts a week 11 shifts a week 11 shifts a week 167 190 192 165 173 175 171 169 174 177 175 178 178 178 178 164 159 172 181 190 174 174 175 173 173 172 137 162 1,148 1,345 1.538 1,040 1,038 1,575 1,133 1,521 1,740 1,064 1,752 1,550 1,282 1,679 1,600 1,432 1,210 1,544 1,513 1,726 1,394 1,500 2,620 2,425 1,875 2,297 1,506 1,951 G Y Y Y Y G Y R G G G G Y G
Study Help