please help me. this is my third try sending this problem. Hope its clearer. i need this workon an excel sheet.. please show all workings. thanks

15.01 1 2 3 5 5 7 Tiger Tools Case Tiger Tools, a division of Drillmore Industries, was about to launch new product Production Manager Michelle York asked her assistent, Jim Paterson to check the capability of the overed in the proces Jin obtained 18 random samples of 20 pieces each. The results of the samples are shown in the following table. After he analyzed the data, he concluded that the process was not capable based on specification width of 1.44 cm. Michelle was quite disappointed when she heard this. She had hoped that the rodation of the new product her operation could run close to full capacity and regain one of its lostbuster. The company had a freeze on capital expenditures of more than $10,000, and a replacement one would cost many times that amount. Jim Peterson worked with the oven crew to see if perla different could produce the desired results, but they were unable to achieve any meaningful improvements Sample Msan Range Sample Mese as 10 ST 40 11 84 45.00 12 UN 45.00 93 13 18.00 45.04 27 14 90 15 06 20 10 15.04 17 15.00 TO E Still not ready to concede, Michelle contacted one of her former professors and explained the problem. The professor suggested obtaining another set of samples, this time in a smaller ample site and taking more samples, Michelle the conferred with Jim and they agreed that he would take 27 samples of five observations each. The results are shown in the following table. Sample Same 1 TS 15.00 4496 16 1 445 4457 37 45.02 10 45.00 20 16 41 4501 30 21 22 45 GB 38 30 10 15.12 40 10 500 11 45.07 25 450 35 20 45.01 449 Me 2 3 4 5 7 2 41 3 9 WEB BN TE 41 40 14 Questions Consider the following questions, and then write a brief report to Michelle summarizing your findings. Be sure to include your calculations for supporting your findings. To guide your report and expectations see the Case Study rubric in the syllabus or in the course information area. Submit your report in your week 8 drop-box labeled Final Exam Tiger Tools Case Study 1. How did Jim conclude that the process was not capable based on his first set of samples? (Hint: Estimate the process standard deviation, a, using 2. Does the second set of samples show anything that the first set didn't? Explain what and why 3. Assuming the problem can be found and corrected, what impact do you think this would have on the capability of the process? Compute the potential process capability using the second data set. 4.If small samples can reveal something that large samples might not why not just take small samples in every situation? 15.01 1 2 3 5 5 7 Tiger Tools Case Tiger Tools, a division of Drillmore Industries, was about to launch new product Production Manager Michelle York asked her assistent, Jim Paterson to check the capability of the overed in the proces Jin obtained 18 random samples of 20 pieces each. The results of the samples are shown in the following table. After he analyzed the data, he concluded that the process was not capable based on specification width of 1.44 cm. Michelle was quite disappointed when she heard this. She had hoped that the rodation of the new product her operation could run close to full capacity and regain one of its lostbuster. The company had a freeze on capital expenditures of more than $10,000, and a replacement one would cost many times that amount. Jim Peterson worked with the oven crew to see if perla different could produce the desired results, but they were unable to achieve any meaningful improvements Sample Msan Range Sample Mese as 10 ST 40 11 84 45.00 12 UN 45.00 93 13 18.00 45.04 27 14 90 15 06 20 10 15.04 17 15.00 TO E Still not ready to concede, Michelle contacted one of her former professors and explained the problem. The professor suggested obtaining another set of samples, this time in a smaller ample site and taking more samples, Michelle the conferred with Jim and they agreed that he would take 27 samples of five observations each. The results are shown in the following table. Sample Same 1 TS 15.00 4496 16 1 445 4457 37 45.02 10 45.00 20 16 41 4501 30 21 22 45 GB 38 30 10 15.12 40 10 500 11 45.07 25 450 35 20 45.01 449 Me 2 3 4 5 7 2 41 3 9 WEB BN TE 41 40 14 Questions Consider the following questions, and then write a brief report to Michelle summarizing your findings. Be sure to include your calculations for supporting your findings. To guide your report and expectations see the Case Study rubric in the syllabus or in the course information area. Submit your report in your week 8 drop-box labeled Final Exam Tiger Tools Case Study 1. How did Jim conclude that the process was not capable based on his first set of samples? (Hint: Estimate the process standard deviation, a, using 2. Does the second set of samples show anything that the first set didn't? Explain what and why 3. Assuming the problem can be found and corrected, what impact do you think this would have on the capability of the process? Compute the potential process capability using the second data set. 4.If small samples can reveal something that large samples might not why not just take small samples in every situation