Sheet1SampleX1X2X3X4X5X6X712011920922218918121321917921220420

Sheet1

Sample	X1	X2	X3	X4	X5	X6	X7
1	20.1	19	20.9	22.2	18.9	18.1	21.3
2	19	17.9	21.2	20.4	20	22.3	21.5
3	22.6	21.4	21.4	22.1	19.2	20.6	18.7
4	18.1	20.8	17.8	19.6	19.8	21.7	20
5	22.6	19.1	21.4	21.8	18.4	18	19.5
6	19.1	19	22.3	21.5	17.8	19.2	19.4
7	17.1	19.4	18.6	20.9	21.8	21	19.8
8	20.2	22.4	22	19.6	19.6	20	18.5
9	21.9	24.1	23.1	22.8	25.6	24.2	25.2
10	25.1	24.3	26	23.1	25.8	27	26.5
11	25.8	29.2	28.5	29.1	27.8	29	28
12	28.2	27.5	29.3	30.7	27.6	28	27
13	28.2	28.6	28.1	26	30	28.5	28.3
14	22.1	21.4	23.3	20.5	19.8	20.5	19
15	18.5	19.2	18	20.1	22	20.2	19.5
16	21.4	20.3	22	19.2	18	17.9	19.5
17	18.4	16.5	18.1	19.2	17.5	20.9	19.6
18	20.1	19.8	22.3	22.5	21.8	22.7	23
19	20	17.5	21	18.2	19.5	17.2	18.1
20	22.3	18.2	21.5	19	19.4	20.5	20
21	20.1	19	20.9	22.2	18.9	18.1	21.3
22	19	17.9	21.2	20.4	20	22.3	21.5
23	22.6	21.4	21.4	22.1	19.2	20.6	18.7
24	18.1	20.8	17.8	19.6	19.8	21.7	20
25	22.6	19.1	21.4	21.8	18.4	18	19.5
26	19.1	19	22.3	21.5	17.8	19.2	19.4
27	17.1	19.4	18.6	20.9	21.8	21	19.8
28	20.2	22.4	22	19.6	19.6	20	18.5
29	21.9	24.1	23.1	22.8	25.6	24.2	25.2
30	25.1	24.3	26	23.1	25.8	27	26.5
31	25.8	29.2	28.5	29.1	27.8	29	28
32	28.2	27.5	29.3	30.7	27.6	28	27
33	28.2	28.6	28.1	26	30	28.5	28.3
34	22.1	21.4	23.3	20.5	19.8	20.5	19
35	18.5	19.2	18	20.1	22	20.2	19.5
36	21.4	20.3	22	19.2	18	17.9	19.5
37	18.4	16.5	18.1	19.2	17.5	20.9	19.6
38	20.1	19.8	22.3	22.5	21.8	22.7	23
39	20	17.5	21	18.2	19.5	17.2	18.1
40	22.3	18.2	21.5	19	19.4	20.5	20
41	25.1	24.3	26	23.1	25.8	27	26.5
42	25.8	29.2	28.5	29.1	27.8	29	28
43	28.2	27.5	29.3	30.7	27.6	28	27
44	28.2	28.6	28.1	26	30	28.5	28.3
45	22.1	21.4	23.3	20.5	19.8	20.5	19
46	18.5	19.2	18	20.1	22	20.2	19.5
47	21.4	20.3	22	19.2	18	17.9	19.5
48	18.4	16.5	18.1	19.2	17.5	20.9	19.6

Methods of Quality Improvement

Use Excel

The data set shows 48 samples (for 48 hours) of size n=7 collected to test the production process of a filling machine for soft drink bottling. The target filling is 20 fluid ounces.

Task:

Select a random sample of 24 hours of data. [Feel free to do it manually, if you cannot use the sample selection procedure in the software. ] Using the sample data, accomplish the following:

Part 1

1. Construct an x-bar chart. Need to use graph paper.

2. Calculate and plot the centerline and upper and lower control limits for the charts.

3. Calculate and plot the A, B and C zone boundaries of the x-bar chart.

4. Plot the 24 sample means on the x-bar chart.

5. Based on x-bar findings, is the process under statistical control? Explain and justify your answer.

Part 2

6. Construct an R-chart. Need to use graph paper.

7. Calculate and plot the centerline and upper and lower control limits for the charts.

8. Calculate and plot the A, B and C zone boundaries of the R-chart.

9. Plot the sample ranges on the R-chart.

10. Analyze the pattern of the R-chart.

11. Based on R-chart findings, is the process under statistical control? Explain and justify your answer.

Part 3

12. Theoretically, what is the difference between x-bar chart and R-chart? Explain briefly.

13. How are they used? That is, what is their purpose? Explain briefly.

Part 4

14. Compare the findings from your x-bar chart and R-chart.

15. Explain why rational sub-groupings are used in constructing control charts?

16. What are the major findings from the study? Explain briefly.

17. What are your conclusions from the study? Explain briefly.

Report:

Write a report, following the steps given above. Also, include the Excel printouts.

blog9

Sheet1

Get help from top-rated tutors in any subject.