Prob. 8-18A Statistics
Mach4 Tool Co – Machining Process – Part A
Sample Number
1 2 3 4 5
0.556 0.562 0.564 0.564 0.572
0.572 0.572 0.572 0.573 0.575
Page 1
Mach4 Tool Co – Process Capability Analysis
Frequency Distribution and Histogram
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Nominal specification 0.575
Data Minimum
0.5560
Upper specification limit 0.582
Data Maximum
0.5860
Lower specification limit 0.568
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.
10.556 0.562 0.564 0.564 0.572
The lower limit should be slightly less than the data minimum.
20.572 0.572 0.572 0.573 0.575
The upper limit should be slightly larger than the data maximum.
20.5585 0.5620 1
30.5620 0.5655 2
Process Capability Index Calculations 4 0.5655 0.5690 0
0.5740 50.5690 0.5725 4
0.0067 60.5725 0.5760 7
8
0.5550 0.5585 0.5620 0.5655 0.5690 0.5725 0.5760 0.5795 0.5830 0.5865 0.5900
Cell Upper Limit
Histogram
To (inclusive)
1
2
3
4
8
9
10
11
12
13
17
18
19
20
21
22
23
30
31
32
33
A B C D E F G H I J K L M N O P Q R S T U V W X
Mach4 Tool Co – 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 0.573
Number of Cells
8
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.
10.573 0.578 0.576 0.579 0.574
The lower limit should be slightly less than the data minimum.
20.575 0.575 0.573 0.577 0.576
The upper limit should be slightly larger than the data maximum.
30.573 0.574 0.576 0.575 0.579
7
8From
To (inclusive)
Frequency
9Cell -Infinity 0.573 3
10 10.573 0.574 0
20.574 0.575 4
30.575 0.576 6
Process Capability Index Calculations 40.576 0.577 6
Cpu 1.281
Cpk 1.281
2
3
Frequency
Histogram
40.576 0.577 0.577 0.574 0.575 Lower limit 0.573
50.576 0.574 0.575 0.575 0.576 Upper limit 0.580