Saramit Theatrical Productions
Frequency Distribution and Histogram
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Data Minimum 21.973
Nominal specification 22 Data Maximum 22.027
Upper specification limit 22.03
Lower specification limit 21.97 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.
122.027 22.003 22.018 21.992 22.007 21.996 21.992 22.000 22.005 22.010
The lower limit should be slightly less than the data minimum.
221.992 22.007 22.014 21.991 22.012 22.009 21.995 21.997 21.989 21.996
The upper limit should be slightly larger than the data maximum.
322.007 21.996 22.009 22.002 22.005 21.999 22.000 21.992 22.006 21.993
421.985 22.001 21.996 22.012 21.999 21.985 22.000 21.995 21.973 22.007 Lower limit 21.970
221.98 21.98 0
321.98 21.99 5
Process Capability Index Calculations 4 21.99 21.99 11
521.99 22.00 25
622.00 22.01 28
722.01 22.01 21
822.01 22.02 5
Cp 1.1281 922.02 22.02 3
Cpl 1.1749 10 22.02 22.03 1
Cpu 1.0812
Average
22.0012
Standard deviation
0.0089
15
20
25
30
Histogram
521.995 22.009 21.989 22.003 22.008 22.005 22.008 22.017 22.003 21.998 Upper limit 22.030
621.990 22.021 22.018 22.004 22.004 22.002 21.998 21.994 22.015 22.009 Cell width 0.006
Saramit Theatrical Productions