SPC八大控制图自动生成表(系统)表格文件下载.xls

1、通往初始面板X-R、X-S、中中位位数数图图数数据据登登入入表表规范标准值上限值 USL200.000请将数据登入在白色方格内，若显红色则超上差，显蓝色则超下差。#生成X-R图中心限 CL150.000下限值 LSL100.000子子组组编编号号12345678910111213样样品品编编号号实实际际测测量量值值1101.00102.00103.00104.00105.00106.00107.00108.00109.00300.00111.00112.00113.002131.00132.00133.00134.00135.00136.00137.00138.00139.00140.0014

2、1.00142.00143.003161.00162.00163.00164.00165.00166.00167.00168.00169.00170.00171.0050.00173.004101.00102.00103.00104.00105.00106.00107.00108.00250.00110.00111.00112.00113.005131.00132.00133.00134.00135.00136.00137.00138.00139.00140.00141.00142.00143.006161.00162.00163.00164.00165.00166.00167.00168.0

3、0169.00170.00171.00172.00173.007161.00162.00163.00164.00165.00166.00167.00168.00169.00170.0050.00172.00173.008101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.009101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.00生成控制图数据清零生成X-S图生成中位数图清除输入数据141516

4、17181920212223242526272829114.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00144.00145.00146.00147.0040.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00174.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.0

5、0188.00189.00114.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00144.00145.00146.00147.00148.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00174.00300.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.0

6、0174.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00114.00115.0050.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00114.00115.00116.00117.00300.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00X-R、X-S、中中位位

7、数数图图数数据据登登入入表表30130.00160.00190.00130.00160.00190.00190.00130.00130.00通往初始面板单单值值和和移移动动全全距距X-MR图图数数据据登登入入表表规规范范标标准准值值生成控制图上上限限值值 USL200请将数据登入在白色方格内，若显红色则超上差，显蓝色则超下差。#生成X-MR图（批次在50以内）中中心心限限 CL150下下限限值值 LSL100批批次次号号123456789101112样样本本测测量量值值112.00151.00312.00321.00123.0012.0012.00321.00123.00155.00131.0

8、0412.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批批次次号号767778798081828384858687样样本本测测量量值值112.00151.00312.00321.00123.001

9、2.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.0012.0012.0063646566676869707172737475161.

10、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-MR图图数数据据登登入入表表生成控制图通往初始面板P图图、U图图数数据据登登入入表表生成控制图生成P图（子组数在50以内）请将数据登入在白色方格内生成P图（子组数大于50）子子组组编编号号1234567891011

11、子子组组容容量量50607080901009010231232不不良良品品数数量量/缺缺陷陷数数量量12325111224子子组组编编号号2627282930313233343536子子组组容容量量4354244354522634421211不不良良品品数数量量/缺缺陷陷数数量量34124212412子子组组编编号号5152535455565758596061子子组组容容量量3546676589766552623626不不良良品品数数量量/缺缺陷陷数数量量32233217131子子组组编编号号7677787980818283848586子子组组容容量量242312325443235235235

12、3不不良良品品数数量量/缺缺陷陷数数量量33231722344生成U图（子组数在50以内）数据清零清除输入数据生成U图（子组数大于50）1213141516171819202122232425234354232423432343123243123242121234121412373839404142434445464748495035345412113244335444332228395311572155232262636465666768697071727374756234533224532234242343223453212233421131558788899091929394959697

13、9899100456464346434544466456463909013721323212755P图图、U图图数数据据登登入入表表生成控制图通往初始面板nP图图、C图图数数据据登登入入表表生成控制图生成nP图（子组数在50以内）固固定定子子组组容容量量150请将数据登入在白色方格内生成nP图（子组数大于50）子子组组编编号号1234567891011不不良良品品数数量量/缺缺陷陷数数量量1215201222151417171720子子组组编编号号2627282930313233343536不不良良品品数数量量/缺缺陷陷数数量量1112131421182021231511子子组组编编号号515

14、2535455565758596061不不良良品品数数量量/缺缺陷陷数数量量13412132121234223子子组组编编号号7677787980818283848586不不良良品品数数量量/缺缺陷陷数数量量45686235636生成C图（子组数在50以内）数据清零清除输入数据生成C图（子组数大于50）1213141516171819202122232425122215201222151414131312121137383940414243444546474849501024415161182967121156263646566676869707172737475211112112976867

15、238788899091929394959697989910042346235324634nP图图、C图图数数据据登登入入表表生成控制图返回X-R、X-S、中中位位数数图图数数据据运运算算表表子组内计算批次号12345678910111213X1149.0001158.0001167.0001176.0001185.0001194.0001203.0001212.0001362.0001420.0001118.0001126.0001257.000X127.667128.667129.667130.667131.667132.667133.667134.667151.333157.778124

16、.222125.111139.667X131.000132.000133.000134.000135.000136.000137.000138.000139.000140.000111.000112.000143.000R60.00060.00060.00060.00060.00060.00060.00060.000141.000190.000121.000122.00060.000S27.83927.83927.83927.83927.83927.83927.83927.83945.21159.32537.32937.57827.839X2152889.00155196.00157521.00159864.00162225.00164604.00167001.00169416.00222468.00252200.00150028.00152172.00181761.00总样本合计X-RX和R的中位数图子组容量 n9.0000R=84.167R=总组数 Count30.0000R=2525.000R=总样本数 N270.0000上限值 UCL（X）171.349上限值 UCL（X）平均值