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
21
22
23
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
0.00
0.200
0.400
1.00
1.200
1 2 3 4 5 6 7 8 9 10 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