Statistical software for manufacturing and process quality Detect a process change while it is still small, show whether the process meets the specification, and keep the evidence in a workbook an auditor can open.

Every feature from all five editions for 15 days, no sign-up.
Quality Control & Improvement edition from US$ 290 a year · 30-day money-back guarantee.

Microsoft Excel with the Analyse-it tab of the Quality Control edition selected: a process control report with a u chart of errors per sample with its centre line and 3-sigma limits and the statistics table beneath, the Process Control task pane open on the chart type, and the Process Control menu dropped open on the ribbon listing the variable, attribute and time-weighted charts. Handwritten notes: Runs inside Excel, and every edition includes the statistics research needs:; Quality Control adds process control charts, Pareto analysis and process capability; The u chart, its centre line and 3-sigma limits: plots and tables on a worksheet; Every option for the chart is set here, then Recalculate; The output is an Excel worksheet: share it with colleagues, auditors or regulators, archive it, open it on any PC with Excel.
Using Analyse-it we have improved several of our quality control testing steps, better controlled our decision making and are still undergoing process improvements.
Laura Smith
Production manager
The Binding Site

A quality team asks the same three questions all year. Is the process stable? Is it capable of meeting the specification? And when the answer to either is no, what changed? The first two are answered by charts and indices. The third is answered by ordinary statistics, which is where most quality toolkits stop.

Analyse-it runs all three inside Excel. The control chart, the capability study and the hypothesis test that confirms the cause are the same tool, working on the same data, producing one workbook. Nothing is exported to a second package, and nothing leaves the machine it was analysed on.

Trusted for nearly 30 years by 75,000 scientists in research, quality control and testing laboratories.

EDF Thermo Fisher Tetra Tech AstraZeneca South Florida Water Management District Bristol Myers Squibb Authentix Grünenthal

Control charts that detect a change, not decorate a report

A control chart is only as good as the rule set behind it. Too few rules and a slow drift runs for weeks before a point crosses a limit. Too many and the operators learn to dismiss the flags, which is worse than having no chart at all. The rule set is a decision to make deliberately, before the data arrives.

Analyse-it draws Shewhart variable charts — Xbar-R, Xbar-S and I-MR — and the attribute charts p, np, c and u. Detection rules come as WECO, Nelson, Montgomery or a set you define yourself. Phases mark a deliberate change such as a new lot or a re-tooling. The limits then recalculate either side of the change, rather than dragging the old process across the new one. Stratification separates lines, shifts or operators on the same chart.

Where a drift is small and sustained rather than sudden, CUSUM, EWMA and UWMA accumulate the evidence and signal earlier than any Shewhart rule will. Reading out-of-control signals covers how to tell a real shift from the false alarms any rule set produces.

Control charts and detection rules →
The Shewhart, EWMA and CUSUM example report: page one of the PDF as Analyse-it produces it. 6 pages Shewhart, EWMA and CUSUM
Copper concentration in a plating pool.
Three reports on one dataset across the IQ, OQ and production phases. Xbar-R with Montgomery rules 1, 2, 3, 5 and 8 and points coloured by operator, flagging seven signals; then EWMA with λ = 0.2 and L = 3, flagging eight; then CUSUM with h = 5 and k = 0.5, flagging eleven. Every signal falls in the IQ phase but one.
The p chart and standardised p chart example report: page one of the PDF as Analyse-it produces it. 2 pages p chart and standardised p chart
Nonconforming purchase orders.
Montgomery, page 311. 25 samples of varying size. A p chart whose limits move with the sample size, and the same data as a standardised Z-score chart with fixed ±3 limits. Sample 11 is out of control on both.

Process capability that survives being questioned

A capability index is an estimate, and a single number hides how uncertain that estimate is. Quoted from thirty observations, a Cpk of 1.33 is consistent with a true value well below the limit your customer wrote into the contract. The confidence interval is the part of the result that answers the question actually being asked.

Analyse-it reports Cp, Cpl, Cpu, Cpk and Cpm for the within-subgroup variation, and Pp, Ppl, Ppu and Ppk for the overall variation, with confidence intervals on each. Nonconforming units and sigma metrics come from the same analysis. Where the data is not normal, transformations are applied and shown rather than assumed away, so the choice is visible to whoever reviews the study. Cp, Cpk and Ppk explained sets out what each index measures and why the within and overall figures differ.

Capability analysis in detail →
The process capability example report: the histogram against the specification limits, with the normal Q-Q plot beneath it, on page two of the PDF as Analyse-it produces it. 3 pages Process capability
Copper concentration against a 7 to 11 ppm specification.
The OQ phase only. An Xbar-R chart with Montgomery rules to confirm the process is in control, then a histogram with the specification limits, box plot, Q-Q plot and Shapiro-Wilk test, Pp, Ppl, Ppu and Ppk with 95% CIs, expected nonconforming units at 216 PPM, and Z benchmarks.
The continuous distribution example report: page one of the PDF as Analyse-it produces it. 4 pages Continuous distribution
Newcomb’s speed of light, 64 observations.
Descriptive statistics, frequency histogram with custom classes, box and dot plot, cumulative distribution plot, normal Q-Q plot, Shapiro-Wilk normality test, and a one-sample t-test against a hypothesised 29.97. A second report shows the frequency distribution on its own.

Pareto analysis: put the effort where the defects are

Pareto analysis is simple arithmetic and is still the fastest way to stop a team working on the third most common failure. The value is in the stratification. A defect that dominates overall may belong almost entirely to one line, one shift or one supplier, and the combined chart hides that.

Analyse-it draws the Pareto chart with its cumulative percentage line and stratifies it two ways at once. Combine, reorder or colour the bars so the categories match how the plant actually records them.

Pareto analysis →
The Pareto analysis example report: page one of the PDF as Analyse-it produces it. 3 pages Pareto analysis
Colorimeter downtime before and after training.
Three reports. A comparative Pareto stratified by three operators and by training status, then a Pareto for the 87 failures before training and one for the 58 after, each ranking six failure categories with a cumulative line.
The u chart example report: page one of the PDF as Analyse-it produces it. 1 page u chart
Supply chain errors per unit.
Montgomery, page 325. 20 samples of 50 units. u chart with ±3 sigma limits around a process mean of 0.074 errors per unit. No out-of-control signals.

Root cause: find out what actually changed

A chart tells you when a process moved. Finding out why is ordinary statistics: comparing groups, fitting a model, testing whether a factor matters. Quality teams routinely own a package that charts well and then borrow a second one for this part, or fall back on spreadsheet formulas that nobody validates.

Every Analyse-it edition includes the full Standard edition. Hypothesis tests, one-way, two-way and multi-factor ANOVA, regression and the diagnostics that go with it are in the same ribbon as the control chart. Factorial designs let you vary the suspected factors together rather than one at a time, which is both faster and better at finding interactions.

Factorial designs covers how to plan one and read the interactions it finds.

The Standard edition statistics →
The One-way ANOVA example report: page one of the PDF as Analyse-it produces it. 3 pages One-way ANOVA
Y by brand, 7 groups, 19 observations.
Descriptive statistics by group, Levene test for homogeneity of variance, one-way ANOVA, Tukey-Kramer all-pairs comparisons over 21 contrasts with simultaneous 95% CIs, and a Mean-Mean scatter plot.
The two-way ANOVA example report: the main effect plots and the Tukey-Kramer comparisons on page two of the PDF as Analyse-it produces it. 3 pages Two-way ANOVA
Aircraft primer paint adhesion force.
Montgomery 2001, page 572. Three primer types × two application methods, 18 observations, R² = 0.908. F tests for each term — both main effects significant, the interaction not — LS means, main effect plots, and Tukey-Kramer on both factors.

Measurement system analysis, and the edition that holds it

Before any chart is believed, the measurement system itself has to be good enough for the tolerance it is judging. Characterising it — repeatability, the between-operator and between-day components, linearity across the range — is a separate study, and in Analyse-it it is a separate edition.

The Method Validation edition holds those analyses: precision with nested random factors, variance components with exact, Satterthwaite and MLS confidence intervals, and linearity. Ultimate holds them alongside the control charts. A plant doing both wants Ultimate rather than two licences. Measurement system analysis explained covers what the study is and how the components are read.

More example analyses

The investigation is where a quality toolkit usually runs out. These are the Standard edition analyses that follow a signal — and every edition includes them.

The related contingency table example report: page one of the PDF as Analyse-it produces it. 1 page Related contingency table
Before and after an intervention, 2×2 table.
14 paired observations. Clustered frequency plot, proportion difference with a Tango score 95% CI, and the McNemar test of marginal homogeneity.
The three-factor ANOVA example report: page one of the PDF as Analyse-it produces it. 3 pages Three-factor ANOVA
Surface finish, 2³ factorial design.
Montgomery 2001, page 587. 16 observations with every two-way and three-way interaction fitted. Only factor A is significant at 5%. Main effect plots and interaction effect plots.
The multiple regression example report: page one of the PDF as Analyse-it produces it. 4 pages Multiple regression
Pulse rates before and after exercise, 8 predictors.
109 observations, three continuous predictors and five categorical. Parameter estimates with 95% CIs and VIF, F tests for each term, leverage plots for every predictor, residual diagnostics, and an outlier, leverage and influence plot.
The correlation matrix example report: page one of the PDF as Analyse-it produces it. 2 pages Correlation matrix
New York neighbourhood liveability, 5 variables.
50 observations. Pearson r matrix with a colour map, a scatter plot matrix, and every pairwise coefficient with a 95% CI and a significance test.

Which edition a quality team needs

Control charts, capability indices and Pareto analysis are the Quality Control & Improvement edition, and it includes the full Standard edition — the tests, ANOVA and regression the root-cause work needs — as every edition does. Measurement system work is the Method Validation edition, as above, and Ultimate holds both in one licence, which is what a plant doing charting and measurement system studies wants. The comparison table lists every analysis against every edition.

Every calculation is performed by Analyse-it — no Excel formulas and no third-party functions — validated against the NIST Statistical Reference Datasets and thousands of internal test cases. Results are ordinary Excel workbooks holding the data, the analysis and the conclusion together, and they carry no formulas, so what you reported is what you find when you reopen the file. See how we develop and validate Analyse-it →

Free trial and pricing

Try it on your own data first. The 15-day trial is every feature from all five editions, with no sign-up and no licence key — install it and start straight away.

Quality Control & Improvement edition from US$ 290 per year, or US$ 760 for a perpetual licence. Every purchase carries a 30-day money-back guarantee. Need a quote for purchasing? Add the licence to the cart and save it as a PDF quote.