excel work
Data and calculations
| X-bar and R-Chart | ||||||||||||||||||||||||||||||||||||||||||||||||||
| This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Enter the number of samples in cell E6 and the sample size in cell E7. Then enter your data in the grid below. | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Click on sheet tabs for a display of the control charts. Specification limits may be entered in cells N7 and N8 for process capability. | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Number of samples (<= 50) | 30 | Process Capability Calculations | Six sigma | 0.0438346374 | ||||||||||||||||||||||||||||||||||||||||||||||
| Sample size (2 - 10) | 5 | Upper specification | 25.53 | Cp | 1.3687805707 | |||||||||||||||||||||||||||||||||||||||||||||
| Lower specification | 25.47 | Cpu | 1.4058897328 | |||||||||||||||||||||||||||||||||||||||||||||||
| Grand Average | 25.4991866667 | A2 | D3 | D4 | Cpl | 1.3316714085 | ||||||||||||||||||||||||||||||||||||||||||||
| Average Range | 0.0136 | 0.577 | 0 | 2.114 | Cpk | 1.3316714085 | ||||||||||||||||||||||||||||||||||||||||||||
| DATA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 |
| 1 | 25.505 | 25.498 | 25.493 | 25.496 | 25.499 | 25.497 | 25.502 | 25.498 | 25.482 | 25.492 | 25.499 | 25.500 | 25.504 | 25.503 | 25.499 | 25.499 | 25.492 | 25.498 | 25.499 | 25.505 | 25.481 | 25.497 | 25.514 | 25.474 | 25.502 | 25.504 | 25.498 | 25.500 | 25.504 | 25.506 | ||||||||||||||||||||
| 2 | 25.498 | 25.506 | 25.500 | 25.496 | 25.498 | 25.500 | 25.500 | 25.497 | 25.485 | 25.504 | 25.495 | 25.495 | 25.500 | 25.501 | 25.503 | 25.495 | 25.498 | 25.500 | 25.501 | 25.500 | 25.498 | 25.499 | 25.505 | 25.481 | 25.496 | 25.498 | 25.497 | 25.506 | 25.510 | 25.504 | ||||||||||||||||||||
| 3 | 25.493 | 25.495 | 25.503 | 25.496 | 25.506 | 25.500 | 25.508 | 25.503 | 25.484 | 25.510 | 25.500 | 25.509 | 25.495 | 25.500 | 25.502 | 25.507 | 25.506 | 25.500 | 25.502 | 25.503 | 25.482 | 25.501 | 25.512 | 25.505 | 25.507 | 25.506 | 25.511 | 25.494 | 25.498 | 25.508 | ||||||||||||||||||||
| 4 | 25.501 | 25.509 | 25.511 | 25.505 | 25.501 | 25.489 | 25.500 | 25.502 | 25.466 | 25.500 | 25.499 | 25.502 | 25.497 | 25.500 | 25.504 | 25.499 | 25.507 | 25.495 | 25.501 | 25.499 | 25.484 | 25.497 | 25.494 | 25.499 | 25.491 | 25.503 | 25.494 | 25.497 | 25.504 | 25.499 | ||||||||||||||||||||
| 5 | 25.500 | 25.500 | 25.493 | 25.500 | 25.495 | 25.511 | 25.500 | 25.498 | 25.491 | 25.509 | 25.505 | 25.503 | 25.489 | 25.513 | 25.503 | 25.502 | 25.502 | 25.493 | 25.505 | 25.503 | 25.485 | 25.488 | 25.495 | 25.492 | 25.504 | 25.503 | 25.487 | 25.506 | 25.498 | 25.504 | ||||||||||||||||||||
| 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Average | 25.4994 | 25.5016 | 25.5 | 25.4986 | 25.4998 | 25.4994 | 25.502 | 25.4996 | 25.4816 | 25.503 | 25.4996 | 25.5018 | 25.497 | 25.5034 | 25.5022 | 25.5004 | 25.501 | 25.4972 | 25.5016 | 25.502 | 25.486 | 25.4964 | 25.504 | 25.4902 | 25.5 | 25.5028 | 25.4974 | 25.5006 | 25.5028 | 25.5042 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
| LCLx-bar | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 | 25.4913394667 |
| Center | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 | 25.4991866667 |
| UCLx-bar | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 | 25.5070338667 |
| Range | 0.012 | 0.014 | 0.018 | 0.009 | 0.011 | 0.022 | 0.008 | 0.006 | 0.025 | 0.018 | 0.01 | 0.014 | 0.015 | 0.013 | 0.005 | 0.012 | 0.015 | 0.007 | 0.006 | 0.006 | 0.017 | 0.013 | 0.02 | 0.031 | 0.016 | 0.008 | 0.024 | 0.012 | 0.012 | 0.009 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
| LCLrange | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Center | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 | 0.0136 |
| UCLrange | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 | 0.0287504 |
| DO NOT MODIFY THIS TABLE | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Control Chart Factors | ||||||||||||||||||||||||||||||||||||||||||||||||||
| n | A2 | D3 | D4 | d2 | A3 | B3 | B4 | |||||||||||||||||||||||||||||||||||||||||||
| 2 | 1.88 | 0 | 3.267 | 1.128 | 2.659 | 0 | 3.267 | |||||||||||||||||||||||||||||||||||||||||||
| 3 | 1.023 | 0 | 2.574 | 1.693 | 1.954 | 0 | 2.568 | |||||||||||||||||||||||||||||||||||||||||||
| 4 | 0.729 | 0 | 2.282 | 2.059 | 1.628 | 0 | 2.266 | |||||||||||||||||||||||||||||||||||||||||||
| 5 | 0.577 | 0 | 2.114 | 2.326 | 1.427 | 0 | 2.089 | |||||||||||||||||||||||||||||||||||||||||||
| 6 | 0.483 | 0 | 2.004 | 2.534 | 1.287 | 0.03 | 1.97 | |||||||||||||||||||||||||||||||||||||||||||
| 7 | 0.419 | 0.076 | 1.924 | 2.704 | 1.182 | 0.118 | 1.882 | |||||||||||||||||||||||||||||||||||||||||||
| 8 | 0.373 | 0.136 | 1.864 | 2.847 | 1.099 | 0.185 | 1.815 | |||||||||||||||||||||||||||||||||||||||||||
| 9 | 0.337 | 0.184 | 1.816 | 2.97 | 1.032 | 0.239 | 1.761 | |||||||||||||||||||||||||||||||||||||||||||
| 10 | 0.308 | 0.223 | 1.777 | 3.078 | 0.975 | 0.284 | 1.716 |
x-bar chart
X-bar Chart
Averages 25.499400000000001 25.501600000000003 25.5 25.4986 25.4998 25.499400000000001 25.501999999999999 25.499600000000001 25.4816 25.503 25.499599999999997 25.501799999999999 25.497000000000003 25.503400000000003 25.502200000000002 25.500399999999999 25.501000000000001 25.497200000000003 25.5016 25.502000000000002 25.485999999999997 25.496400000000001 25.504000000000001 25.490199999999998 25.500000000000004 25.502800000000001 25.497399999999999 25.500599999999999 25.502800000000001 25.504200000000001 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Lower control limit 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 25.491339466666663 Upper control limit 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 25.507033866666664 Center line 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663 25.499186666666663Sample number
Averages
R-chart
R-Chart
Ranges 1.1999999999996902E-2 1.3999999999999346E-2 1.7999999999997129E-2 8.9999999999967883E-3 1.0999999999999233E-2 2.1999999999998465E-2 7.9999999999991189E-3 6.0000000000002274E-3 2.4999999999998579E-2 1.8000000000000682E-2 9.9999999999980105E-3 1.3999999999999346E-2 1.5000000000000568E-2 1.3000000000001677E-2 4.9999999999990052E-3 1.2000000000000455E-2 1.5000000000000568E-2 6.9999999999978968E-3 5.9999999999966747E-3 5.9999999999966747E-3 1.699999999999946E-2 1.3000000000001677E-2 1.9999999999999574E-2 3.0999999999998806E-2 1.6000000000001791E-2 7.9999999999991189E-3 2.3999999999997357E-2 1.2000000000000455E-2 1.2000000000000455E-2 8.9999999999967883E-3 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Lower control limit 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Upper control limit 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 2.8750399999998084E-2 Center line 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2 1.3599999999999094E-2Sample number
Ranges