1
2
3
4
5
6
7
8
9
10
11
12
13
40
A B C D E F G H I J K L M N O P Q R S T U V W
Process Capability Analysis
Frequency Distribution and Histogram
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Data Minimum 10.500
Nominal specification 10.7 Data Maximum 10.900
Upper specification limit 10.9
Lower specification limit 10.5 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.
110.650 10.800 10.500 10.800 10.700 10.800 10.750 10.650 10.850 10.650 10.800 10.650
The lower limit should be slightly less than the data minimum.
210.750 10.850 10.800 10.800 10.700 10.700 10.850 10.700 10.800 10.550 10.700 10.850
The upper limit should be slightly larger than the data maximum.
310.750 10.700 10.650 10.800 10.650 10.650 10.750 10.650 10.500 10.800 10.750 10.800
14
15
16
24
26
27
31
Lower limit 10.450
Upper limit 10.950
Cell width 0.050
To (inclusive)
Process Capability Index Calculations 4 10.60 10.65 25