Prob. 8-17 Statistics
Problem 8-17
Mach4 Tool Co – Machining Process
Original Data
0.556 Column1 0.556 0.562 0.564 0.564 0.572
0.562 0.572 0.572 0.572 0.573 0.575
0.572 Sample Variance 0.0000
0.573 Kurtosis 1.3730
0.575 Skewness -0.9603
0.577
0.580
0.579
0.581
0.583
0.586
0.575
Page 1
Problem 8-17
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
7
8
From To (inclusive) Frequency
9
Cell -Infinity 0.5550 0
10
10.5550 0.5585 1
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
70.5760 0.5795 6
80.5795 0.5830 2
Standard deviation
Average
7
8
Histogram
Lower limit 0.5550
Upper limit 0.5900
Cell width 0.0035