1
2
3
4
5
6
7
8
11
12
13
14
15
16
17
18
24
25
26
27
28
34
35
36
37
38
39
40
41
42
43
A B C D E F G H I J K L M N O P Q R S T U V W
Problem 8-6 Instructor Reserve
EngineBlader, Inc.
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 4.638
Nominal specification 4.7 Data Maximum 4.727
Number of Cells 10
DATA 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Enter smallest and largest limits for the frequency distribution below.
14.713 4.717 4.690 4.670 4.675 4.701
The lower limit should be slightly less than the data minimum.
24.703 4.679 4.678 4.674 4.690 4.699
The upper limit should be slightly larger than the data maximum.
34.701 4.679 4.651 4.722 4.715 4.652
44.712 4.690 4.693 4.668 4.681 4.704 Lower limit 4.630
54.698 4.686 4.699 4.638 4.651 4.720 Upper limit 4.740
24.64 4.65 4
34.65 4.66 4
Process Capability Index Calculations 4 4.66 4.67 6
54.67 4.69 11
64.69 4.70 16
Cpk 1.401
Average
4.6866
0
2
4
6
8
18
4.63 4.64 4.65 4.66 4.67 4.69 4.70 4.71 4.72 4.73
Frequency
Cell Upper Limit
Histogram