The piston rings of an automobile engine are produced by a casting process. You want to establish the statistical control for the inside diameter of the rings manufactured using the mean and range graphs. For this, 25 samples are taken, each one of size 5, when the process is considered to be under control. The table on the slide shows the inside diameter measurement data for each of the samples. Consider that the customer-defined specifications for the inner diameter of the rings are LEL = 73.95 mm and LSE = 74.04 mm. With the support of the Excel package,

1.Create and interpret the histogram of said data. What is concluded from this and considering the specified tolerance?
2.Perform the process capacity analysis, what is concluded regarding the process capacity to meet the specifications?
3.In the short term, what is the estimated percentage of out of spec drives?
4.Considering the analysis you carried out, offer the most reasonable recommendation to the person in charge of the manufacturing process of these piston rings.