Montvalley Short-Haul Lines, Inc.
Initial p-chart (Base case)
Fraction Nonconforming (p) Chart
This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells.
Click on the sheet tab to display the control chart (some rescaling may be needed).
Sample Fraction Standard
Sample Value Size Nonconforming LCLp CL UCLp Deviation
110 20 0.500 0.306 0.630 0.954 0.108
2 9 20 0.450 0.306 0.630 0.954 0.108
313 20 0.650 0.306 0.630 0.954 0.108
410 20 0.500 0.306 0.630 0.954 0.108
515 20 0.750 0.306 0.630 0.954 0.108
610 20 0.500 0.306 0.630 0.954 0.108
714 20 0.700 0.306 0.630 0.954 0.108
813 20 0.650 0.306 0.630 0.954 0.108
914 20 0.700 0.306 0.630 0.954 0.108
10 14 20 0.700 0.306 0.630 0.954 0.108
11 12 20 0.600 0.306 0.630 0.954 0.108
12 13 20 0.650 0.306 0.630 0.954 0.108
13 14 20 0.700 0.306 0.630 0.954 0.108
14 13 20 0.650 0.306 0.630 0.954 0.108
15 12 20 0.600 0.306 0.630 0.954 0.108
16 12 20 0.600 0.306 0.630 0.954 0.108
17 14 20 0.700 0.306 0.630 0.954 0.108
18 16 20 0.800 0.306 0.630 0.954 0.108
19 14 20 0.700 0.306 0.630 0.954 0.108
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
1.200
12345678910 11 12 13 14 15 16 17 18 19 20
% Non – conforming
Sample number
Attribute (p) Chart p Values
Lower Control Limit
Center Line
Upper Control Limit