SPCCalculator(xls 6).xls

Enter your data here if you are using samples of data collected over timeEnter your data here if you are using individual data points collected over time This template should be used for data collected in sample sizes of 3 to 5 items Enter each observation in the X column For sample sizes less than n 5 fill in the left most columns n 1 2 etc first Do not enter zero for blanks Do not enter zero for blanks Note there is no connection between the two sides of this worksheet Sample Sample Sample n 1n 2n 3n 4n 5Xbar Avg Range 181 000073 000085 000090 000080 000081 800017 0000 282 000087 000088 000078 000084 000083 800010 0000 380 000083 000076 000084 000082 000081 00008 0000 474 000081 000091 000075 000083 000080 800017 0000 575 000086 000082 000084 000075 000080 400011 0000 681 000086 000083 000088 000081 000083 80007 0000 783 000082 000076 000077 000078 000079 20007 0000 886 000083 000082 000079 000085 000083 00007 0000 988 000079 000086 000084 000085 000084 40009 0000 1082 000084 000089 000084 000080 000083 80009 0000 1186 000084 000081 000081 000087 000083 80006 0000 1286 000083 000078 000080 000083 000082 00008 0000 1388 000079 000083 000083 000082 000083 00009 0000 1472 000086 000080 000079 000087 000080 800015 0000 1584 000085 000081 000088 000081 000083 80007 0000 1676 000082 000083 000084 000079 000080 80008 0000 1774 000086 000083 000089 000083 000083 000015 0000 1885 000085 000082 000077 000077 000081 20008 0000 1982 000084 000083 000092 000084 000085 000010 0000 2089 000080 000090 000083 000077 000083 800013 0000 21 22 23 24 25 The data shown above are from Chapter 9 MBPF Example 9 3 see also Examples 9 6 a value of exactly one indicates that the normal process variation of plus minus 3 standard deviations is barely meeting the specifications zone and a value of greater than one indicates that the process variation is smaller than the range of the specification limits i e this is good and the larger the CP or CPK the better Thus CPK tells yo