1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
22
23
24
25
26
27
28
29
33
39
40
41
42
A B C D E F G H I J K L M N O P Q R S T U V W
Nickel Experiment
Process Capability Analysis – Total Sample
Frequency Distribution and Histogram
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Data Minimum 4.850
Nominal specification 5.000 Data Maximum 5.100
Upper specification limit 5.194
Lower specification limit 4.806 Enter number of cells below (10 or less)
Number of Cells 10
DATA 12345678910 11 12 13 14 15
Enter smallest and largest limits for the frequency distribution below.
14.850 4.910 4.930 4.940 4.950 4.960 4.970 4.980 4.990 5.000 5.010 5.050
The lower limit should be slightly less than the data minimum.
24.890 4.910 4.930 4.940 4.950 4.960 4.970 4.980 4.990 5.000 5.020 5.050
The upper limit should be slightly larger than the data maximum.
34.890 4.910 4.930 4.940 4.950 4.960 4.970 4.980 4.990 5.000 5.020 5.060
10 4.910 4.930 4.940 4.950 4.960 4.970 4.980 4.990 5.000 5.010 5.040 5.100
14.84 4.87 1
24.87 4.89 2
34.89 4.92 15
Process Capability Index Calculations 4 4.92 4.95 20
54.95 4.98 28
64.98 5.00 28
75.00 5.03 12
85.03 5.06 6
Average
Standard deviation
4.9717
0.0472
25
30
4.84 4.87 4.89 4.92 4.95 4.98 5.00 5.03 5.06 5.08 5.11
Cell Upper Limit
Histogram – Total Sample
16
17
18
Lower limit 4.840
Upper limit 5.110
Cell width 0.027
To (inclusive)
Nickel Experiment
Process Capability Analysis – Sorted by Age
Older Coins – 1963 – 1998
Frequency Distribution and Histogram
N = 56
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Sorted by Year Data Minimum 4.850
Mint Year
Weight
(grams)
Nominal specification 5.000 Data Maximum 5.100
P1963 5.06 Upper specification limit 5.194
P1964 4.92 Lower specification limit 4.806 Enter number of cells below (10 or less)
P1964 4.97 Number of Cells 10
P1964 5.00
P1964 5.02 DATA 12345678910 11 12 13 14 15
Enter smallest and largest limits for the frequency distribution below.
P1964 5.05 15.060 4.850 5.050 4.950 4.960 5.040
The lower limit should be slightly less than the data minimum.
D1970 4.96 24.920 4.950 5.080 5.000 4.900 5.080 The upper limit should be slightly larger than the data maximum.
P1972 5.01 34.970 5.000 5.020 4.930 4.980 5.100
P1972 5.02 45.000 5.010 5.000 4.980 4.890 4.910 Lower limit 4.84
D1974 4.93 55.020 5.010 4.990 5.030 4.970 4.970 Upper limit 5.11
P1974 4.85 65.050 5.040 5.020 5.070 4.910 4.980 Cell width 0.027
P1977 5.00
34.89 4.92 5
D1980 4.96 Process Capability Index Calculations 4 4.92 4.95 3
D1981 4.96 54.95 4.98 12
P1981 5.00
64.98 5.00 12
P1981 5.05 75.00 5.03 7
P1981 5.08 85.03 5.06 6
D1982 5.02 Cp 1.147 95.06 5.08 7
P1984 5.00
Cpl 1.078 10 5.08 5.11 1
P1985 4.99
Cpu 1.215
P1985 5.02 Cpk 1.078
D1986 4.98
D1986 5.03
P1986 5.08
D1987 4.98
P1987 4.95
D1988 5.00
D1989 4.98
P1990 5.07
P1992 5.08
P1993 4.94
P1993 4.96
D1994 4.90
P1994 4.98
D1995 4.89
D1995 4.97
P1995 4.91
P1995 4.95
D1996 4.89
D1996 4.95
P1996 4.97
P1996 5.04
P1996 5.08
D1998 5.10
P1998 4.91
P1998 4.97
P1998 4.98
Newer Coins – 1999 – 2013
N = 64
Mint Year
D1999 4.93 Nominal specification 5.000 Data Maximum 5.020
D1999 4.94 Upper specification limit 5.194
D1999 4.94 Lower specification limit 4.806 Enter number of cells below (10 or less)
D1999 4.99 Number of Cells 10
P1999 4.93 DATA 12345678910 11 12 13 14 15
Enter smallest and largest limits for the frequency distribution below.
P1999 4.98 14.930 4.910 4.940 4.990 4.940 4.940 4.930 The lower limit should be slightly less than the data minimum.
Weight
Average
4.988
Standard deviation
0.056
12
14
Cell Upper Limit
Histogram – Older Coins
14
16
18
Cell Upper Limit
Histogram – Newer Coins
D1976 5.00 85.010 4.960 5.030 4.910 4.890 From To (inclusive) Frequency
D1976 5.01 95.020 4.960 5.080 5.080 4.950 Cell -Infinity 4.84 0
P1976 5.01 10 4.930 5.000 4.980 4.940 4.970 14.84 4.87 1
P1976 5.04 24.87 4.89 2
P1999 5.01 24.940 4.940 4.950 4.910 4.950 4.940 4.950 The upper limit should be slightly larger than the data maximum.
D2000 4.91 34.940 4.940 4.950 4.910 4.960 4.970 4.980
D2000 4.91 44.990 4.950 4.960 4.930 4.980 4.970 5.000 Lower limit 4.840
D2000 4.91 54.990 4.970 4.960 5.020 4.990 4.980 Upper limit 5.110
D2001 4.90
Process Capability Index Calculations Summary – Comparison of Proc Cap Indexes 4 4.92 4.95 17
D2001 4.94 54.95 4.98 16
D2001 4.94 Older Newer 64.98 5.00 16
D2001 4.95 Cp 1.147 2.083 75.00 5.03 5
D2001 4.95 Cpl 1.078 1.621 85.03 5.06 0
D2001 4.96 Cp 2.083 Cpu 1.215 2.544 95.06 5.08 0
D2001 4.96 Cpl 1.621 Cpk 1.078 1.621 10 5.08 5.11 0
P2001 4.96
P2006 4.91
P2007 5.02
P2008 4.99
P2010 4.98
P2011 4.93
P2011 4.93
P2011 4.94
P2011 4.95
P2011 4.96
P2011 4.99
P2011 5.00
P2011 5.00
P2012 4.91
P2012 4.94
P2012 4.94
P2012 4.94
P2012 4.94
P2012 4.97
P2012 4.97
P2012 4.98
P2012 5.00
P2012 5.01
P2012 5.01
P2012 5.01
P2013 4.92
P2013 4.93
P2013 4.95
P2013 4.98
P2013 5.00
Standard deviation
0.031
Average
4.957
D2000 4.94 64.930 4.980 4.980 4.960 5.000 5.000 Cell width 0.027
P2000 4.96 24.87 4.89 0
P2000 4.96 34.89 4.92 10