Excel’s built-in Analysis ToolPak handles a handful of basic tests — a t-test, a one-way ANOVA, a simple regression — but produces static output with no diagnostics, no multiple comparisons, and no way to check whether the assumptions hold. Other add-ins and standalone spreadsheet tools fill some of the gaps, but most are a patchwork of disconnected tests and plots bolted together without a coherent workflow — and few have been rigorously validated against published reference datasets.
Analyse-it provides the depth you need to do the job properly. Describe and visualise data, compare groups, fit regression models, reduce dimensionality with PCA, and analyse categorical data — all inside Excel with the iterative workflow that lets you build, examine, and refine until you’re confident in the result. Every calculation is validated and tested for accuracy against NIST-StrD.
Every analysis starts with understanding the data. What does the distribution look like? Are there outliers? Is it normal?
Independent samples, paired samples, two groups or ten — parametric and non-parametric tests with the assumption checks built into the same workflow:
For method comparison studies in regulated environments, see the Method Validation edition.
The exploratory step between describing variables individually and fitting a regression model:
Regression as a process of building, examining, and refining — not a single pass from data to p-value:
One-way, two-way, and full multi-factor designs with the same diagnostic and comparison tools as regression:
For ANOVA used in process investigation alongside SPC and capability analysis, see the Quality Control & Improvement edition.
When the outcome is binary — survived or not, responded or not, defective or not:
For clinical prediction modelling alongside ROC, Bland-Altman, and survival analysis, see the Medical edition.
Make multivariate data interpretable with visualisations most packages don’t offer:
When the data is categorical — pass/fail, treated/untreated, exposed/unexposed — you need tests designed for proportions, not means:
The Standard edition is included in the Medical, Quality Control & Improvement, Method Validation, and Ultimate editions. If you need survival analysis, ROC curves, control charts, or CLSI method validation protocols, the general statistics toolkit comes with them — so you can investigate, explore, and dig deeper when the specialist analysis raises questions.
Download example datasets, open them in the trial, and see exactly what the output looks like.
Distribution
Correlation
Multiple regression
Two-way ANOVA
