this mest you may want to python. You must both the lend a document which 1 Constructed chart these chute 2 Contract the charted chart whechtice for each 1 Construct the standard Bar chur and out. Do this chat Control the water that and the chur Construct the chart and that we are the content Construct the standerd actor and chat row the The word onder what thouder the determine the process is what should you do Deprecation de vecante e ne peut Terpent on toplam yw.. what percentage of the show what percent on the procese charreton. With new men proces center, wat percentage of the attaa wed? what percentage 11. What should be printer www.weat with a manable in #2 What should the proces standard to be one that way these deal with the Station this! 13/24/200 6. 613 66 153 19 612 641 > 3 4 5 ES 09 15.45 19 199 54 5. 12011/2013:15 543 643 44 41 64 06 E 6.4 64 7 140 64 61 62 SETE ST 12 DS 45 14 15 65 SY 641 21 12/2009 9.25 11.00 14 15.15 18/201995 10:20 17 18 19 ME 59 WE 64 660 661 ESS 615 654 51 SU 6 545 6. 71 2 5.4 03 64 661 64 6.43 30 25 645 then you may neemt, or python. You must both the lenda document which 1 Constructeur and chart. De these two chuti 2 Contract the Marchand chart wichtime that becamera 1 Construct the standard Burchart and Rourt Drew this chan Control the chartsDe there wocher Construct the car and that when the cort Construct the standard Wartort und schart Draw the charts The real or What should do the determine the process what hell you down the room wa Yumor payu 1. what percentage of that were permanente changed to Wishemen procenter , wat percentage of the stretta a ked what percentage de change the win? 1. What should the renowned with this membent 12 What should the proces standard in beide to have won you when deal with the 10 6 * 613 636 641 157 17 2 3 4 & 64 E E 15.45 99 09 54 SH 122/2013 544 543 54 61 41 643 44 61 648 64 54 11 145 64 6 12 GIF 6 6 62 18 14 15 40 142 12 15:55 12/28/2013 025 9.25 11.90 14 17 141 52 EN 6.90 5 666 661 64 45 1995 10:20 44 79 30 71 2 9 38 25 6. 65 64 6 & 03 CP 661 6.40 1625 654 ' ' By manufactures metal shafts Data given in the table bellow shows the shafts height. You must use software to solve Diment you may use Excel minital or python. You must submit both the software file and a document file which contains talenters for the following questions 1 Construct the trial Bar chart and R chart. Draw these two charts. Construct the revised Bar chart and R chart. Draw these two charts. Assume that there is an assignable cause for each out of control point 3. Construct the standard XBar chart and R chart. Draw these two charts 4. Construct the trial Bar chart and s chart. Draw these two charts $ Construct the revised Bar chart and schart. Draw these two charts. Assume that there is an assignable cause for each out af control point 6. Construct the standard Bar chart and schart. Draw these two charts 1. the specifications are 6.44 and 6.39, determine the process capability based on R chart. What should you do to improve the process capability? Suggest solutions 8. If the specifications are 6.44 and 6.39, determine the process capability based on s chart. What should you do to improve the process capability? Suggest solutions 9. Which one do you recommend to use point 7 or point 8 above? Explain your answer in details 10 ( what percentage of the shafts is reworked? What percentage is scrapped? til for various reasons, the process average is changed to 6 2 mm. With this new mean or process center what percentage of the shafts is reworked? What percentage is scrapped) is the change in the process center a wise decision? 11. What should the process mean be in order to have pk=1 How can you use the 5m=1E to deal with this situation? Is this a reasonable solution? 12. What should the process standard deviation be in order to have sek 1. How can you use the 5m+1E to deal with this situation? Is this a reasonable solution? edition. On + 100% 111 is a reasonable solution? ID Number Subgroup 12/26/2019 8:50 1 11:30 2 13.45 3 15:45 4 16:20 5 12/27/2019 8:35 6 9.00 7 9:40 8 13:30 9 14:50 10 12/28/2019 8:30 11 13:35 12 14:25 13 14:35 14 15:55 15 12/29/2019 8:25 16 9:25 17 11:00 18 14:35 19 15:15 20 12/30/2019 9:35 21 10:20 22 1135 24 X 6.35 6.46 6.34 6.69 6.38 6.42 6.44 6.33 6.48 6,47 6.38 6.37 6.4 6.38 6.5 6.33 6.41 6.38 6.35 6.56 6.38 6.39 X2 6.4 6.37 6.4 6.64 6.34 6.41 6.41 6.41 6.44 6.43 6.41 6.37 6.38 6.39 6.42 6,35 6.4 6.44 6.41 6.55 6.4 6.42 X; 6.32 6.36 6.34 6.68 6.44 6.43 6.41 6.38 6.47 6.36 6.39 6.41 6.47 6.45 6.43 6.29 6.29 6.28 6.37 6.95 6.45 6:35 6.39 6,35 X 6.37 6.41 6.36 6.59 6.4 6.34 6.46 6.36 6.95 6.42 6.38 6.37 6.35 6.42 6.45 6.39 6.34 6.58 6.38 6.48 6.37 6:4 6.36 6 38 6.94 6.44 6.33 6.48 6.47 6.38 6.37 6.4 6.38 6.29 6.29 6.28 6.37 6.45 6.45 6.35 6.39 6.36 6.34 6.68 6.44 6.43 6.41 638 6.36 6139 6.28 em 100% uh_salee ABC company manufactures metal shafts, Data given in the table bellow shows the shafts height. You must use software to solve this assignment you may use Excel, minitab, or python. You must submit both the software file and a document file which contains detailed answers for the following questions: 1. Construct the trial Bar chart and R chart. Draw these two charts. 2. Construct the revised XBar chart and R chart. Draw these two charts. Assume that there is an assignable cause for each out of control point. 3. Construct the standard XBar chart and R chart. Draw these two charts. 4. Construct the trial Bar chart and s chart. Draw these two charts. 5. Construct the revised XBar chart and s chart. Draw these two charts. Assume that there is an assignable cause for each out of control point. 6. Construct the standard XBar chart and s chart. Draw these two charts 7. If the specifications are 6.44 and 6.39, determine the process capability based on R chart. What should you do to improve the process capability? Suggest solutions 8. of the specifications are 6.44 and 6.39, determine the process capability based on s chart. What should you do to improve the process capability? Suggest solutions 9. Which one do you recommend to use point 7 or point 8 above? Explain your answer in details. 10. (i) what percentage of the shafts is reworked? What percentage is scrapped? (ii) for various reasons, the process average is changed to 6.2 mm. With this new mean or process center, what percentage of the shafts is reworked? What percentage is scrapped? (8) is the change in the process center a wise decision? 11. What should the process mean be in order to have cpk=1. How can you use the 5m+1E to deal with this situation? Is this a reasonable solution? 12. What should the process standard deviation be in order to have cpk 1. How can you use the 5m+1E to deal with this situation? Is this a reasonable solution? in Manil this mest you may want to python. You must both the lend a document which 1 Constructed chart these chute 2 Contract the charted chart whechtice for each 1 Construct the standard Bar chur and out. Do this chat Control the water that and the chur Construct the chart and that we are the content Construct the standerd actor and chat row the The word onder what thouder the determine the process is what should you do Deprecation de vecante e ne peut Terpent on toplam yw.. what percentage of the show what percent on the procese charreton. With new men proces center, wat percentage of the attaa wed? what percentage 11. What should be printer www.weat with a manable in #2 What should the proces standard to be one that way these deal with the Station this! 13/24/200 6. 613 66 153 19 612 641 > 3 4 5 ES 09 15.45 19 199 54 5. 12011/2013:15 543 643 44 41 64 06 E 6.4 64 7 140 64 61 62 SETE ST 12 DS 45 14 15 65 SY 641 21 12/2009 9.25 11.00 14 15.15 18/201995 10:20 17 18 19 ME 59 WE 64 660 661 ESS 615 654 51 SU 6 545 6. 71 2 5.4 03 64 661 64 6.43 30 25 645 then you may neemt, or python. You must both the lenda document which 1 Constructeur and chart. De these two chuti 2 Contract the Marchand chart wichtime that becamera 1 Construct the standard Burchart and Rourt Drew this chan Control the chartsDe there wocher Construct the car and that when the cort Construct the standard Wartort und schart Draw the charts The real or What should do the determine the process what hell you down the room wa Yumor payu 1. what percentage of that were permanente changed to Wishemen procenter , wat percentage of the stretta a ked what percentage de change the win? 1. What should the renowned with this membent 12 What should the proces standard in beide to have won you when deal with the 10 6 * 613 636 641 157 17 2 3 4 & 64 E E 15.45 99 09 54 SH 122/2013 544 543 54 61 41 643 44 61 648 64 54 11 145 64 6 12 GIF 6 6 62 18 14 15 40 142 12 15:55 12/28/2013 025 9.25 11.90 14 17 141 52 EN 6.90 5 666 661 64 45 1995 10:20 44 79 30 71 2 9 38 25 6. 65 64 6 & 03 CP 661 6.40 1625 654 ' ' By manufactures metal shafts Data given in the table bellow shows the shafts height. You must use software to solve Diment you may use Excel minital or python. You must submit both the software file and a document file which contains talenters for the following questions 1 Construct the trial Bar chart and R chart. Draw these two charts. Construct the revised Bar chart and R chart. Draw these two charts. Assume that there is an assignable cause for each out of control point 3. Construct the standard XBar chart and R chart. Draw these two charts 4. Construct the trial Bar chart and s chart. Draw these two charts $ Construct the revised Bar chart and schart. Draw these two charts. Assume that there is an assignable cause for each out af control point 6. Construct the standard Bar chart and schart. Draw these two charts 1. the specifications are 6.44 and 6.39, determine the process capability based on R chart. What should you do to improve the process capability? Suggest solutions 8. If the specifications are 6.44 and 6.39, determine the process capability based on s chart. What should you do to improve the process capability? Suggest solutions 9. Which one do you recommend to use point 7 or point 8 above? Explain your answer in details 10 ( what percentage of the shafts is reworked? What percentage is scrapped? til for various reasons, the process average is changed to 6 2 mm. With this new mean or process center what percentage of the shafts is reworked? What percentage is scrapped) is the change in the process center a wise decision? 11. What should the process mean be in order to have pk=1 How can you use the 5m=1E to deal with this situation? Is this a reasonable solution? 12. What should the process standard deviation be in order to have sek 1. How can you use the 5m+1E to deal with this situation? Is this a reasonable solution? edition. On + 100% 111 is a reasonable solution? ID Number Subgroup 12/26/2019 8:50 1 11:30 2 13.45 3 15:45 4 16:20 5 12/27/2019 8:35 6 9.00 7 9:40 8 13:30 9 14:50 10 12/28/2019 8:30 11 13:35 12 14:25 13 14:35 14 15:55 15 12/29/2019 8:25 16 9:25 17 11:00 18 14:35 19 15:15 20 12/30/2019 9:35 21 10:20 22 1135 24 X 6.35 6.46 6.34 6.69 6.38 6.42 6.44 6.33 6.48 6,47 6.38 6.37 6.4 6.38 6.5 6.33 6.41 6.38 6.35 6.56 6.38 6.39 X2 6.4 6.37 6.4 6.64 6.34 6.41 6.41 6.41 6.44 6.43 6.41 6.37 6.38 6.39 6.42 6,35 6.4 6.44 6.41 6.55 6.4 6.42 X; 6.32 6.36 6.34 6.68 6.44 6.43 6.41 6.38 6.47 6.36 6.39 6.41 6.47 6.45 6.43 6.29 6.29 6.28 6.37 6.95 6.45 6:35 6.39 6,35 X 6.37 6.41 6.36 6.59 6.4 6.34 6.46 6.36 6.95 6.42 6.38 6.37 6.35 6.42 6.45 6.39 6.34 6.58 6.38 6.48 6.37 6:4 6.36 6 38 6.94 6.44 6.33 6.48 6.47 6.38 6.37 6.4 6.38 6.29 6.29 6.28 6.37 6.45 6.45 6.35 6.39 6.36 6.34 6.68 6.44 6.43 6.41 638 6.36 6139 6.28 em 100% uh_salee ABC company manufactures metal shafts, Data given in the table bellow shows the shafts height. You must use software to solve this assignment you may use Excel, minitab, or python. You must submit both the software file and a document file which contains detailed answers for the following questions: 1. Construct the trial Bar chart and R chart. Draw these two charts. 2. Construct the revised XBar chart and R chart. Draw these two charts. Assume that there is an assignable cause for each out of control point. 3. Construct the standard XBar chart and R chart. Draw these two charts. 4. Construct the trial Bar chart and s chart. Draw these two charts. 5. Construct the revised XBar chart and s chart. Draw these two charts. Assume that there is an assignable cause for each out of control point. 6. Construct the standard XBar chart and s chart. Draw these two charts 7. If the specifications are 6.44 and 6.39, determine the process capability based on R chart. What should you do to improve the process capability? Suggest solutions 8. of the specifications are 6.44 and 6.39, determine the process capability based on s chart. What should you do to improve the process capability? Suggest solutions 9. Which one do you recommend to use point 7 or point 8 above? Explain your answer in details. 10. (i) what percentage of the shafts is reworked? What percentage is scrapped? (ii) for various reasons, the process average is changed to 6.2 mm. With this new mean or process center, what percentage of the shafts is reworked? What percentage is scrapped? (8) is the change in the process center a wise decision? 11. What should the process mean be in order to have cpk=1. How can you use the 5m+1E to deal with this situation? Is this a reasonable solution? 12. What should the process standard deviation be in order to have cpk 1. How can you use the 5m+1E to deal with this situation? Is this a reasonable solution? in Manil