Question: table [ [ Number , Product 1 , Product 2 , Product 3 , Product 4 , Product 5 , Product 6 , Product

\table[[Number,Product1,Product2,Product3,Product4,Product5,Product6,Product7,Mean,Range],[1,105.94,104.60,102.41,98.91,102.29,97.55,106.14,102.55,8.59],[2,88.56,99.06,87.28,100.77,99.16,93.39,87.08,93.61,13.68],[3,100.39,100.21,90.28,107.75,105.06,92.99,98.25,99.28,17.47],[4,95.60,93.15,96.32,89.47,92.34,96.96,113.32,96.74,23.85],[5,112.28,103.29,97.76,103.45,106.58,105.30,72.82,100.21,39.45],[6,113.82,103.56,107.82,107.98,111.93,99.50,102.26,106.70,14.32],[7,105.98,111.99,103.99,96.32,87.87,97.34,92.06,99.36,24.12],[8,107.04,103.59,105.44,95.06,95.40,102.07,105.98,102.08,11.98],[9,92.92,101.02,91.82,98.86,107.51,110.39,100.39,100.41,18.57],[10,91.94,103.23,109.51,103.01,93.90,118.77,91.17,101.65,27.60],[11,106.70,94.75,118.19,96.48,98.78,106.22,100.02,103.02,23.44],[12,95.93,109.80,109.69,101.12,101.37,102.22,105.88,103.72,13.88],[13,91.20,107.05,98.58,88.18,111.11,101.50,97.72,99.33,22.93],[14,104.52,87.55,111.88,93.42,111.28,107.99,104.67,103.04,24.33],[15,102.90,101.68,96.27,99.09,100.91,99.18,92.73,98.97,10.16],[x-bar-bar =100.71117 and R-bar =19.62451,,,,,,,,,]]
A new week just started and you were given a new task to manage the quality function that monitors the thickness of one of the company's major products.
As you are about to call Sam to collect data, you get an email from the HR department saying Sam quit. He said he was overworked. However, HR has found you another engineer, Edith Clarke, whos been working on operations projects all over the world. Shell be a perfect fit for your task.
2/4
Edith finds some historical data which was collected when the process was in control. In that dataset (Dataset 4), there were 15 samples and in each sample 7 products were measured in the unit of millimeter (mm). In this case n =__________ and N =__________.
Go to Tab "P4" and click "Show me the data". The collected data is shown in this table. The first column is the sample number while the next few columns show the product thickness of the measured products in each sample. Edith has also calculated sample means and sample ranges which are shown in the last two columns (Mean and Range), as well as x-bar-bar and R-bar values, which are shown below the table.
Edith knows the next step is to determine the "constants" in the table and comes up with: A2=0.22, D3=0.35, and D4=1.65. You need to verify whether these values are correct. Are all three constants chosen correctly? (Yes or No)___________
If the values are correct, please proceed to the next step. If the values are not correct, please write down the correct values here: ________________________________
Use the x-bar-bar and R-bar values computed by Edith, and appropriate "constants" to calculate the center line and control limits (rounding to 3 decimal places) for x-bar chart and R chart.
x-bar chart: CL =____________, UCL =_____________, and LCL =_____________; R chart: CL =____________, UCL =_____________, and LCL =____________
 \table[[Number,Product1,Product2,Product3,Product4,Product5,Product6,Product7,Mean,Range],[1,105.94,104.60,102.41,98.91,102.29,97.55,106.14,102.55,8.59],[2,88.56,99.06,87.28,100.77,99.16,93.39,87.08,93.61,13.68],[3,100.39,100.21,90.28,107.75,105.06,92.99,98.25,99.28,17.47],[4,95.60,93.15,96.32,89.47,92.34,96.96,113.32,96.74,23.85],[5,112.28,103.29,97.76,103.45,106.58,105.30,72.82,100.21,39.45],[6,113.82,103.56,107.82,107.98,111.93,99.50,102.26,106.70,14.32],[7,105.98,111.99,103.99,96.32,87.87,97.34,92.06,99.36,24.12],[8,107.04,103.59,105.44,95.06,95.40,102.07,105.98,102.08,11.98],[9,92.92,101.02,91.82,98.86,107.51,110.39,100.39,100.41,18.57],[10,91.94,103.23,109.51,103.01,93.90,118.77,91.17,101.65,27.60],[11,106.70,94.75,118.19,96.48,98.78,106.22,100.02,103.02,23.44],[12,95.93,109.80,109.69,101.12,101.37,102.22,105.88,103.72,13.88],[13,91.20,107.05,98.58,88.18,111.11,101.50,97.72,99.33,22.93],[14,104.52,87.55,111.88,93.42,111.28,107.99,104.67,103.04,24.33],[15,102.90,101.68,96.27,99.09,100.91,99.18,92.73,98.97,10.16],[x-bar-bar =100.71117 and R-bar =19.62451,,,,,,,,,]] A new week just started and

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!