1
2
3
4
5
6
10
11
12
13
14
15
16
17
18
19
40.03 0.02 0.03 0.07 0.07 0.07 0.02 0.05 0.03 0.07 0.06 0.04 0.00 0.04 0.02 Lower limit -0.120
To (inclusive)
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
80.160 0.200 0
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
Moby Molding Co.
Process Capability Analysis Copyright © 2013 Cengage Learning
Frequency Distribution and Histogram
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Data Minimum -0.100
Nominal specification 0Data Maximum 0.110
DATA 12345678910 11 12 13 14 15 Enter smallest and largest limits for the frequency distribution below.
10.06 -0.07 -0.01 -0.08 -0.10 -0.03 -0.04 -0.03 -0.03 -0.03 -0.05 -0.06 -0.05 -0.03 -0.04 The lower limit should be slightly less than the data minimum.
20.03 -0.01 0.05 0.02 -0.02 -0.01 0.00 0.04 -0.04 -0.08 -0.05 -0.02 -0.06 0.01 0.01 The upper limit should be slightly larger than the data maximum.
30.05 0.05 0.04 0.03 0.02 0.03 0.05 0.05 -0.02 0.04 0.05 -0.01 0.01 0.03 0.02
9 Cell -Infinity -0.120 0
10 1-0.120 -0.080 5
2-0.080 -0.040 17
3-0.040 0.000 30
Process Capability Index Calculations 4 0.000 0.040 38
50.040 0.080 26
Average 0.0093 60.080 0.120 4
Cell Upper Limit
Histogram
7
8
9
Upper specification limit 0.1