起源故事 · Sheppard 的 Z 表与 Abramowitz Handbook Origin Story · Sheppard's Z Table and the Abramowitz Handbook
1809 年高斯写下钟形曲线,但当时没人能快速算出"−2σ 到 +2σ 的面积"。 1894 年英国统计学家 W.F. Sheppard 第一次把 Φ(z) 累积分布函数列成 4 位精度表,发表在《Philosophical Transactions》。 1950 年代美国国家标准局 Abramowitz & Stegun 编《Handbook of Mathematical Functions》, 其中 Φ(z) 表跨 6 位精度铺满 30 页,成为 20 世纪被引用最多的工程参考书之一。 今天 Excel 的 NORM.S.DIST(z, TRUE)、Minitab 的 PPM 报告、ASQ 黑带题库里的"Cpk=1.5 求 ppm", 全都是查这张表的两侧尾巴 Gauss wrote down the bell curve in 1809, but at the time nobody could quickly compute the area from −2σ to +2σ. In 1894 the British statistician W.F. Sheppard published the first 4-digit table of the Φ(z) cumulative function in Philosophical Transactions. In the 1950s the U.S. National Bureau of Standards' Abramowitz & Stegun edited the Handbook of Mathematical Functions, whose Φ(z) tables run 30 pages at 6-digit precision — one of the most cited engineering references of the 20th century. Today Excel's NORM.S.DIST(z, TRUE), Minitab's PPM report, and every "Cpk = 1.5, find the ppm" question on an ASQ Black Belt exam are all reading the two tails of that same table.

1 双尾面积 = 不良率 Two-Tail Area = Defect Rate

yield 99.99%+

2 Φ(z) 累积函数 · 查表过程 Φ(z) Cumulative Function · How the Table Is Read

把 Z_USL、−Z_LSL 投影到 Φ(z) 曲线,纵坐标就是面积。 上尾 = 1 − Φ(Z_USL),下尾 = Φ(−Z_LSL)。这就是查 Z 表的几何意义。 Project Z_USL and −Z_LSL onto the Φ(z) curve — the y-coordinate is the tail area. Upper tail = 1 − Φ(Z_USL), lower tail = Φ(−Z_LSL). That is the geometric meaning of "looking up the Z table".

3 现实里的 % Defective % Defective in the Real World

Minitab Capability:直接报告 PPM < LSL / PPM > USL / PPM Total,就是这两段尾巴的积分。 Minitab Capability: reports PPM < LSL / PPM > USL / PPM Total directly — those are the integrals of the two tails.
半导体多步良率:每步 Φ 单独算,再连乘 —— 100 步每步 99.99% = 总良率 99.0%,复利效应惊人。 Multi-step semiconductor yield: compute Φ per step, then multiply — 100 steps at 99.99% each = 99.0% overall. The compounding effect bites hard.
ASQ 黑带必考:"Cpk=1.5 求 ppm",答 3.4 ppm(含 1.5σ 漂移)或 6.8 ppm(不含),都靠查 Φ 表。 ASQ Black Belt classic: "Cpk = 1.5, find the ppm." Answer 3.4 ppm (with the 1.5σ shift) or 6.8 ppm (without). Both come straight from the Φ table.
Excel 一键算:=NORM.S.DIST(z, TRUE) 就是 Φ(z),不用查表了。 One-cell Excel: =NORM.S.DIST(z, TRUE) is Φ(z) — no more flipping through paper tables.
一句话In One Line
% Defective 是把 工程语言 σ 翻译成客户语言 ppm/良率的最后一公里。 经典换算表(双侧居中、无 1.5σ 漂移): Cpk 1.00 → 2700 ppm(99.73%)· Cpk 1.33 → 63 ppm(99.9937%)· Cpk 1.67 → 0.6 ppm · Cpk 2.00 → 0.002 ppm。 这串数字,就是和销售经理、品质总监开会时真正能听懂的语言 % Defective is the last mile that translates σ as engineers speak it into ppm and yield as customers hear it. The classic two-sided lookup (centered process, no 1.5σ shift): Cpk 1.00 → 2,700 ppm (99.73%) · Cpk 1.33 → 63 ppm (99.9937%) · Cpk 1.67 → 0.6 ppm · Cpk 2.00 → 0.002 ppm. That short string of numbers is the only language that actually lands in a meeting with sales and the head of quality.
常见误用Common Mistakes
单侧规格也用双侧公式(比如表面粗糙度只有 USL)。单边规格只算一边尾巴,否则 ppm 会算大一倍。 Using the two-sided formula on a one-sided spec (e.g. surface roughness with USL only). A one-sided spec gets one tail only; otherwise you double-count the ppm.
非正态分布直接套 Φ 公式偏态/双峰分布要先做 Box-Cox / Johnson 变换,或改用 Percentile 法(见 PC21)。 Slapping the Φ formula onto a non-normal distribution. Skewed or bimodal data needs a Box-Cox or Johnson transform first, or switch to the percentile method (see PC21).
ppm 直接乘良率算成品率良率 = 1 − ppm / 1,000,000,别乘错。多步串联时是良率连乘,不是 ppm 相加。 Multiplying ppm by yield to get the rolled throughput. Yield = 1 − ppm / 1,000,000 — don't mix the two. Multi-step lines compound yields, they don't sum ppm.

% Defective = Φ(−Z_LSL) + (1 − Φ(Z_USL))