Control limit calculator

Give it subgroups or individual readings and it returns the control limits for the chart, the range or sigma chart beneath it, and every constant it used to get there.

How you calculate control limits in Excel

AVERAGE over the subgroup means gives X̄̄, and AVERAGE over the per-subgroup ranges gives R̄. After that you need A₂ for the X̄ limits and D₃ and D₄ for the R limits — all three depend on your subgroup size, and Excel has no table of them.

The shortcut everyone reaches for instead, X̄̄ ± 3 × STDEV.S, is a different calculation and usually gives wider limits. Control limits are built from within-subgroup variation on purpose; STDEV.S pools every reading, including the shift between subgroups that the limits are supposed to detect. Wider limits means fewer signals, which feels like a process behaving well.

Nothing you paste leaves this calculation. It is not stored, not logged and not sent anywhere else — the numbers are computed and returned, and that is all. Paste straight out of a spreadsheet — tab-separated columns are understood as they land.

How this is calculated

Control limits describe what the process does when nothing unusual is happening. They come from the data's own short-term variation — never from the specification, and never from the spread of the whole history.

X̄–R    UCL = x̄̄ + A₂R̄        R chart: UCL = D₄R̄,  LCL = D₃R̄
X̄–s    UCL = x̄̄ + A₃s̄        s chart: UCL = B₄s̄,  LCL = B₃s̄
I–MR   UCL = x̄ + 2.66·MR̄     MR chart: UCL = 3.267·MR̄
c      UCL = c̄ + 3√c̄         LCL = max(0, c̄ − 3√c̄)

The part most people get wrong

Control limits are not specification limits. One is what the process does, the other is what the drawing demands. A process can be perfectly in control and entirely incapable, and putting the tolerance on the chart as if it were a limit hides exactly that.

And limits should be frozen. Recomputing them from whatever is on screen — the single most common mistake in SPC dashboards — means a drifting process quietly drags its own limits along with it and never signals. Compute them once from a stable window, lock them, and judge everything after against those.

Want to see that argument settled with your own numbers? The chart generator takes a tolerance and shows you when every plotted average sits inside it while the parts themselves do not.

See the full table of constants for every subgroup size from 2 to 25, or run every run rule against your data.

What the Excel version will not do

The constants come from a printed table: A₂, D₃, D₄, d₂, c₄, B₃, B₄ — none are Excel functions. They get typed in once, and a transposed digit produces limits that are simply wrong while the chart looks completely normal.
Limits that recalculate are not limits: The whole idea is a fixed voice-of-the-process against which new readings are judged. A formula over a growing range moves the goalposts with every part you make.
Nothing marks when the baseline changed: After a tool change the limits should be re-established, and the old ones should stay visible on the earlier stretch of the chart. A spreadsheet has one set of limits, retrospectively applied to everything.

Questions people ask about this

What is the difference between control limits and specification limits?

Control limits come from the process — they describe what it does when nothing unusual is happening, and they are calculated, never chosen. Specification limits come from the drawing and describe what the customer will accept. A process can be in perfect control and entirely incapable, or capable and wildly out of control; they answer different questions and do not belong on the same axis.

How do you calculate UCL and LCL?

For an X̄-R chart, UCL = x̄̄ + A₂R̄ and LCL = x̄̄ − A₂R̄, where A₂ depends on the subgroup size. The range chart uses D₄R̄ and D₃R̄. For individuals (I-MR) the limits are x̄ ± 2.66·MR̄. This calculator shows every constant it used so you can check the arithmetic by hand.

Why is the lower limit of my range chart zero?

Because D₃ is zero for subgroups smaller than seven. The three-sigma lower bound on a range would be negative there, and a range cannot be negative, so the chart genuinely has no lower limit — it is not a rounding artefact or a missing value.

Should control limits be recalculated as new data arrives?

No. Compute them once from a window when the process was stable, then freeze them. Limits recalculated from the visible window drift along with the process, so a slow shift never signals — the chart stays calm while the process walks away.

Limits are only limits while they hold still.

Lock a baseline once and every subsequent reading is judged against it, with the constants applied for your subgroup size rather than typed in — and a re-baseline after a tool change is recorded on the chart instead of quietly rewriting history.

Start now See it on live data

More control charts tools

Control chart generator — Paste a column of numbers, or rows of subgroups, and get a real control chart: limits from the data, Nelson rules 1–4 evaluated, out-of-control points marked.
Nelson & Western Electric rules checker — Every run rule evaluated on your data, each violation named in plain English with what it usually indicates — a shift, a trend, tool wear, two machines mixed.
X̄-R chart calculator — Subgroups in, X̄ and R charts out — limits from A₂, D₃ and D₄, run rules evaluated, and the range chart shown first because it decides whether the averages chart can be trusted.
X̄-s chart calculator — For subgroups big enough that the range wastes them. Limits from A₃, B₃ and B₄, sigma recovered with the c₄ correction, and the s chart read first because it decides whether the averages chart can be trusted.
I-MR chart calculator — For processes that give you one number at a time — a batch, an oven, a destructive test. Limits from the mean moving range, run rules evaluated, and an honest note about what an individuals chart cannot see.
p, np, u and c chart calculator — Counted data rather than measured: proportion defective, number defective, defects per unit. Limits that step with the sample size instead of pretending it never changed, and an honest warning when the counts are too low for three-sigma limits to mean anything.

Everything else

Cp / Cpk calculator — Paste measurements — or type a mean and a sigma — with your tolerance, and get Cp, Cpk, Pp, Ppk, the sigma level and the expected parts per million out of spec.
Cpk confidence interval & sample size — A Cpk of 1.33 from 30 pieces has a 95% interval of roughly 0.97 to 1.69. See the uncertainty in your own number, and how many parts would settle it.
Cpk ↔ PPM ↔ sigma level converter — What PPM is a Cpk of 1.33? What Cpk does 3.4 PPM need? Both conventions shown side by side, because the 1.5 sigma shift is why two sources disagree by a factor of ten.
Control chart constants — The whole table, n = 2 to 25, with the formula each constant belongs to. The same values the charts on this site are computed from.
Levey-Jennings chart with Westgard rules — Paste your QC results with the assigned mean and SD from the package insert, and get the chart with every sigma band drawn and all six Westgard rules evaluated — each one named, and labelled random or systematic error.
Bland-Altman plot — Paired readings from two methods, plotted as difference against average — with the bias, the limits of agreement, their confidence intervals, and a test for whether the disagreement depends on the magnitude.
Pareto chart generator — Categories and counts in, ranked bars and the cumulative line out — with the vital few named, an "Other" bucket that always sorts last, and an honest warning when the distribution is flat and there is no dominant cause to attack.
Box and whisker plot generator — One column per group, boxes side by side. Quartiles, the 1.5×IQR fences, whiskers that stop at real readings and outliers drawn individually — with the quartile method stated, because that is why your plot and Excel's disagree.
Histogram and normality test — A histogram with the fitted normal curve, both standard bin rules with a reasoned recommendation, and an Anderson-Darling test that refuses to tell you your data is normal — because no test can.
Gage R&R calculator (ANOVA) — Paste a crossed study — part, operator, reading — and get the full ANOVA: repeatability and reproducibility separated, the part-by-operator interaction tested rather than assumed away, %GRR, %Tolerance and ndc against AIAG's bands.
Grubbs outlier test — The G statistic against its critical value, the p-value, and the point implicated — plus a straight answer about what to do next, which is almost never to delete the reading.
Scatter diagram and correlation — Paired readings plotted, with Pearson r, Spearman rho, r², the least-squares line and its p-value — and the two reported together, because when they disagree the disagreement is the finding.
Standard deviation calculator — The usual summary statistics, and the thing a spreadsheet will not tell you: the within-subgroup sigma a control chart uses, beside the overall sigma a textbook means. The gap between them is why Cpk and Ppk disagree.