当前位置：文档之家 › cpk统计表格

cpk统计表格

  • 格式：pdf
  • 大小：63.27 KB
  • 文档页数：2

cpk统计表格CpK（过程能力指数）是统计质量控制中用于衡量一个过程的稳定性和一致性的指标。它通过考察过程的变异性和工程规范的关系来评估过程是否能够产生合格的产品。CpK值越高，表示过程的能力越强。下面是一个简单的CpK统计表格，以便记录和计算CpK值：```plaintext|数据样本|观测值1|观测值2|观测值3|...|观测值n|平均值|标准差|规格上限|规格下限|CpK值||----------|---------|---------|---------|-----|---------|--------|----------|----------|-------||1||||...|||||||2||||...|||||||3||||...|||||||...||||...|||||||n||||...||||||```解释每一列的含义：-数据样本：记录每个观测值所属的样本编号。-观测值1,观测值2,...观测值n：记录每个观测值的具体数值。-平均值：对观测值求平均的结果。-标准差：对观测值计算标准差的结果。-规格上限：产品规格的上限值。-规格下限：产品规格的下限值。-CpK值：通过计算得到的CpK值。这个表格用于记录一系列观测值，然后计算平均值、标准差和CpK值，以评估过程的能力。请根据实际情况填充表格，并使用适当的统计工具计算所需的数值。

合集下载

CPK计算表格EXCEL(1)

CPK计算表格EXCEL(1)

100.21100100.34100.25100.25公差上限 USL100.40输入上限值100.2100.26100.34100.28100.28公差下限 LSL100.00输入下限值100.2100.28100.27100.17100.17规格中心 U(USL+LSL)/2100.2100.19100.18100.32100.23100.23规格公差 TUSL-LSL0.4100.26100.21100.19100.32100.15X 平均值na100.23100.19100.22100.27100.22100.22标准差 σSTDEV0.06100.14100.27100.31100.3100.3最大值MAX100.34100.23100.27100.33100.26100.26最小值Min100.10100.19100.24100.29100.28100.16PPKU ( USL-ˉx ) / 3σ0.91100.24100.31100.34100.32100.32PPKL ( ˉx -LSL )/ 3σ1.28100.15100.21100.21100.2100.2PPKMin(CPKU ,CPKL)0.91100.2100.3100.21100.25100.25100.18100.23100.29100.32100.32Cp 离散趋势精确度(USL-LSL) / 6σ1.10100.13100.2100.18100.22100.22Ca 集中趋势精确度(X-U)/(T/2)0.17100.21100.28100.29100.32100.19Ppk Cp * ( 1 - |Ca|)0.91100.14100.17100.3100.25100.25100.15100.23100.32100.31100.31100.11100.15100.25100.22100.22100.21100.3100.31100.31100.31100.1100.15100.2100.18100.18100.18100.24100.2100.28100.28100.1100.17100.24100.19100.19100.21100.2100.27100.25100.25100.2100.2100.32100.24100.24100.2100.2100.32100.24100.24双上限规格只有上限规格数据收集区PPK自动计算表公差上限 USL100.4输入上限值公差下限 USL100输入下限值

CPK计算表格

CPK计算表格

参数名称(CTQ)1234标准值(standard)52.86.57.2+Tol(USL)0.050.050.050.05-Tol(LSL)0.050.050.050.05规格上限值(Up limit)5.052.856.557.25规格下限值(Low limit)4.952.756.457.15最小值(Min)4.972.786.487.15最大值(Max)5.022.836.517.23mean5.002.816.497.20Std0.010.010.010.01CPL1.471.971.631.33CPU1.621.402.031.32CPK1.471.401.631.32等级(Rank)BBBC14.992.816.507.2025.002.816.487.2034.992.816.517.1945.002.816.487.2055.002.816.497.2065.002.826.497.2174.992.816.507.1985.002.816.497.2095.012.806.507.21104.992.796.507.21114.992.816.497.21124.992.816.497.19135.012.826.507.18144.992.816.517.20154.972.836.507.19165.022.816.507.20175.002.826.497.20185.002.786.497.20195.002.806.507.20204.992.826.487.20214.982.806.507.15225.002.816.507.20234.992.806.507.20245.012.786.507.20255.012.816.507.19265.002.816.487.18275.022.806.497.22284.992.826.487.20294.992.816.497.20305.002.816.507.20CPK Re315.002.826.517.17325.012.806.497.21335.002.796.487.21345.012.826.487.20355.002.836.497.20364.992.816.507.18374.982.806.517.23385.012.816.497.21395.002.796.507.21404.992.816.517.20415.002.826.497.20424.992.816.507.19435.012.816.507.20444.982.816.507.21454.982.816.497.20465.002.816.517.21475.002.816.487.20485.012.826.497.21495.012.826.497.20504.992.816.507.21514.992.816.517.22524.992.816.497.22535.022.816.507.20545.002.806.487.20554.982.806.507.18564.992.806.507.20574.992.806.497.21585.012.816.497.21595.012.816.487.21605.002.816.507.19560.551.40.020.10.020.10.571.50.531.30.541.380.551.470.551.410.000.021.171.941.641.541.171.54CB0.551.390.551.410.541.410.541.400.551.400.541.400.551.380.541.420.551.400.541.410.551.410.551.450.551.460.541.410.551.400.551.410.551.400.551.440.541.450.541.410.541.390.551.400.551.410.551.450.541.400.541.400.551.420.551.400.551.470.551.41CPK Report0.541.410.551.410.541.410.551.400.551.430.541.390.551.410.541.420.551.430.551.460.551.380.541.420.541.410.551.440.551.400.551.410.551.400.551.400.551.400.541.400.541.390.551.420.551.410.551.410.551.410.551.400.541.410.551.400.551.410.551.40

excel表格怎样用函数计算cpk值

excel表格怎样用函数计算cpk值

excel表格怎样用函数计算cpk值

有时候我们需要对产品的相关特性数据进行分析，利用数据统计工具制作过程能力控制图，从而计算出CPK值，下面店铺给大家分享excel表格函数算出cpk值的方法，欢迎大家来到店铺学习。

excel表格函数算出cpk值的方法

收集你所需要控制的特性的数据，并且输入到Excel当中，注意是要按列输入：

excel表格用函数计算cpk值的方法图1

打开Minitab软件，将Excel中的数据复制粘贴到Minitab中的表格中

excel表格用函数计算cpk值的方法图2

然后 统计--质量工具--能力分析--正态

excel表格用函数计算cpk值的方法图3

然后就会弹出一个对话框。点击第一个空格，然后双击左边列出的C1 152.324，这样你就把这组数据放到了第一个空格当中---这就是选择数据的过程。然后子组大小输入5

excel表格用函数计算cpk值的方法图4

然后输入你这个特性所要求的规格上限和规格下限

excel表格用函数计算cpk值的方法图5

先别忙着点击确定，点击 右上角有个 选项 按钮，会弹出另一个对话框，这个是设置图表参数的，目标 就是你的特性的中心值，下面的6是默认的，代表利用6Sigma来运行图表，你也可以改成5或4试试

excel表格用函数计算cpk值的方法图6

好啦，依次点击确定，这样就得到了CPK图，所有的控制指标一目了然。CPK PPM 标准差 CPM，扥等

excel表格用函数计算cpk值的方法图7

Excel如何快速格式化报表

为了制作出美观的报表，需要对报表进行格式化。有快捷方法，即自动套用Excel预设的表格样式。方法是：选定操作区域，选取“格式”菜单中的 “自动套用格式”命令，在格式列表框中选取一款你满意的格式样式，按“确定”按钮即可。要注意的是，格式列表框下面有包括“数字”、“边框线”、“字体” 等6个“应用格式种类”选项，若某项前面的“x”不出现，则在套用表格样式时就不会用该项。

副本CPK计算模板-表格

副本CPK计算模板-表格

100.21100100.34100.25100.25公差上限 USL100.40

100.2100.26100.34100.28100.28公差下限 LSL100.00

100.2100.28100.27100.17100.17规格中心 U(USL+LSL)/2

100.19100.18100.32100.23100.23规格公差 TUSL-LSL

100.26100.21100.19100.32100.15X 平均值na

100.19100.22100.27100.22100.22标准差 σSTDEV

100.14100.27100.31100.3100.3最大值MAX

100.23100.27100.33100.26100.26最小值Min

100.19100.24100.29100.28100.16CPKU ( USL-ˉx ) / 3σ

100.24100.31100.34100.32100.32CPKL ( ˉx -LSL )/ 3σ

100.15100.21100.21100.2100.2CPKMin(CPKU ,CPKL)

100.2100.3100.21100.25100.25

100.18100.23100.29100.32100.32Cp 离散趋势精确度(USL-LSL) / 6σ

100.13100.2100.18100.22100.22Ca 集中趋势精确度(X-U)/(T/2)

100.21100.28100.29100.32100.19Cpk Cp * ( 1 - |Ca|)

100.14100.17100.3100.25100.25

100.15100.23100.32100.31100.31

100.11100.15100.25100.22100.22

100.21100.3100.31100.31100.31

100.1100.15100.2100.18100.18

100.18100.24100.2100.28100.28