03870-spc 应用表格-U Chart.xls

u-chartu-chart average sample size, n (n varies no more than 25%) =number of samples (k) = calculate u for each sample: c/n. calculate u-bar for all samplesu-bar = the standard deviationsu =#div/0! three times the standard deviation 3 x su =#div/0! the upper control limituclucl = =#div/0! the lower control limitlcllcl = =#div/0! 1 2 3 4 5 6 paste u calculations for each sampleplaceplace manuallymanually calculatedcalculated limitslimits herehere sampleu 1p-chart 2lclcenter lineucl 30.0250.030.035 4 5 6or,or, useuse controlcontrol limitslimits calculatedcalculated onon previousprevious worksheetworksheet herehere 7 8p-chart 9lclcenter lineucl 10#div/0!0#div/0! 11 12 13limitslimits usedused 14p-chart 15lclcenter lineucl 16#div/0!0#div/0! 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 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 use these limits manually input use limits from worksheet template placeplace manuallymanually calculatedcalculated limitslimits herehere or,or, useuse controlcontrol limitslimits calculatedcalculated onon previousprevious worksheetworksheet herehere plot samples (exactly 25 samples appear at one time): from:1 to:25 u u- -c ch ha ar rt t 12345678910 1112 131415 1617 1819202122 2324 25 0 0.2 0.4 0.6 0.8 1 s sa ammp pl le e u u- -c ch ha ar rt t 123456789