SPC八大控制圖自動生成表

1、通往初始面板X-RX-R、X-SX-S、中中位位數數圖圖數數據據登登入入表表規范標準值上限值 USL117.500請將數據登入在白色方格內，若顯紅色則超上差，顯藍色則超下差。生成X-R圖中心限 CL115.000下限值 LSL112.500子子組組編編號號12345678910111213樣樣品品編編號號實實際際測測量量值值1115.45116.45115.78115.36115.23114.56113.89114.56115.22115.85114.95115.28114.282115.27115.89115.26116.89114.62113.96114.26114.58115.34115

2、.86113.98115.26115.263115.89116.24115.24116.26114.28113.52114.31114.59115.36115.82114.06114.26115.074113.26114.95115.28114.28115.26115.98114.62113.75114.98115.84114.85114.86113.005115.04115.24116.85116.89116.27115.88115.26115.06115.04115.64114.26114.58115.34生成控制圖數據清零生成X-S圖生成中位數圖清除輸入數據141516171819202

3、122232425114.29115.21115.37115.48115.63115.26115.89115.01115.24115.24113.85115.31114.68115.04116.03115.75116.85116.24116.48116.96115.34116.35113.65116.24114.86115.04115.24115.99116.89116.27116.24116.89114.26115.24114.52114.61114.00115.00116.00116.05116.24115.26115.97115.34116.35115.24114.85116.89113

4、.98112.96115.26116.48115.06115.04116.03114.98114.26115.07114.86116.35X-RX-R、X-SX-S、中中位位數數圖圖數數據據登登入入表表通往初始面板單單值值和和移移動動全全距距X-MRX-MR圖圖數數據據登登入入表表規規范范標標準準值值生成控制圖上上限限值值 USLUSL200請將數據登入在白色方格內，若顯紅色則超上差，顯藍色則超下差。生成X-MR圖(批次在50以內)中中心心限限 CLCL150下下限限值值 LSLLSL100批批次次號號123456789101112樣樣本本測測量量值值112.00151.00312.00321

5、.00123.0012.0012.00321.00123.00155.00131.00412.00批批次次號號262728293031323334353637樣樣本本測測量量值值112.00151.00312.00321.00112.00151.00312.00321.00123.0012.00412.00132.00批批次次號號515253545556575859606162樣樣本本測測量量值值112.00151.00312.00321.00123.0012.00144.00412.00132.00111.00121.00114.00批批次次號號76777879808182838485868

6、7樣樣本本測測量量值值112.00151.00312.00321.00123.0012.00112.00151.00312.00321.00123.0012.00數據清零生成X-MR圖(批次大于50)清除輸入數據13141516171819202122232425121.00144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.0038394041424344454647484950111.00121.00114.00161.00166.00162.00112.00151.00312.00321.00123.

7、0012.0012.0063646566676869707172737475161.00166.00162.00162.00123.00123.00112.00151.00312.00321.00123.0012.0021.00888990919293949596979899100121.00144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00單單值值和和移移動動全全距距X-MRX-MR圖圖數數據據登登入入表表生成控制圖通往初始面板P P圖圖、U U圖圖數數據據登登入入表表生成控制圖生成P圖(子組數在5

8、0以內)請將數據登入在白色方格內生成P圖(子組數大于50)子子組組編編號號1234567891011子子組組容容量量50607080901009010231232不不良良品品數數量量/ /缺缺陷陷數數量量12325111224子子組組編編號號2627282930313233343536子子組組容容量量4354244354522634421211不不良良品品數數量量/ /缺缺陷陷數數量量34124212412子子組組編編號號5152535455565758596061子子組組容容量量3546676589766552623626不不良良品品數數量量/ /缺缺陷陷數數量量32233217131子子組

9、組編編號號7677787980818283848586子子組組容容量量2423123254432352352353不不良良品品數數量量/ /缺缺陷陷數數量量33231722344生成U圖(子組數在50以內)數據清零清除輸入數據生成U圖(子組數大于50)121314151617181920212223242523435423242343234312324312324212123412141237383940414243444546474849503534541211324433544433222839531157215523226263646566676869707172737475623453

10、32245322342423432234532122334211315587888990919293949596979899100456464346434544466456463909013721323212755P P圖圖、U U圖圖數數據據登登入入表表生成控制圖通往初始面板nPnP圖圖、C C圖圖數數據據登登入入表表生成控制圖生成nP圖(子組數在50以內)固固定定子子組組容容量量150請將數據登入在白色方格內生成nP圖(子組數大于50)子子組組編編號號1234567891011不不良良品品數數量量/ /缺缺陷陷數數量量1215201222151417171720子子組組編編號號262728

11、2930313233343536不不良良品品數數量量/ /缺缺陷陷數數量量1112131421182021231511子子組組編編號號5152535455565758596061不不良良品品數數量量/ /缺缺陷陷數數量量13412132121234223子子組組編編號號7677787980818283848586不不良良品品數數量量/ /缺缺陷陷數數量量45686235636生成C圖(子組數在50以內)數據清零清除輸入數據生成C圖(子組數大于50)12131415161718192021222324251222152012221514141313121211373839404142434445

12、46474849501024415161182967121156263646566676869707172737475211112112976867238788899091929394959697989910042346235324634nPnP圖圖、C C圖圖數數據據登登入入表表生成控制圖返回X-RX-R、X-SX-S、中中位位數數圖圖數數據據運運算算表表子組內計算批次號12345678910111213X574.910578.770578.410579.680575.660573.900572.340572.540575.940579.010572.100574.240572.950X11

13、4.982115.754115.682115.936115.132114.780114.468114.508115.188115.802114.420114.848114.590X115.270115.890115.280116.260115.230114.560114.310114.580115.220115.840114.260114.860115.070R2.6301.5001.6102.6101.9902.4601.3701.3100.3800.2200.9701.0202.340S1.0120.6420.6911.1180.7601.1130.5130.4730.1720.0920.

14、4510.4400.983X266108.4066996.5966913.5367210.7866279.2065877.2065515.6765561.3066341.5067050.5565460.5065951.0965658.21總樣本合計X-RX和R的中位數圖子組容量 n5.0000R=1.513R=總組數 Count25.0000R=37.820R=總樣本數 N125.0000上限值 UCL (X)116.116上限值 UCL (X)平均值 X115.2433中心限 CL (X)115.243中心限 CL (X)最大值 Max X116.9600下限值 LCL (X)114.370

15、下限值 LCL (X)最小值 Min X112.9600上限值 UCL (R)3.198上限值 UCL (R)平均中位數 Mid X115.2572中心限 CL (R)1.513中心限 CL (R)規范上限 USL117.5000下限值 LCL (R)0.000下限值 LCL (R)中心限 CL115.0000預估不良率(PPM)272.740預估不良率(PPM)規范下限 LSL112.5000 Std.Dev.=0.875 Std.Dev.=偏度 Skewness-0.1448Sigma=0.650Sigma=峰度 Kurtosis-0.1734Pp=0.953Pp=X14405.4100P

16、pk=0.860Ppk=X21660221.5349Ca=9.73%Ca=Cp=1.281Cp=CPU=1.157CPU=運算符號=CPL=1.406CPL=Cpk=1.157Cpk=Grade=CGrade=平方矩陣批次號12345678910111213 樣品測量值的平方113328.7013560.6013405.0113307.9313277.9513123.9912970.9313123.9913275.6513421.2213213.5013289.4813059.92213287.1713430.4913284.8713663.2713137.7412986.8813055.35

17、13128.5813303.3213423.5412991.4413284.8713284.87313430.4913511.7413280.2613516.3913059.9212886.7913066.7813130.8713307.9313414.2713009.6813055.3513241.10412827.8313213.5013289.4813059.9213284.8713451.3613137.7412939.0613220.4013418.9113190.5213192.8212769.00513234.2013280.2613653.9213663.2713518.711

18、3428.1713284.8713238.8013234.2013372.6113055.3513128.5813303.32X-RMinMax柱狀圖坐標組界頻率左邊計算組界起點110.691119.7961110.3650=110.668891923187LCL/UCL (X)114.370116.1163110.9720=110.972405824018LSL/USL112.500117.5004111.2760=111.275919724857Sigma110.691119.7965111.5790=111.5794336256816111.8830=111.882947526512X-

19、R7112.1860=112.186461427343Delta0.3048112.4900=112.489975328174乘數系數37.9399112.7930=112.793489229005畫線長度標記31.90010113.0972=113.09700312983711113.4011=113.40051703066812113.7042=113.70403093149913114.0087=114.0075448323314114.31111=114.31105873316115114.6157=114.61457263399216114.9188=114.918086534824

20、17115.22217=115.22160043565518115.52529=115.52511433648619115.8295=115.82862823731720116.13214=116.13214213814821116.43611=116.4356560389822116.7393=116.73916993981123117.0438=117.04268384064224117.3460=117.34619774147325117.6500=117.64971164230426117.9530=117.95322554313527118.2570=118.256739443967

21、28118.5600=118.56025334479829118.8640=118.86376724562930119.1670=119.1672811464631119.4710=119.470795047291越界0中位數MinMax柱狀圖坐標組界頻率左邊計算組界起點110.704119.8101110.3790=110.682811923187LCL/UCL (X)114.212116.3033110.9860=110.986325824018LSL/USL112.500117.5004111.2900=111.2898397248497Sigma110.704119.8105111.5

22、930=111.5933536256816111.8970=111.896867526512中位數7112.2000=112.200381427343Delta0.3048112.5040=112.503895328174乘數系數37.9399112.8070=112.807409229005畫線長度標記30.80010113.1112=113.11092312983711113.4141=113.41443703066812113.7182=113.71795093149913114.0217=114.0214648323314114.32511=114.32497873316115114.

23、6289=114.62849263399216114.9326=114.93200653482417115.23618=115.23552043565518115.53928=115.53903433648619115.8436=115.84254823731720116.14613=116.14606213814821116.45011=116.4495760389822116.7533=116.75308993981123117.0578=117.05660384064224117.3600=117.36011774147325117.6640=117.66363164230426117.

24、9670=117.96714554313527118.2710=118.27065944396728118.5740=118.57417334479829118.8780=118.87768724562930119.1810=119.1812011464631119.4850=119.484715047291越界0X-SMinMax柱狀圖坐標組界頻率左邊計算組界起點110.456120.0311110.1140=110.432874214183LCL/UCL (X)114.326116.1613110.7520=110.752048057792LSL/USL112.500117.5004111

25、.0710=111.0712219014017Sigma110.456120.0315111.3900=111.3903957450096111.7100=111.709569588618X-S7112.0290=112.028743432227Delta0.3198112.3480=112.347917275835乘數系數39.8979112.6670=112.667091119444畫線長度標記31.90010112.9861=112.98626496305311113.3052=113.30543880666112113.6251=113.6246126502713113.9444=11

26、3.94378649387914114.26310=114.26296033748815114.58210=114.58213418109616114.90110=114.90130802470517115.22017=115.22048186831418115.54029=115.53965571192219115.8597=115.85882955553120116.17812=116.1780033991421116.49714=116.49717724274822116.8160=116.81635108635723117.1368=117.13552492996624117.4550

27、=117.45469877357425117.7740=117.77387261718326118.0930=118.09304646079227118.4120=118.41222030440128118.7310=118.73139414800929119.0510=119.05056799161830119.3700=119.36974183522731119.6890=119.688915678835越界0141516171819202122232425571.810573.250577.900579.750580.670578.070580.610579.180575.450577.

28、140571.730579.400114.362114.650115.580115.950116.134115.614116.122115.836115.090115.428114.346115.880114.290115.040115.370115.990116.240115.260116.030115.340115.240115.240114.520116.2400.8802.2500.7901.0001.8301.2300.5901.9802.0901.2801.2102.2800.3970.9480.4000.3720.7910.5920.2381.0040.8730.5210.565

29、0.90965393.9765726.7166794.3267222.5767438.0366834.3967421.8267093.9366231.5966619.2065376.3267144.18X-S1.513S=0.64337.820S=16.073116.303上限值 UCL (X)116.161115.257中心限 CL (X)115.243114.212下限值 LCL (X)114.3263.198上限值 UCL (S)1.3431.513中心限 CL (S)0.6430.000下限值 LCL (S)0.000293.160預估不良率(PPM)514.4020.875 Std.

30、Dev.=0.8750.650Sigma=0.6840.953Pp=0.9530.855Ppk=0.86010.29%Ca=9.73%1.281Cp=1.2181.149CPU=1.1001.413CPL=1.3371.149Cpk=1.100CGrade=C14151617181920212223242513062.2013273.3413310.2413335.6313370.3013284.8713430.4913227.3013280.2613280.2612961.8213296.4013151.5013234.2013462.9613398.0613653.9213511.7413

31、567.5913679.6413303.3213537.3212916.3213511.7413192.8213234.2013280.2613453.6813663.2713518.7113511.7413663.2713055.3513280.2613114.8313135.4512996.0013225.0013456.0013467.6013511.7413284.8713449.0413303.3213537.3213280.2613190.5213663.2712991.4412759.9613284.8713567.5913238.8013234.2013462.9613220.

32、4013055.3513241.1013192.8213537.32右邊正態線坐標 XNormal標記線坐標n*SigmaLengthX-RX-R、X-SX-S、中中位位數數圖圖數數據據運運算算表表左邊1110.3650.0001111.3410.000=110.3653780223562110.4260.0002111.34122.330=110.6688919231873110.4870.0003111.3410.000=110.9724058240184110.5470.0004111.9910.000=111.275919724855110.6080.0005111.99122.330

33、=111.5794336256816110.6690.0006111.9910.000=111.8829475265127110.7300.0007112.6420.000=112.1864614273438110.7900.0008112.64222.330=112.4899753281749110.8510.0009112.6420.000=112.79348922900510110.9120.00010113.2920.000=113.09700312983711110.9720.00011113.29222.330=113.40051703066812111.0330.00012113

34、.2920.000=113.70403093149913111.0940.00013113.9430.000=114.0075448323314111.1550.00014113.94322.330=114.31105873316115111.2150.00015113.9430.000=114.61457263399216111.2760.00016114.5930.000=114.91808653482417111.3370.00017114.59322.330=115.22160043565518111.3970.00018114.5930.000=115.525114336486191

35、11.4580.00019115.2430.000=115.82862823731720111.5190.00020115.24335.090X=116.13214213814821111.5790.00021115.2430.000=116.4356560389822111.6400.00022115.8940.000=116.73916993981123111.7010.00023115.89422.330=117.04268384064224111.7620.00024115.8940.000=117.34619774147325111.8220.00025116.5440.000=11

36、7.64971164230426111.8830.00026116.54422.330=117.95322554313527111.9440.00027116.5440.000=118.25673944396728112.0040.00028117.1940.000=118.56025334479829112.0650.00029117.19422.330=118.86376724562930112.1260.00030117.1940.000=119.1672811464631112.1860.00031117.8450.00032112.2470.00132117.84522.330331

37、12.3080.00133117.8450.00034112.3690.00134118.4950.00035112.4290.00235118.49522.33036112.4900.00336118.4950.00037112.5510.00437119.1460.00038112.6110.00638119.14622.33039112.6720.00939119.1460.00040112.7330.01440117.5000.00041112.7930.01941117.50031.900USL42112.8540.02742117.5000.00043112.9150.038431

38、12.5000.00044112.9760.05344112.50031.900LSL45113.0360.07445112.5000.00046113.0970.10047113.1580.13648113.2180.18349113.2790.24350113.3400.32151113.4010.42052113.4610.54553113.5220.70154113.5830.89455113.6431.12956113.7041.41457113.7651.75658113.8252.16259113.8862.63860113.9473.19261114.0083.82862114

39、.0684.55063114.1295.36364114.1906.26565114.2507.25666114.3118.33167114.3729.482=110.668891923187=110.972405824018=111.27591972485=111.579433625681=111.882947526512=112.186461427343=112.489975328174=112.793489229005=113.097003129837=113.400517030668=113.704030931499=114.00754483233=114.311058733161=1

40、14.614572633992=114.918086534824=115.221600435655=115.525114336486=115.828628237317=116.132142138148=116.43565603898=116.739169939811=117.042683840642=117.346197741473=117.649711642304=117.953225543135=118.256739443967=118.560253344798=118.863767245629=119.16728114646=119.47079504729168114.43210.699

41、69114.49311.96770114.55413.26971114.61514.58572114.67515.89373114.73617.16874114.79718.38475114.85719.51676114.91820.53777114.97921.42578115.03922.15779115.10022.71580115.16123.08681115.22223.25982115.28223.23083115.34323.00084115.40422.57485115.46421.96586115.52521.18687115.58620.25888115.64719.202

42、89115.70718.04490115.76816.80891115.82915.52292115.88914.20993115.95012.89594116.01111.60095116.07110.34596116.1329.14697116.1938.01698116.2546.96499116.3145.998100116.3755.121101116.4364.335102116.4963.637103116.5573.025104116.6182.495105116.6782.039106116.7391.652107116.8001.327108116.8611.0571091

43、16.9210.834110116.9820.653111117.0430.507112117.1030.390113117.1640.297114117.2250.225115117.2850.168116117.3460.125117117.4070.092118117.4680.067119117.5280.049120117.5890.035121117.6500.025122117.7100.017123117.7710.012124117.8320.008125117.8930.006126117.9530.004127118.0140.003128118.0750.0021291

44、18.1350.001130118.1960.001131118.2570.001132118.3170.000133118.3780.000134118.4390.000135118.5000.000136118.5600.000137118.6210.000138118.6820.000139118.7420.000140118.8030.000141118.8640.000142118.9240.000143118.9850.000144119.0460.000145119.1070.000146119.1670.000147119.2280.000148119.2890.0001491

45、19.3490.000150119.4100.000151119.4710.000右邊正態線坐標 XNormal標記線坐標n*SigmaLength1110.3790.0001111.3550.000=110.3792980223562110.4400.0002111.35521.560=110.6828119231873110.5010.0003111.3550.000=110.9863258240184110.5610.0004112.0050.000=111.2898397248495110.6220.0005112.00521.560=111.5933536256816110.6830

46、.0006112.0050.000=111.8968675265127110.7440.0007112.6560.000=112.2003814273438110.8040.0008112.65621.560=112.5038953281749110.8650.0009112.6560.000=112.80740922900510110.9260.00010113.3060.000=113.11092312983711110.9860.00011113.30621.560=113.41443703066812111.0470.00012113.3060.000=113.717950931499

47、13111.1080.00013113.9560.000=114.0214648323314111.1680.00014113.95621.560=114.32497873316115111.2290.00015113.9560.000=114.62849263399216111.2900.00016114.6070.000=114.93200653482417111.3510.00017114.60721.560=115.23552043565518111.4110.00018114.6070.000=115.53903433648619111.4720.00019115.2570.000=

48、115.84254823731720111.5330.00020115.25733.880X=116.14606213814821111.5930.00021115.2570.000=116.4495760389822111.6540.00022115.9080.000=116.75308993981123111.7150.00023115.90821.560=117.05660384064224111.7750.00024115.9080.000=117.36011774147325111.8360.00025116.5580.000=117.66363164230426111.8970.0

49、0026116.55821.560=117.96714554313527111.9580.00027116.5580.000=118.27065944396728112.0180.00028117.2080.000=118.57417334479829112.0790.00029117.20821.560=118.87768724562930112.1400.00030117.2080.000=119.1812011464631112.2000.00031117.8590.00032112.2610.00132117.85921.56033112.3220.00133117.8590.0003

50、4112.3820.00134118.5090.00035112.4430.00235118.50921.56036112.5040.00336118.5090.00037112.5650.00437119.1600.00038112.6250.00638119.16021.56039112.6860.00939119.1600.00040112.7470.01440117.5000.00041112.8070.01941117.50030.800USL42112.8680.02742117.5000.00043112.9290.03843112.5000.00044112.9900.0534

51、4112.50030.800LSL45113.0500.07445112.5000.00046113.1110.10047113.1720.136左邊=110.682811923187=110.986325824018=111.289839724849=111.593353625681=111.896867526512=112.200381427343=112.503895328174=112.807409229005=113.110923129837=113.414437030668=113.717950931499=114.02146483233=114.324978733161=114.

52、628492633992=114.932006534824=115.235520435655=115.539034336486=115.842548237317=116.146062138148=116.44957603898=116.753089939811=117.056603840642=117.360117741473=117.663631642304=117.967145543135=118.270659443967=118.574173344798=118.877687245629=119119.48471504729148113.2320.1834911

53、3.2930.24350113.3540.32151113.4140.42052113.4750.54553113.5360.70154113.5970.89455113.6571.12956113.7181.41457113.7791.75658113.8392.16259113.9002.63860113.9613.19261114.0213.82862114.0824.55063114.1435.36364114.2046.26565114.2647.25666114.3258.33167114.3869.48268114.44610.69969114.50711.96770114.56

54、813.26971114.62814.58572114.68915.89373114.75017.16874114.81118.38475114.87119.51676114.93220.53777114.99321.42578115.05322.15779115.11422.71580115.17523.08681115.23623.25982115.29623.23083115.35723.00084115.41822.57485115.47821.96586115.53921.18687115.60020.25888115.66019.20289115.72118.04490115.78

55、216.80891115.84315.52292115.90314.20993115.96412.89594116.02511.60095116.08510.34596116.1469.14697116.2078.01698116.2676.96499116.3285.998100116.3895.121101116.4504.335102116.5103.637103116.5713.025104116.6322.495105116.6922.039106116.7531.652107116.8141.327108116.8741.057109116.9350.834110116.9960.

56、653111117.0570.507112117.1170.390113117.1780.297114117.2390.225115117.2990.168116117.3600.125117117.4210.092118117.4820.067119117.5420.049120117.6030.035121117.6640.025122117.7240.017123117.7850.012124117.8460.008125117.9060.006126117.9670.004127118.0280.003128118.0890.002129118.1490.001130118.2100.

57、001131118.2710.001132118.3310.000133118.3920.000134118.4530.000135118.5130.000136118.5740.000137118.6350.000138118.6960.000139118.7560.000140118.8170.000141118.8780.000142118.9380.000143118.9990.000144119.0600.000145119.1200.000146119.1810.000147119.2420.000148119.3030.000149119.3630.000150119.4240.

58、000151119.4850.000右邊正態線坐標 XNormal標記線坐標n*SigmaLength1110.1140.0001111.1400.000=110.1137003705752110.1780.0002111.14022.330=110.4328742141833110.2410.0003111.1400.000=110.7520480577924110.3050.0004111.8240.000=111.0712219014015110.3690.0005111.82422.330=111.3903957450096110.4330.0006111.8240.000=111.7

59、095695886187110.4970.0007112.5080.000=112.0287434322278110.5610.0008112.50822.330=112.3479172758359110.6240.0009112.5080.000=112.66709111944410110.6880.00010113.1910.000=112.98626496305311110.7520.00011113.19122.330=113.30543880666112110.8160.00012113.1910.000=113.6246126502713110.8800.00013113.8750

60、.000=113.94378649387914110.9440.00014113.87522.330=114.26296033748815111.0070.00015113.8750.000=114.58213418109616111.0710.00016114.5590.000=114.90130802470517111.1350.00017114.55922.330=115.22048186831418111.1990.00018114.5590.000=115.53965571192219111.2630.00019115.2430.000=115.85882955553120111.3