Spreadsheet: 87783d1287638703-determining-nominal-and-tolerance-values-dimensions
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Range | Frequency
 | 0.1589642931329053 | 10 |  | 0.1293241388564017 | Min |  |  |  | 0.1293241388564017 | 1
 | 0.1586360907812011 |  |  | 0.1432591714691047 | Q1 |  |  |  | 0.133031025056912 | 5
 | 0.1456249327320733 |  |  | 0.1518224355094724 | Ave |  |  |  | 0.1367379112574223 | 3
 | 0.1445954615329796 |  |  | 0.1586988489003482 | Q3 |  |  |  | 0.1404447974579326 | 5
 | 0.1454182389990949 |  |  | 0.1997549766660981 | [NAME] |  |  |  | 0.144151683658443 | 14
 | 0.1421069228736256 |  |  |  |  |  |  |  | 0.1478585698589533 | 11
 | 0.1548210188279209 |  |  |  |  |  |  |  | 0.1515654560594636 | 9
 | 0.143400843184838 |  |  |  |  |  |  |  | 0.1552723422599739 | 18
 | 0.1500312879407937 |  |  |  |  |  |  |  | 0.1589792284604843 | 12
 | 0.1536761184679561 |  |  | Nominal | 0.1518224355094724 |  |  |  | 0.1626861146609946 | 7
 | 0.1530511749246844 |  |  |  |  |  |  |  | 0.1663930008615049 | 2
 | 0.1530649852088995 |  |  | Ideal | 0.1432591714691047 | to | 0.1586988489003482 |  | 0.1700998870620152 | 3
 | 0.1457903694027497 |  |  |  |  |  |  |  | 0.1738067732625256 | 0
 | 0.1530043562851547 |  |  | Process Range | 0.1293241388564017 |  | 0.1997549766660981 |  | 0.1775136594630359 | 1
 | 0.1417362340341614 |  |  |  |  |  |  |  | 0.1812205456635462 | 1
 | 0.1488397472466616 |  |  | Process Review | Less than | 0.1362916551627532 |  |  | 0.1849274318640565 | 0
 | 0.151784446268975 |  |  |  | Greater Than | 0.1792269127832231 |  |  | 0.1886343180645668 | 1
 | 0.1573331822337193 |  |  |  |  |  |  |  | 0.1923412042650772 | 3
 | 0.1418579794541641 |  |  |  |  |  |  |  | 0.1960480904655875 | 0
 | 0.1402021135566342 |  |  |  |  |  |  |  | 0.1997549766660981 | 3
 | 0.1524500884925362 |  |  |  |  |  |  |  |  | 0
 | 0.1590404774800371
 | 0.1592858215992858 |  |  |  |  |  |  |  | 0.1209152868987544 | 1
 | 0.1466923486091583 |  | To the right is an example, looking at the chart we can see that between 0.140 and 0.173 most of the measurements lie, infact 90%  so this is a good range of values anything outside this could be down to other factors, if I was controling this process, I would be looking at why anything was out of range,  has the process shifted? IE machine wear have the values started drifting to the left or right, did someone new measure? etc |  |  |  |  |  | 0.1246572936143731 | 1
 | 0.1501444074358672 |  |  |  |  |  |  |  | 0.1283993003299918 | 0
 | 0.1591648438676124 |  |  |  |  |  |  |  | 0.1321413070456105 | 4
 | 0.1559227312542177 |  |  |  |  |  |  |  | 0.1358833137612292 | 0
 | 0.140904724628457 |  |  |  |  |  |  |  | 0.1396253204768479 | 2
 | 0.1482483783511688 |  |  |  |  |  |  |  | 0.1433673271924666 | 12
 | 0.1550443982335352 |  |  |  |  |  |  |  | 0.1471093339080853 | 11
 | 0.1591573614612495 |  |  |  |  |  |  |  | 0.150851340623704 | 17
 | 0.1542247272372295 |  |  |  |  |  |  |  | 0.1545933473393227 | 13
 | 0.1530942268770432 |  |  |  |  |  |  |  | 0.1583353540549414 | 12 | 0.8787878787878788
 | 0.1547081727638638 |  |  |  |  |  |  |  | 0.1620773607705601 | 9
 | 0.1406323796551396 |  |  |  |  |  |  |  | 0.1658193674861788 | 6
 | 0.1545966086926347 |  |  |  |  |  |  |  | 0.1695613742017975 | 4
 | 0.1553832245441166 |  |  |  |  |  |  |  | 0.1733033809174162 | 3
 | 0.1572028103536737 |  |  |  |  |  |  |  | 0.1770453876330349 | 0
 | 0.1591395898508713 |  |  |  |  |  |  |  | 0.1807873943486536 | 1
 | 0.1587854251184574 |  |  |  |  |  |  |  | 0.1845294010642723 | 0
 | 0.154191472949875 |  |  |  |  |  |  |  | 0.188271407779891 | 2
 | 0.1578834288058611 |  |  |  |  |  |  |  | 0.1920134144955098 | 1
 | 0.1593473514904405 |  |  |  |  |  |  |  | 0.1920134144955098 | 1
 | 0.1560338838043394 |  |  |  |  |  |  |  |  | 0
 | 0.1481609482533359
 | 0.1432382566309747
 | 0.1406280369058716
 | 0.1401181849688505
 | 0.1477303511439162
 | 0.1654174749826395
 | 0.1432967618375985
 | 0.1446002217512397
 | 0.1567021677104295 |  |  |  |  |  |  |  |  |  | 0.1246572936143731
 | 0.1383350505949837 |  | This is a different way of looking at it |  |  |  |  |  | 0.1246572936143731 | 1 | 1 | 0.1283993003299918
 | 0.1477639170069873 |  |  |  |  |  |  |  | 0.1283993003299918 | 0 |  | 0.9797979797979798 | 0.1321413070456105
 | 0.1498531509854403 |  |  |  |  |  |  |  | 0.1321413070456105 | 4 |  |  | 0.9696969696969697 | 0.1358833137612292
 | 0.160052839174925 |  |  |  |  |  |  |  | 0.1358833137612292 | 0 |  |  |  | 0.9090909090909091 | 0.1396253204768479
 | 0.1542537869708353 |  |  |  |  |  |  |  | 0.1396253204768479 | 2 |  |  |  |  | 0.9090909090909091 | 0.1433673271924666
 | 0.1673167746630946 |  |  |  |  |  |  |  | 0.1433673271924666 | 12 |  |  |  |  |  | 0.7575757575757576 | 0.1471093339080853
 | 0.1673354224881231 |  |  |  |  |  |  |  | 0.1471093339080853 | 11 |  |  |  |  |  |  | 0.6161616161616161 | 0.150851340623704
 | 0.1645141885409436 |  |  |  |  |  |  |  | 0.150851340623704 | 17 |  |  |  |  |  |  |  | 0.6161616161616161 | 0.1545933473393227
 | 0.1303454589091851 |  |  |  |  |  |  |  | 0.1545933473393227 | 13 |  |  |  |  |  |  |  |  | 0.404040404040404 | 0.1583353540549414
 | 0.1367938379025429 |  |  |  |  |  |  |  | 0.1583353540549414 | 12 |  |  |  |  |  |  |  |  |  | 0.2121212121212121
 | 0.1534603789588538 |  |  |  |  |  |  |  | 0.1620773607705601 | 9
 | 0.1335883622212034 |  |  |  |  |  |  |  | 0.1658193674861788 | 6 |  |  |  |  |  |  |  |  |  | 0.1620773607705601
 | 0.1360986654382369 |  |  |  |  |  |  |  | 0.1695613742017975 | 4 |  |  |  |  |  |  |  |  | 0.1658193674861788
 | 0.1345431988048799 |  |  |  |  |  |  |  | 0.1733033809174162 | 3 |  |  |  |  |  |  |  | 0.1695613742017975
 | 0.1421827230127875 |  |  |  |  |  |  |  | 0.1770453876330349 | 0 |  |  |  |  |  |  | 0.1733033809174162
 | 0.1476080868534467 |  |  |  |  |  |  |  | 0.1807873943486536 | 1 |  |  |  |  |  | 0.1770453876330349
 | 0.1518224355094724 |  |  |  |  |  |  |  | 0.1845294010642723 | 0 |  |  |  |  | 0.1807873943486536
 | 0.1382636057962493 |  |  |  |  |  |  |  | 0.188271407779891 | 2 |  |  |  | 0.1845294010642723
 | 0.1514014644876965 |  |  |  |  |  |  |  | 0.1920134144955098 | 1 |  |  | 0.188271407779891
 | 0.130823169367782 |  |  |  |  |  |  |  | 0.1920134144955098 | 1 |  | 0.1920134144955098
 | 0.1680888221184149 |  |  |  |  |  |  |  |  |  | 0.1920134144955098
 | 0.1530406307740955
 | 0.1482027313679658
 | 0.1587616070194953
 | 0.1404771030639492
 | 0.1458590312046643
 | 0.1432800863072348
 | 0.1882998850791287
 | 0.1990697825421179
 | 0.1526545601141666
 | 0.1916149364612485
 | 0.1309899198897702
 | 0.1970547859672355
 | 0.1588673736820145
 | 0.1293241388564017
 | 0.1425210592487796
 | 0.1912326518838919
 | 0.1500253601693923
 | 0.1781238101859955
 | 0.1324007787727107
 | 0.1472872296202544
 | 0.1760208843320521
 | 0.1322871882150263
 | 0.140963425121058
 | 0.1997549766660981
 | 0.1902886954608392