Read the scenario below. Then construct and interpret the appropriate control charts. Exercise Objective: Construct and interpret statistical process control charts. Course Learning Objective: Use a variety of current industry quality tools for measuring and monitoring quality Plastic (PVC) pipe is used for plumbing in many new homes. If the outer diameter of the pipe is too narrow or too wide, then it will not connect properly with other parts of the plumbing system. UNGPipeCo, a manufacturer of PVC pipe, uses statistical process control (SPC) to maintain the quality of their products by monitoring their process. The outer diameter of the pipe also serves as one "voice of their process". The quality specifications for the outer diameter for their 3-inch diameter DWV (drain-waste-vent) pipe are 3.00 inches +/- 0.10 inch. UNGPipeCo has requested that you, one of their process analysts, evaluate the capability of this process. In order to conduct your analysis, you have had manufacturing select six 10-foot sections of pipe every hour from the forming process and measure the outer diameters. The measurements of the samples from the past 25 hours of production have been recorded. 1) Develop the appropriate control chart(s) and examine the pipe forming process. 2) Does the pipe forming process appear to be stable during the period of time when the observations were made? Instructions " When evaluating the control, include a table that shows the longest runs observed for all six of the run tests (the same way shown in the lecture video). In the end, you must state your conclusion about the process. Submit your calculations (neat and organized) You may NOT use Excel to do the calculations (so that you learn the process and are prepare for the test). Submit a very neatly prepared page of handwritten calculations. Round all calculations to three (3) decimal places. Plot the control charts using pencil and pen and a straight edge. Make it to scale and neat. The charts must clearly show and label the control limits, the ABC zones and the centerline. The y-axis must be clearly labeled with these components, i.e. show the numeric values. The charts presented in the lecture video represent properly formatted charts. Neatness counts.Data Subgroup Pipe 1 Pipe 2 Pipe 3 Pipe 4 Pipe 5 Pipe 6 X-bar 2.94 2.97 R 3.0 2.98 2.96 2.94 2.96 2.96 2.97 2.95 2.96 2.99 2.98 2.96 2.98 2.96 2.98 3.00 2.97 2.98 3.02 2.96 3.01 2.95 3.00 2.90 2.97 2.94 2.98 2.91 6 2.95 2.94 2.93 2.97 2.97 2.98 2.957 sJ 2.98 2.99 2.94 2.97 3.00 2.95 2.972 8 3.00 12060 2.94 2.94 2.98 2.96 2.99 g 2.968 3.01 02060 2.97 2.94 2.94 2.97 2.97 10 2.967 2.96 1070 2.99 2.99 2.98 2.90 3.01 11 2.987 2.92 3.00 3.01 3.00 2.92 2.98 12 2.972 2.98 12090 2.97 3.00 3.00 3.01 2.98 13 2.990 2.90 02040 2.98 3.02 2.95 2.95 2.96 2.960 14 3.00 0.120 2.96 2.95 2.92 2.93 2.96 15 2.953 2.97 ITOSO 3.01 2.95 2.90 2.92 2.98 16 2.970 3.00 12090 2.93 2.9: 2.98 2.97 2.96 2.965 17 2.96 12070 2.97 3.0 2.98 3.02 2.91 2.980 2.96 0.110 2.92 2.96 2.97 2.98 2.98 19 2.962 2.98 17060 2.96 2.96 2.94 3.01 2.91 2.960 20 2.96 0.100 3.05 2.93 2.96 2.95 2.95 21 2.967 2.95 2.97 0.120 2.96 3.03 2.97 2.93 22 2.968 2.97 0.100 2.92 2.96 2.94 2.92 2.97 23 2.947 ITOSO 3.05 3.05 3.00 3.02 2.96 2.94 3.003 24 2.98 0.110 2.96 2.99 2.94 2.97 3.05 25 2.990 2.98 12090 3.00 2.9: 2.96 2.99 3.04 2.987 0.090 (Diameters are reported in inches)