Question: PLEASE show me how to do this in excel Bottle Sample 1 2 3 4 1 12.14 12.01 11.95 11.96 2 12.09 11.92 11.85 12.04

PLEASE show me how to do this in excel

Bottle Sample 1 2 3 4 1 12.14 12.01 11.95 11.96 2 12.09 11.92 11.85 12.04 3 11.99 12.07 11.85 11.90 4 12.11 11.99 11.92 11.85 5 12.11 11.98 12.04 12.08 6 11.92 11.87 12.13 12.07 7 11.89 12.11 11.86 11.89 8 11.96 11.89 11.89 12.12 9 11.88 12.08 12.13 12.15 10 12.08 11.97 12.09 11.94 11 12.10 12.12 12.09 12.06 12 12.07 11.96 11.98 12.06 13 12.06 11.86 12.12 11.90 14 12.07 11.97 12.03 11.86 15 11.96 12.09 11.92 11.88

PLEASE show me how to do this in excel Bottle

The production manager at Sunny Soda, Inc., is interested in tracking the quality of the company's 12-ounce bottle filling line. The bottles must be filled within the tolerances set for this product because the dietary information on the label shows 12 ounces as the serving size. The design standard for the product calls for a fill level of 12 +0.10 ounces. The manager collected the accompanying sample data (in fluid Ounces per bottle) on the production process. Click the icon to view the sample data. Click the icon to view the table of factors for calculating three-sigma limits for the x-chart and R-chart. Design an R-and an x-chart for this process. The UCLR equals ounces and the LCLR equals ounces. (Enter your responses rounded to three decimal places.) The UCL; equals ounces and the LCL equals ounces. (Enter your responses rounded to three decimal places.) a. Are the process average and range in statistical control? The process average is statistical control and the process range is statistical control, b. Is the process capable of meeting the design standard at four-sigma quality? Explain. The Cpk is equal to so the process capable. (Enter your response rounded to three decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!