please answer questions and please include excel worksheet

Tiger Tools Case Tiger Tools, a dinsion of Deille Industries, was about to unch new prodext. Production Manager Michelle Yerkasted her assist Jim Pelenon, to check the capability of the oven ved in the process in obtained 18 random samples of 20 pieces each. The rest of those samples are shown in the following the After he malyzed the debe concluded that the process was not capable based on specification with or 1.44 cm Michelle quite appointed when she heard the She had hoped that with the introduction of the product he orice could run close to roll capacity and master. The company and a free on capital expense of more than 10.000 placement on would con times that amount. Im worked with the oven to see if perhaps different in could predare the desired results, but they were unable to every meaningful improve 31 1 2 09 101 120 A5 AS.00 4104 44.58 ST M 4 3 10 TE 12 15 14 11 10 17 ST 15.00 SI T Still not ready to concede, Michelle contacted one of her former professors and explained the problem The profesor und obtaining andere af samplesthis time using a mater sample sire and more samples, Michelle then conferred with Jim and they agreed that he would take 27 samples of the observations each. The results are shown in the following table Sale 0 150 30 41 4 2 3 4 $ 41 37 30 11 10 147 7 1 197 IS 40 15.04 4102 45.00 4512 507 45.62 4501 20 21 22 21 84 25 30 41 40 44 12 88 40 41 3 41 16 41.90 100 45.00 450 19 11 12 13 27 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 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, 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? Tiger Tools Case Tiger Tools, a dinsion of Deille Industries, was about to unch new prodext. Production Manager Michelle Yerkasted her assist Jim Pelenon, to check the capability of the oven ved in the process in obtained 18 random samples of 20 pieces each. The rest of those samples are shown in the following the After he malyzed the debe concluded that the process was not capable based on specification with or 1.44 cm Michelle quite appointed when she heard the She had hoped that with the introduction of the product he orice could run close to roll capacity and master. The company and a free on capital expense of more than 10.000 placement on would con times that amount. Im worked with the oven to see if perhaps different in could predare the desired results, but they were unable to every meaningful improve 31 1 2 09 101 120 A5 AS.00 4104 44.58 ST M 4 3 10 TE 12 15 14 11 10 17 ST 15.00 SI T Still not ready to concede, Michelle contacted one of her former professors and explained the problem The profesor und obtaining andere af samplesthis time using a mater sample sire and more samples, Michelle then conferred with Jim and they agreed that he would take 27 samples of the observations each. The results are shown in the following table Sale 0 150 30 41 4 2 3 4 $ 41 37 30 11 10 147 7 1 197 IS 40 15.04 4102 45.00 4512 507 45.62 4501 20 21 22 21 84 25 30 41 40 44 12 88 40 41 3 41 16 41.90 100 45.00 450 19 11 12 13 27 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 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, 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