Control Charts from your updated data. 6. Discuss how the two sets of Control Controls are different. What has changed? Problem 1: Calculate X-Bar-Bar, R-Bar, and associated control limits using the data in the table above and create X-BarR (Average & Range) Control Charts. Solution: 1 . Using the template provided, click on the “Data and calculation” tab. In the upper left corner enter “30” for the number of samples and enter “4” for the sample size. 2. Enter the data into the yellow data area. Note: You will have to rotate your data to fit this table.
When you are done you should have 30 observations (30 columns ), each with four results. 3. The template does all the calculations and plotting. The calculations are grouped into two parts, one for Averages (top group) and one for Ranges (bottom group). The X-Bar-Bar number we want in the top set of results titled “Center. ” X-Bar-Bar = 5. 057. The “Center” result the bottom set of data is R-Bar. R-Bar = 1. 069. 3. Click on the “x-bar chart” tab to view the X-Bar Chart and you should see a chart that looks like the one below. (It’s called a X-Bar chart because you plot averages or X- bar’s on it.
We can see one point, point #22, is below the Lower Control Limit (LLC). 4. Click on the “R-chart” tab to view the R-Chart and you should see a chart that looks like the one below. No points outside the Control Limits can be seen. 5. We now have enough information to answer Questions 1, 2, & 3 in the case study. Problem 2: If the conditions you note could be defined as assignable conditions and they are removed from the process, what will happen to the X-BarR Control Chart? Calculate new X-Bar-Bar, R-Bar, and associated control limits, and create a new X-BarR (Average & Range) control Solution: chants .
Click on the “Data and calculations” tab. Point #22 was noted as being out-of- control. Highlight the data results (4 numbers) under #22 and press delete on your keyboard. 2. Highlight all the data for points 23 though 30. Right click and select copy and paste the data into the top blank cell under #22. 3. Delete the four data points under #30 by highlighting them and pressing delete on your keyboard. You new data table should look like the following. 4. In the upper left corner change number of samples from “30” to “29. ” If you forget to do this the Control Limit calculations will not be correct.
Do not change the sample size. 6. Your new Meaner and Control Limits have been recalculated and are: 7.. Click on the “x-bar chart” tab to view the X-Bar Chart and you should see a chart that looks like the one below. No points outside the Control Limits can be seen. 8. Click on the “R-chart” tab to view the R-Chart and you should see a chart that looks 9. We have a enough information to complete steps 4 a & b. Problem 3: How are two sets of Control Charts different. What has changed? 1 . First, the most obvious observation we can make is that when we remove Point #22 he new Control Chart does not have any out-of-control points. . With the removal of Point #22 we can see the new X-Bar-Bar has increased, while the new R-Bar has decreased. 3. We can also see the Control Limits on the new X-Bar and R Charts have changed as well. The Control Limits for the X-Bar Chart have come tighter, which should not surprise us, since we removed the point that was outside the Lower Control Limit. No changes occurred to the Control Limits of the Range Chart. 4. We have now have enough information to produce the Word document to complete the project.