应用命令、工作表标识符和示例数据值保留原文。截图、图表和下载文件均为英文。
示例: 纸箱贴标
配送中心连续检验 40 个样本量不同的纸箱样本。每个纸箱最终仅判定一次合格或不合格。
下载纸箱贴标示例(CSV,英文列名)此示例与 Help 中使用的示例相同。每行代表一个样本:sample_id 标识样本,cartons_inspected 为样本量,nonconforming_cartons 统计未通过一项或多项检查的纸箱数。每个纸箱只计一次。
1. 创建图表工作区
在侧边栏中打开 Process control,选择 p Chart,并为分析命名。选择 New blank worksheet 和 Create analysis。
2. 导入数据
在 Worksheet 中选择 Import。选择已下载的文件或粘贴其内容。将分隔符设为 Comma,使用 Decimal dot,并选中 First row contains column names。预览导入内容,然后选择 Import into worksheet。保持各行的采集顺序。
3. 指定输入列
在 Inputs 中,通过列选择器将 sample_id 分配给 Subgroup label,将 nonconforming_cartons 分配给 Number of nonconforming units,将 cartons_inspected 分配给 Subgroup size。提供计数,应用会据此计算比例。
打开 Western Electric / AIAG rules。将全部五条可选规则保持为 On:7-point trend、6 on one side、14 alternating、2 of 3 beyond 2σ 和 4 of 5 beyond 1σ。

4. 运行分析
选择 Run analysis,然后打开 Results。
5. 解读结果
理解各数据点的含义
每个点表示一个样本中未通过检验的纸箱比例。首个样本中,100 个纸箱有 8 个不合格:8 / 100 = 0.08,即 8%。即使某个纸箱未通过多项检查,也只计一次。控制图中心值通过合并计数计算,即不合格纸箱总数除以受检纸箱总数,而非各样本百分比的不加权平均值。
将每个点与其控制限比较
合并不合格比例为 6.014%。CTN33、CTN36、CTN37、CTN39 和 CTN40 超出各自的上控制限。样本量介于 100 至 250 个纸箱之间,因此控制限也随之变化。较小样本的控制限更宽。
英文图表:40 个纸箱样本的不合格比例,每个样本均有各自的控制限。 查看原尺寸图表 (在新标签页中打开) 解读突出显示的点
突出显示的点可能超出控制限,也可能属于控制限内的某种模式。多条规则可能标记同一个样本。通过信号详情查看触发的规则,不要将各行计为独立的过程问题。
确定调查内容
检查 CTN33、CTN36、CTN37、CTN39 和 CTN40 的检验记录及过程记录,确认纸箱分类判定保持一致。此图定位异常比例,并不解释纸箱不合格的原因。
更多详情:阅读各结果部分
完整结果表采用六位有效数字,与 Help 中一致。
p 控制图汇总
每个纸箱仅计一次,判为合格或不合格。中心值为不合格纸箱总数除以受检纸箱总数,而非各样本百分比的不加权平均值。
| 统计量 / 设置 | 数值 |
|---|---|
| 子组数(k) | 40 |
| 整体比例(p̄) | 0.0601418 |
| 最小样本量 | 100 |
| 最大样本量 | 250 |
| 超限检测 | On |
| 7-point trend | On |
| 6 on one side | On |
| 14 alternating | On |
| 2 of 3 beyond 2σ | On |
| 4 of 5 beyond 1σ | On |
- 控制限和分区使用各子组的样本量或机会数。
p 图数值、控制限与分区
每行列出受检数、不合格数、比例及该样本的控制限。使用 CTN 标识定位源数据行。样本量不同,应将比例与各自的控制限比较。
| 子组 | 标识 | 不合格品数 | 样本量 | p | CL | LCL | UCL | −1σ | +1σ | −2σ | +2σ | 信号 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CTN01 | 8 | 100 | 0.08 | 0.0601418 | 0 | 0.131467 | 0.0363669 | 0.0839168 | 0.012592 | 0.107692 | 无 |
| 2 | CTN02 | 13 | 250 | 0.052 | 0.0601418 | 0.0150321 | 0.105252 | 0.0451052 | 0.0751784 | 0.0300687 | 0.090215 | 无 |
| 3 | CTN03 | 7 | 230 | 0.0304348 | 0.0601418 | 0.0131116 | 0.107172 | 0.0444651 | 0.0758186 | 0.0287884 | 0.0914953 | 无 |
| 4 | CTN04 | 13 | 190 | 0.0684211 | 0.0601418 | 0.00839737 | 0.111886 | 0.0428937 | 0.07739 | 0.0256455 | 0.0946382 | 无 |
| 5 | CTN05 | 3 | 110 | 0.0272727 | 0.0601418 | 0 | 0.128147 | 0.0374733 | 0.0828104 | 0.0148048 | 0.105479 | 无 |
| 6 | CTN06 | 14 | 210 | 0.0666667 | 0.0601418 | 0.010923 | 0.109361 | 0.0437356 | 0.0765481 | 0.0273293 | 0.0929544 | 无 |
| 7 | CTN07 | 14 | 230 | 0.0608696 | 0.0601418 | 0.0131116 | 0.107172 | 0.0444651 | 0.0758186 | 0.0287884 | 0.0914953 | 无 |
| 8 | CTN08 | 10 | 180 | 0.0555556 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 无 |
| 9 | CTN09 | 3 | 190 | 0.0157895 | 0.0601418 | 0.00839737 | 0.111886 | 0.0428937 | 0.07739 | 0.0256455 | 0.0946382 | 无 |
| 10 | CTN10 | 3 | 110 | 0.0272727 | 0.0601418 | 0 | 0.128147 | 0.0374733 | 0.0828104 | 0.0148048 | 0.105479 | 无 |
| 11 | CTN11 | 9 | 200 | 0.045 | 0.0601418 | 0.00970757 | 0.110576 | 0.0433304 | 0.0769533 | 0.026519 | 0.0937647 | 无 |
| 12 | CTN12 | 18 | 250 | 0.072 | 0.0601418 | 0.0150321 | 0.105252 | 0.0451052 | 0.0751784 | 0.0300687 | 0.090215 | 无 |
| 13 | CTN13 | 13 | 250 | 0.052 | 0.0601418 | 0.0150321 | 0.105252 | 0.0451052 | 0.0751784 | 0.0300687 | 0.090215 | 6 on one side |
| 14 | CTN14 | 9 | 180 | 0.05 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side, 6 on one side |
| 15 | CTN15 | 5 | 250 | 0.02 | 0.0601418 | 0.0150321 | 0.105252 | 0.0451052 | 0.0751784 | 0.0300687 | 0.090215 | 6 on one side, 6 on one side, 6 on one side |
| 16 | CTN16 | 9 | 180 | 0.05 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side, 6 on one side, 6 on one side, 6 on one side |
| 17 | CTN17 | 11 | 250 | 0.044 | 0.0601418 | 0.0150321 | 0.105252 | 0.0451052 | 0.0751784 | 0.0300687 | 0.090215 | 6 on one side, 6 on one side, 6 on one side, 6 on one side, 6 on one side |
| 18 | CTN18 | 8 | 180 | 0.0444444 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side, 6 on one side, 6 on one side, 6 on one side, 6 on one side |
| 19 | CTN19 | 10 | 180 | 0.0555556 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side, 6 on one side, 6 on one side, 6 on one side |
| 20 | CTN20 | 6 | 120 | 0.05 | 0.0601418 | 0 | 0.125252 | 0.0384384 | 0.0818453 | 0.0167349 | 0.103549 | 6 on one side, 6 on one side, 6 on one side |
| 21 | CTN21 | 9 | 240 | 0.0375 | 0.0601418 | 0.0141019 | 0.106182 | 0.0447952 | 0.0754885 | 0.0294485 | 0.0908352 | 6 on one side, 6 on one side |
| 22 | CTN22 | 6 | 180 | 0.0333333 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side |
| 23 | CTN23 | 10 | 160 | 0.0625 | 0.0601418 | 0.00375461 | 0.116529 | 0.0413461 | 0.0789376 | 0.0225504 | 0.0977333 | 无 |
| 24 | CTN24 | 4 | 120 | 0.0333333 | 0.0601418 | 0 | 0.125252 | 0.0384384 | 0.0818453 | 0.0167349 | 0.103549 | 6 on one side |
| 25 | CTN25 | 6 | 100 | 0.06 | 0.0601418 | 0 | 0.131467 | 0.0363669 | 0.0839168 | 0.012592 | 0.107692 | 6 on one side |
| 26 | CTN26 | 7 | 180 | 0.0388889 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side |
| 27 | CTN27 | 5 | 120 | 0.0416667 | 0.0601418 | 0 | 0.125252 | 0.0384384 | 0.0818453 | 0.0167349 | 0.103549 | 6 on one side |
| 28 | CTN28 | 6 | 180 | 0.0333333 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side |
| 29 | CTN29 | 5 | 130 | 0.0384615 | 0.0601418 | 0 | 0.122698 | 0.0392898 | 0.0809939 | 0.0184378 | 0.101846 | 6 on one side |
| 30 | CTN30 | 14 | 220 | 0.0636364 | 0.0601418 | 0.0120546 | 0.108229 | 0.0441128 | 0.0761709 | 0.0280837 | 0.0922 | 无 |
| 31 | CTN31 | 4 | 140 | 0.0285714 | 0.0601418 | 0 | 0.120422 | 0.0400483 | 0.0802353 | 0.0199549 | 0.100329 | 无 |
| 32 | CTN32 | 7 | 130 | 0.0538462 | 0.0601418 | 0 | 0.122698 | 0.0392898 | 0.0809939 | 0.0184378 | 0.101846 | 无 |
| 33 | CTN33 | 20 | 150 | 0.133333 | 0.0601418 | 0.00190536 | 0.118378 | 0.0407297 | 0.079554 | 0.0213175 | 0.0989662 | Beyond 3σ, 6 on one side, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ |
| 34 | CTN34 | 7 | 100 | 0.07 | 0.0601418 | 0 | 0.131467 | 0.0363669 | 0.0839168 | 0.012592 | 0.107692 | 6 on one side, 6 on one side |
| 35 | CTN35 | 21 | 210 | 0.1 | 0.0601418 | 0.010923 | 0.109361 | 0.0437356 | 0.0765481 | 0.0273293 | 0.0929544 | 6 on one side, 6 on one side, 6 on one side, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ |
| 36 | CTN36 | 19 | 160 | 0.11875 | 0.0601418 | 0.00375461 | 0.116529 | 0.0413461 | 0.0789376 | 0.0225504 | 0.0977333 | Beyond 3σ, 6 on one side, 6 on one side, 6 on one side, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ |
| 37 | CTN37 | 19 | 150 | 0.126667 | 0.0601418 | 0.00190536 | 0.118378 | 0.0407297 | 0.079554 | 0.0213175 | 0.0989662 | Beyond 3σ, 6 on one side, 6 on one side, 6 on one side, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ |
| 38 | CTN38 | 18 | 180 | 0.1 | 0.0601418 | 0.00697945 | 0.113304 | 0.042421 | 0.0778626 | 0.0247002 | 0.0955834 | 6 on one side, 6 on one side, 6 on one side, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ |
| 39 | CTN39 | 27 | 170 | 0.158824 | 0.0601418 | 0.00543819 | 0.114845 | 0.0419073 | 0.0783764 | 0.0236727 | 0.0966109 | Beyond 3σ, 6 on one side, 6 on one side, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ |
| 40 | CTN40 | 24 | 190 | 0.126316 | 0.0601418 | 0.00839737 | 0.111886 | 0.0428937 | 0.07739 | 0.0256455 | 0.0946382 | Beyond 3σ, 6 on one side, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ |
控制图信号详情
每行列出检验索引或标识及一条规则。Beyond limits 表示超出控制限;其他规则标记的模式可能仍在控制限以内。多条规则可能标记同一个样本。这些记录指出需要调查的检验,并非不合格纸箱的数量。
| 索引(按返回值显示) | 图表 | 规则 |
|---|---|---|
| 12 | p | 6 on one side |
| 13 | p | 6 on one side |
| 13 | p | 6 on one side |
| 14 | p | 6 on one side |
| 14 | p | 6 on one side |
| 14 | p | 6 on one side |
| 15 | p | 6 on one side |
| 15 | p | 6 on one side |
| 15 | p | 6 on one side |
| 15 | p | 6 on one side |
| 16 | p | 6 on one side |
| 16 | p | 6 on one side |
| 16 | p | 6 on one side |
| 16 | p | 6 on one side |
| 16 | p | 6 on one side |
| 17 | p | 6 on one side |
| 17 | p | 6 on one side |
| 17 | p | 6 on one side |
| 17 | p | 6 on one side |
| 17 | p | 6 on one side |
| 18 | p | 6 on one side |
| 18 | p | 6 on one side |
| 18 | p | 6 on one side |
| 18 | p | 6 on one side |
| 19 | p | 6 on one side |
| 19 | p | 6 on one side |
| 19 | p | 6 on one side |
| 20 | p | 6 on one side |
| 20 | p | 6 on one side |
| 21 | p | 6 on one side |
| 23 | p | 6 on one side |
| 24 | p | 6 on one side |
| 25 | p | 6 on one side |
| 26 | p | 6 on one side |
| 27 | p | 6 on one side |
| 28 | p | 6 on one side |
| 32 | p | 2 of 3 beyond 2σ |
| 32 | p | 4 of 5 beyond 1σ |
| 32 | p | 6 on one side |
| 32 | p | Beyond 3σ |
| 33 | p | 6 on one side |
| 33 | p | 6 on one side |
| 34 | p | 2 of 3 beyond 2σ |
| 34 | p | 2 of 3 beyond 2σ |
| 34 | p | 2 of 3 beyond 2σ |
| 34 | p | 4 of 5 beyond 1σ |
| 34 | p | 4 of 5 beyond 1σ |
| 34 | p | 4 of 5 beyond 1σ |
| 34 | p | 6 on one side |
| 34 | p | 6 on one side |
| 34 | p | 6 on one side |
| 35 | p | 2 of 3 beyond 2σ |
| 35 | p | 2 of 3 beyond 2σ |
| 35 | p | 2 of 3 beyond 2σ |
| 35 | p | 4 of 5 beyond 1σ |
| 35 | p | 4 of 5 beyond 1σ |
| 35 | p | 4 of 5 beyond 1σ |
| 35 | p | 4 of 5 beyond 1σ |
| 35 | p | 6 on one side |
| 35 | p | 6 on one side |
| 35 | p | 6 on one side |
| 35 | p | Beyond 3σ |
| 36 | p | 2 of 3 beyond 2σ |
| 36 | p | 2 of 3 beyond 2σ |
| 36 | p | 2 of 3 beyond 2σ |
| 36 | p | 4 of 5 beyond 1σ |
| 36 | p | 4 of 5 beyond 1σ |
| 36 | p | 4 of 5 beyond 1σ |
| 36 | p | 4 of 5 beyond 1σ |
| 36 | p | 6 on one side |
| 36 | p | 6 on one side |
| 36 | p | 6 on one side |
| 36 | p | Beyond 3σ |
| 37 | p | 2 of 3 beyond 2σ |
| 37 | p | 2 of 3 beyond 2σ |
| 37 | p | 2 of 3 beyond 2σ |
| 37 | p | 4 of 5 beyond 1σ |
| 37 | p | 4 of 5 beyond 1σ |
| 37 | p | 4 of 5 beyond 1σ |
| 37 | p | 6 on one side |
| 37 | p | 6 on one side |
| 37 | p | 6 on one side |
| 38 | p | 2 of 3 beyond 2σ |
| 38 | p | 2 of 3 beyond 2σ |
| 38 | p | 4 of 5 beyond 1σ |
| 38 | p | 4 of 5 beyond 1σ |
| 38 | p | 6 on one side |
| 38 | p | 6 on one side |
| 38 | p | Beyond 3σ |
| 39 | p | 2 of 3 beyond 2σ |
| 39 | p | 4 of 5 beyond 1σ |
| 39 | p | 6 on one side |
| 39 | p | Beyond 3σ |
- 接口返回的信号索引从 0 开始;图上的子组编号从 1 开始。
6. 创建报告
保留英文原始报告中的 p control chart、汇总、样本数值与控制限及信号详情。记录检验判定依据,以及对 CTN33、CTN36、CTN37、CTN39 和 CTN40 的检查。将各样本量与其比例一并保留。
在已完成的运行中选择 Add to report 。打开 Choose individual items and advanced options 以选择表格和图表,然后选择 Add to draft。隐藏的项目仍会保留在已保存的分析中。
为报告命名,并添加研究目的和您的解读。选择 Save,查看 Preview,然后使用 Export → Download HTML。以下示例包含全部已选内容,包括超出单屏显示范围的结果。