创建 u 控制图

受检单位数变化时,监控每个检验单位的缺陷数。

指南 · 过程控制(SPC) · 阅读约需 4 分钟

应用命令、工作表标识符和示例数据值保留原文。截图、图表和下载文件均为英文。

示例: 焊接缺陷

制造车间检验了 40 个焊接支架装配件样本。样本量不同,但各装配件的设计和受检焊缝长度相同。

下载焊接缺陷示例(CSV,英文列名)

此 Help 示例每行对应一个样本。sample_id 标识样本,assemblies_inspected 统计装配件数量,weld_defects 统计全部缺陷个数。一个装配件可以有多个缺陷。

1. 创建控制图工作区

在侧边栏中打开 Process control,选择 u 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,将 weld_defects 指定给 Number of nonconformities,将 assemblies_inspected 指定给 Inspection units。此处一个检验单位就是一个装配件。应用将各缺陷计数除以相应的装配件数量。

打开 Western Electric / AIAG rules。将全部五项可选规则保持为 On:7-point trend、6 on one side、14 alternating、2 of 3 beyond 2σ 和 4 of 5 beyond 1σ。

u Chart: 输入信息,包含示例的列分配和设置
英文 Inputs 界面,展示样本标签、焊接缺陷计数、受检装配件数及已启用的规则。 查看原尺寸图片 (在新标签页中打开)

4. 运行分析

选择 Run analysis,然后打开 Results。

5. 解读结果

  1. 理解每个点

    每个点为焊接缺陷数除以受检装配件数。首个样本的 10 个装配件有 4 个缺陷:4 / 10 = 0.400 个缺陷/装配件。一个装配件可以有多个缺陷,因此此缺陷率可以大于一。

  2. 将缺陷率与控制限比较

    合并缺陷率为每个装配件 0.7601 个缺陷。WLD34、WLD36、WLD37 和 WLD39 超出各自的上控制限。样本包含 10–30 个装配件,因此各点的控制限反映相应的检验数量。

    u 控制图(英文图表)
    英文图表:40 个样本中每个装配件的焊接缺陷数。控制限反映各样本的检验数量。 查看原尺寸图表 (在新标签页中打开)
  3. 解读突出显示的点

    突出显示的点可能超出控制限,也可能属于控制限内的模式。同一样本可能触发多项规则。将装配件数量与各缺陷率一并保留;样本量不同时,原始缺陷总数无法直接比较。

  4. 决定调查方向

    检查 WLD34、WLD36、WLD37 和 WLD39 的缺陷及检验记录。确认各装配件的受检焊缝长度可比。控制图定位异常缺陷率,但不能确定原因。

更多详情:阅读各结果部分

完整结果表采用六位有效数字,与 Help 中一致。

u 控制图摘要

此缺陷率为焊接缺陷数除以受检装配件数,并非除以焊缝长度。一个装配件可以有多个缺陷,因此缺陷率可超过一。应确认各装配件的检验机会可比。

u 控制图摘要 · 10 行
统计量 / 设置数值
子组数(k)40
整体单位不合格项数(ū)0.760052
最少检验单位数10
最多检验单位数30
超限检测On
7-point trendOn
6 on one sideOn
14 alternatingOn
2 of 3 beyond 2σOn
4 of 5 beyond 1σOn
  • 控制限和分区使用各子组的样本量或机会数。

u 值、控制限和分区

每行列出缺陷数、受检装配件数、每个装配件的缺陷数及该样本的控制限。使用 WLD 标签查找源检验记录。分母不同时,应比较缺陷率而非原始计数。

u 值、控制限和分区 · 40 行
子组标签缺陷数机会数uCLLCLUCL−1σ+1σ−2σ+2σ信号
1WLD014100.40.76005201.587120.4843611.035740.2086711.311436 on one side, 4 of 5 beyond 1σ
2WLD0212300.40.7600520.2825421.237560.6008820.9192220.4417121.078396 on one side, 6 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
3WLD033100.30.76005201.587120.4843611.035740.2086711.311436 on one side, 6 on one side, 6 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
4WLD0417230.739130.7600520.2146971.305410.5782670.9418370.3964821.123626 on one side, 6 on one side, 6 on one side, 6 on one side
5WLD0513260.50.7600520.2471241.272980.5890760.9310280.41811.1026 on one side, 6 on one side, 6 on one side, 6 on one side, 6 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
6WLD0612220.5454550.7600520.2024411.317660.5741810.9459220.3883111.131796 on one side, 6 on one side, 6 on one side, 6 on one side, 6 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
7WLD078130.6153850.7600520.03466251.485440.5182551.001850.2764591.243646 on one side, 6 on one side, 6 on one side, 6 on one side
8WLD089170.5294120.7600520.1257171.394390.5486070.9714970.3371621.182946 on one side, 6 on one side, 6 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
9WLD0917300.5666670.7600520.2825421.237560.6008820.9192220.4417121.078396 on one side, 6 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
10WLD1010240.4166670.7600520.226181.293920.5820950.9380090.4041371.115976 on one side, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
11WLD11171710.7600520.1257171.394390.5486070.9714970.3371621.18294无
12WLD123110.2727270.76005201.548630.4971911.022910.2343311.285774 of 5 beyond 1σ
13WLD1313180.7222220.7600520.1435891.376510.5545640.9655390.3490771.17103无
14WLD148100.80.76005201.587120.4843611.035740.2086711.31143无
15WLD158140.5714290.7600520.06104921.459050.5270510.9930530.294051.22605无
16WLD1617220.7727270.7600520.2024411.317660.5741810.9459220.3883111.13179无
17WLD177170.4117650.7600520.1257171.394390.5486070.9714970.3371621.182946 on one side
18WLD1811160.68750.7600520.1061951.413910.5420990.9780040.3241471.195966 on one side
19WLD1913220.5909090.7600520.2024411.317660.5741810.9459220.3883111.131796 on one side
20WLD2010160.6250.7600520.1061951.413910.5420990.9780040.3241471.195966 on one side
21WLD2121280.750.7600520.2657821.254320.5952950.9248080.4305391.089566 on one side
22WLD227110.6363640.76005201.548630.4971911.022910.2343311.285776 on one side
23WLD239100.90.76005201.587120.4843611.035740.2086711.31143无
24WLD2418240.750.7600520.226181.293920.5820950.9380090.4041371.11597无
25WLD2512230.5217390.7600520.2146971.305410.5782670.9418370.3964821.12362无
26WLD2617240.7083330.7600520.226181.293920.5820950.9380090.4041371.11597无
27WLD2718270.6666670.7600520.2567121.263390.5922720.9278320.4244921.09561无
28WLD2821300.70.7600520.2825421.237560.6008820.9192220.4417121.07839无
29WLD2921240.8750.7600520.226181.293920.5820950.9380090.4041371.11597无
30WLD304120.3333330.7600520.005042671.515060.5083821.011720.2567121.26339无
31WLD3111180.6111110.7600520.1435891.376510.5545640.9655390.3490771.17103无
32WLD327130.5384620.7600520.03466251.485440.5182551.001850.2764591.24364无
33WLD3310180.5555560.7600520.1435891.376510.5545640.9655390.3490771.17103无
34WLD3439241.6250.7600520.226181.293920.5820950.9380090.4041371.11597Beyond 3σ, 6 on one side, 2 of 3 beyond 2σ, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ, 4 of 5 beyond 1σ
35WLD3523201.150.7600520.1752241.344880.5651090.9549940.3701671.149946 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σ
36WLD3620111.818180.76005201.548630.4971911.022910.2343311.28577Beyond 3σ, 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σ
37WLD3731231.347830.7600520.2146971.305410.5782670.9418370.3964821.12362Beyond 3σ, 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σ
38WLD3821161.31250.7600520.1061951.413910.5420990.9780040.3241471.195966 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σ
39WLD3929181.611110.7600520.1435891.376510.5545640.9655390.3490771.17103Beyond 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σ
40WLD4035291.20690.7600520.2743791.245720.5981610.9219430.436271.083836 on one side, 2 of 3 beyond 2σ, 4 of 5 beyond 1σ

控制图信号详情

每行给出一个检验索引或标签及一条规则。超出界限表示越界;其他规则标记的模式可能仍在界限内。同一样本可能触发多项规则。这些条目用于定位需要调查的检验,并非不合格装配件的数量。

控制图信号详情 · 108 行
索引(按返回值)控制图规则
0u4 of 5 beyond 1σ
0u6 on one side
1u4 of 5 beyond 1σ
1u4 of 5 beyond 1σ
1u6 on one side
1u6 on one side
11u4 of 5 beyond 1σ
16u6 on one side
17u6 on one side
18u6 on one side
19u6 on one side
2u4 of 5 beyond 1σ
2u4 of 5 beyond 1σ
2u6 on one side
2u6 on one side
2u6 on one side
20u6 on one side
21u6 on one side
3u6 on one side
3u6 on one side
3u6 on one side
3u6 on one side
33u2 of 3 beyond 2σ
33u2 of 3 beyond 2σ
33u4 of 5 beyond 1σ
33u4 of 5 beyond 1σ
33u6 on one side
33uBeyond 3σ
34u2 of 3 beyond 2σ
34u2 of 3 beyond 2σ
34u2 of 3 beyond 2σ
34u4 of 5 beyond 1σ
34u4 of 5 beyond 1σ
34u4 of 5 beyond 1σ
34u6 on one side
34u6 on one side
35u2 of 3 beyond 2σ
35u2 of 3 beyond 2σ
35u2 of 3 beyond 2σ
35u4 of 5 beyond 1σ
35u4 of 5 beyond 1σ
35u4 of 5 beyond 1σ
35u4 of 5 beyond 1σ
35u6 on one side
35u6 on one side
35uBeyond 3σ
36u2 of 3 beyond 2σ
36u2 of 3 beyond 2σ
36u2 of 3 beyond 2σ
36u4 of 5 beyond 1σ
36u4 of 5 beyond 1σ
36u4 of 5 beyond 1σ
36u4 of 5 beyond 1σ
36u6 on one side
36u6 on one side
36uBeyond 3σ
37u2 of 3 beyond 2σ
37u2 of 3 beyond 2σ
37u2 of 3 beyond 2σ
37u4 of 5 beyond 1σ
37u4 of 5 beyond 1σ
37u4 of 5 beyond 1σ
37u6 on one side
37u6 on one side
38u2 of 3 beyond 2σ
38u2 of 3 beyond 2σ
38u4 of 5 beyond 1σ
38u4 of 5 beyond 1σ
38u6 on one side
38u6 on one side
38uBeyond 3σ
39u2 of 3 beyond 2σ
39u4 of 5 beyond 1σ
39u6 on one side
4u4 of 5 beyond 1σ
4u4 of 5 beyond 1σ
4u4 of 5 beyond 1σ
4u6 on one side
4u6 on one side
4u6 on one side
4u6 on one side
4u6 on one side
5u4 of 5 beyond 1σ
5u4 of 5 beyond 1σ
5u4 of 5 beyond 1σ
5u6 on one side
5u6 on one side
5u6 on one side
5u6 on one side
5u6 on one side
6u6 on one side
6u6 on one side
6u6 on one side
6u6 on one side
7u4 of 5 beyond 1σ
7u4 of 5 beyond 1σ
7u4 of 5 beyond 1σ
7u6 on one side
7u6 on one side
7u6 on one side
8u4 of 5 beyond 1σ
8u4 of 5 beyond 1σ
8u4 of 5 beyond 1σ
8u6 on one side
8u6 on one side
9u4 of 5 beyond 1σ
9u4 of 5 beyond 1σ
9u6 on one side
  • 返回的信号索引从 0 开始;控制图中的子组编号从 1 开始。

6. 创建报告

保留英文 u control chart、摘要、各样本缺陷率与控制限,以及信号详情。说明缺陷率表示每个装配件的缺陷数,且各装配件的受检焊缝长度可比。记录对 WLD34、WLD36、WLD37 和 WLD39 的调查。

在已完成的运行中选择 Add to report 。打开 Choose individual items and advanced options 以选择表格和图表,然后选择 Add to draft。隐藏的项目仍会保留在已保存的分析中。

为报告命名,并添加研究目的和您的解读。选择 Save,查看 Preview,然后使用 Export → Download HTML。以下示例包含全部已选内容,包括超出单屏显示范围的结果。

此报告在应用中生成,为英文原版。 此 Help 示例在应用内生成的完整输出,包括适用的表格、图表和运行说明。 报告中的数值采用应用显示的数值精度。导出的图表为静态图表。在窄屏上,请横向滚动查看较宽的图表和表格。
查看示例报告: 受检装配件数量变化时监控焊接缺陷

我们使用 Microsoft Clarity 了解访客如何使用本网站,包括会话录制和热图。 无需接受分析服务,也可使用本网站。

您的选择将在此浏览器中保存六个月。 隐私声明

当前选择: 尚未选择.