SPC与CPK模拟数据自动生成表

规格数据统计直方图一、主要函数：1、NORMINV(概率,中间值，标准偏差)，概率是0到100%，用rand()函数代替，也是0到1，而且是均匀分布。2、ROUND(数据,位数):位数是小数后的位数，其余四舍五入。二、设置参数1、数据量：数据的个数，通常是30,50或125。2、变更数据：输入任意值，自动变更另一组数据。3、直方图柱数：以5~10为宜4、阈值：控制CPK值的常数,可调整；CPK1.33时初始值设8.9CPK1.67时初始值设9.7规格公称值26.50数据量125规格中心26.500数据个数125最大值26.643上公差0.20变更数据2规格上限26.700最大值26.643最小值26.402下公差-0.20直方图柱数8规格下限26.300最小值26.402区间0.241阈值8.40平均值26.497直方图柱数9标准偏差0.048标准偏差0.048直方图组距0.030公差0.400LSL26.300USL26.700分组数据直方图正态分布图R0.195126.401115.42%Xbar26.497226.439333.27%MAX26.616326.4620644.52%MIN26.421426.4921834.85%Sigma0.048526.5227724.28%CA(0.016)626.5528420.87%CP1.401726.5816163.80%直方图CPK1.378826.61142.70%序号数据926.6417.45%126.5001026.6710.87%226.584326.454426.455526.547626.558726.580826.503926.5251026.4451126.4481226.5181326.4261426.4571526.4741626.4321726.4981826.5361926.5412026.4962126.4532226.4352326.5602426.4282526.4832626.5262726.5232826.4782926.4213026.4563126.4683226.4833326.4703426.5133526.6163626.4273726.5123826.5203926.4654026.5324126.4744226.5754326.5144426.5704526.4714626.5284726.4504826.5274926.5035026.4805126.5195226.4965326.5145426.4855526.5115626.5715726.5535826.5695926.5516026.4586126.4876226.5526326.4886426.5036526.4156626.4876726.5006826.5436926.4497026.4547126.5257226.5077326.5367426.5397526.5427626.5347726.4927826.4957926.4918026.4028126.4198226.5288326.4478426.4368526.4978626.5168726.4988826.5498926.5259026.4839126.5609226.6439326.5159426.4529526.5729626.5369726.5779826.5639926.55810026.44910126.56310226.55110326.52710426.47810526.55610626.53710726.48710826.46510926.52511026.51511126.45911226.50911326.44311426.53411526.45711626.42011726.50511826.51211926.50912026.43812126.53412226.48812326.53812426.57512526.429变更数据2AverageandRangeControlChart(Xbar-R解析用管制图)Subgroupsize=5产品品名规格上限USL26.7管制图UCLXBar26.569UCLR0.225制造单位核定产品料号公称值26.5X-Bar26.507R-Bar0.107模号/线别审核计量单位规格下限LSL26.3LCLXBar26.446LCLR0.000抽样方式随机抽样制作Date4/24/34/54/64/74/84/94/104/114/124/134/164/174/184/194/204/304/54/64/74/84/94/104/114/12Daten12345678910111213141516171819202122232425nX126.50026.55826.44826.43226.45326.52626.46826.42726.47426.52826.51926.57126.48726.48726.52526.53426.41926.51626.56026.53626.56326.53726.45926.42026.534X1X226.58426.58026.51826.49826.43526.52326.48326.51226.57526.45026.49626.55326.55226.50026.50726.49226.52826.49826.64326.57726.55126.48726.50926.50526.488X2X326.45426.50326.42626.53626.56026.47826.47026.52026.51426.52726.51426.56926.48826.54326.53626.49526.44726.54926.51526.56326.52726.46526.44326.51226.538X3X426.45526.52526.45726.54126.42826.42126.51326.46526.57026.50326.48526.55126.50326.44926.53926.49126.43626.52526.45226.55826.47826.52526.53426.50926.575X4X526.54726.44526.47426.49626.48326.45626.61626.53226.47126.48026.51126.45826.41526.45426.54226.40226.49726.48326.57226.44926.55626.51526.45726.43826.429X5X-Bar26.49826.54226.46226.50226.46926.48726.48426.48126.53326.50226.50426.56126.50826.49526.52726.50326.45826.52226.54326.55926.53026.50426.48626.48726.534X-BarRange0.1300.1350.0920.1090.1320.1050.1480.1050.1040.0780.0340.1130.1370.0940.0350.1320.1090.0660.1910.1280.0850.0720.0910.0920.146RangeUCLXBar26.569X-Bar26.507LCLXBar26.446准则异常提示UCLR0.225RBar0.107准则异常提示FQ3B00671B判读准则准则1:至少一点超出管制界限.原因追查及其对策:制程能力指数制程性能指数Rule1:Onepointmorethan3sigmasfromcenterline准则2:连续9点出现在中心线的同一侧.σ=0.05σ=0.05Rule2:Ninepointsinarowonsamesideofcenterline准则3:连续6点递增或递减.Ca=0.04Pa=0.04Rule3:Sixpointsinarow,allincreasingordecreasing准则4:连续14点中相邻点上下交替.Cp=1.46Pp=1.42Rule4:Fourteenpointsinarow,alternatingupordown准则5:连续3点中有2点落在中心线同一侧的2/3区域外.Cpu=1.40Ppu=1.37Rule5:Twooutthreepointsmorethan2sigmasfromcenterline(sameside)准则6:连续5点中有4点落在中心线同一侧的1/3区域外.Cpl=1.51Ppl=1.47Rule6:Fouroutfivepointsmorethan1sigmasfromcenterline(sameside)准则7:连续15点在1/3区域内中心在线下.Cpk=1.40Ppk=1.37Rule7:Fifteenpointsinarowwithin1sigmasofcenterline(eitherside)准则8:连续8点落在中心线两侧,且无一点在1/3区域内.Rule8:Eigthpointsinarowmorethan1sigmasfromcenterline(eitherside)UCLXBar26.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.56926.569UCLXBar2*Sigma26.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.54826.5482*Sigma1*Sigma26.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.52826.5281*SigmaX-Bar26.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.50726.507X-Bar-1*Sigma26.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.48726.487-1*Sigma-2*Sigma26.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.46626.466-2*SigmaLCLXBar26.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.44626.446LCLXBarX-Bar图自动判读:X-Bar26.49826.54226.46226.50226.46926.48726.48426.48126.53326.50226.50426.56126.50826.49526.52726.50326.45826.52226.54326.55926.53026.50426.48626.48726.534X-Bar准则1OKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则1准则2N/AN/AN/AN/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则2准则3N/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则3准则4N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOK准则4准则5N/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则5准则6N/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则6准则7N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOK准则7准则8N/AN/AN/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则8UCLR0.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.2250.225UCLR2*Sigma0.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1860.1862*Sigma1*Sigma0.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1460.1461*SigmaR-Bar0.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.1070.107R-Bar-1*Sigma0.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.0710.071-1*Sigma-2*Sigma0.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.0360.036-2*SigmaLCLR0.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000LCLRR-Bar图自动判读:R-Bar0.1300.1350.0920.1090.1320.1050.1480.1050.1040.0780.0340.1130.1370.0940.0350.1320.1090.0660.1910.1280.0850.0720.0910.0920.146R-Bar准则1OKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则1准则2N/AN/AN/AN/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则2准则3N/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOKOK准则3准则4N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AOKOKOKOKOKOKOKOKOKOKOKOK准则4nA2D4D3d2ChangetheROUNDINGformulastoadjustscalesMaxXbar26.5627.00RoundUp21.8803.26701.128MinXBar26.4626.00RoundDown31.0232.57401.693MaxR0.190.20RoundUp40.7292.28202.059MinR00RoundtoZero50.5772.11402.326FQ3B00671B12345678910111213141516171819202122232425CPK!F19CPK!F24CPK!F29CPK!F34CPK!F39CPK!F44CPK!F49CPK!F54CPK!F59CPK!F64CPK!F69CPK!F74CPK!F79CPK!F84CPK!F89CPK!F94CPK!F99CPK!F104CPK!F109CPK!F114CPK!F119CPK!F124CPK!F129CPK!F134CPK!F139