1
2
3
4
5
10
11
12
13
14
15
16
22
23
24
25
26
A B C D E F G H I J K L M N O P Q R S T U V W X
Problem 8-07
Coyote University Frequency Distribution and Histogram
This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells.
Data Minimum 69.100
DATA 12345678910 11 12 13 14 15 Enter smallest and largest limits for the frequency distribution below.
171.930 73.140 70.370 71.460 74.340 69.720 72.090 71.130 71.970 73.370 73.930 71.950 71.350 71.520 70.690
The lower limit should be slightly less than the data minimum.
270.980 74.160 69.720 73.160 70.150 71.340 72.530 71.230 73.050 71.720 73.340 72.150 73.200 71.550 72.330
The upper limit should be slightly larger than the data maximum.
372.370 73.020 71.990 72.620 73.680 71.290 74.390 69.960 72.410 73.030 72.920 72.320 73.230 70.990 69.100
473.910 73.260 72.520 72.420 73.060 71.280 71.280 73.470 72.870 70.290 71.170 73.380 70.530 72.020 69.220 Lower limit 69.500
570.890 73.710 71.140 72.700 72.420 74.510 71.240 70.470 72.000 72.240 72.780 71.920 73.820 71.510 70.910 Upper limit 75.000
270.05 70.60 8
370.60 71.15 18
Process Capability Index Calculations 4 71.15 71.70 22
571.70 72.25 25
672.25 72.80 25
Average
72.071
30
Histogram