Six piecewise-linear approximations of the standard normal CDF on 0 ≤ z ≤ 3, checked against a double-precision reference. Drag on any chart to move z.
Model shown:
Model A sits at or below zero everywhere: the normal CDF is concave for z > 0, so every chord lies under the curve.
A 1 pp error in Φ near z = 2.5 doubles the defect rate. Use these models for yield, not for ppm.
Enter specification limits and process parameters. The exact column uses the double-precision reference.
Computed in your browser on 3,001 points. Values in probability units; multiply by 100 for percentage points.
Worst case: 2.35 pp in Φ at z ≈ 1.45, so up to 4.7 pp in two-sided coverage.
Cell A2 holds z. Returns #N/A outside [−3, 3].
=IF(ABS(A2)>3,NA(),0.5+SIGN(A2)*IF(ABS(A2)<=1,0.34*ABS(A2),IF(ABS(A2)<=2,0.34+0.14*(ABS(A2)-1),0.48+0.02*(ABS(A2)-2))))