ANOVA Software for Microsoft Excel
One-way, two-way, and multi-factor ANOVA and ANCOVA — with interaction plots, the most extensive range of multiple comparison procedures available in any Excel add-in, and results that stay in your workbook.
Try free for 15 days — no credit card required
Trusted by 75,000 researchers, analysts, and scientists at leading universities, hospitals, and companies worldwide — for over 30 years.
ANOVA that goes beyond the one-way case
Most tools make simple one-way ANOVA easy and everything else painful. Analyse-it handles one-way, two-way, and full multi-factor ANOVA and ANCOVA in the same workflow — including crossed factors, polynomial terms, interactions, and continuous covariates — without writing a line of code or leaving Excel.
The most complete multiple comparisons in any Excel add-in
Knowing that groups differ is only the start. Analyse-it includes nine multiple comparison procedures — Tukey-Kramer, Dunnett, Hsu, Scheffe, Steel, Dwass-Steel-Critchlow-Fligner, and more — so you can answer the specific question your analysis requires, whether that’s all pairs, against a control, or with the best.
Professional results without the professional price tag
Minitab and JMP give you excellent ANOVA tools at a cost most practitioners can’t justify for occasional use. SPSS charges per module. Analyse-it gives you the same depth — including interaction plots, effect means, leverage plots, and residual diagnostics — at a fraction of the price, inside the Excel you already have.
Excel’s built-in ANOVA tool is a starting point, not a solution. It handles simple one-way cases, produces a static output table with no diagnostics, and stops there. No interaction plots. No multiple comparisons. No way to include covariates. No way to iterate.
Analyse-it gives you a complete ANOVA workflow inside Excel. Build one-way and multi-factor models, test for homogeneity of variances before you commit to a model, examine main effects and interactions visually, and then use the right multiple comparison procedure to answer the specific question your analysis requires. When the residuals suggest a problem, you can adjust the model immediately — everything updates in the same workbook.
For designs with a continuous covariate that needs to be controlled for, ANCOVA is included in the same workflow. Adjust for the covariate, examine adjusted effect means, and run the same multiple comparison procedures on the corrected estimates.
What's included
- One-way ANOVA One-way between-subjects ANOVA for equality of means, with Welch’s ANOVA for unequal variances. Kruskal-Wallis non-parametric alternative. Bartlett, Levene, and Brown-Forsythe tests for homogeneity of variances. Descriptive statistics and side-by-side plots by group.
- Multi-factor ANOVA and ANCOVA Build models with multiple factors, crossed factors, polynomial terms, interactions, and continuous covariates. Categorical variables coded automatically as dummy variables. Full factorial and custom model structures. Type I and Type III tests for each term. ANCOVA with adjusted effect means.
- Within-subjects and repeated measures One-way within-subjects ANOVA for repeated measures designs. Friedman non-parametric alternative. Paired comparisons with appropriate error terms.
- Nine multiple comparison procedures Student’s t and Wilcoxon-Mann-Whitney for individual comparisons. Tukey-Kramer and Dwass-Steel-Critchlow-Fligner for all pairs. Dunnett and Steel for comparisons against a control. Hsu for comparisons with the best. Scheffe for all contrasts. Mean-Mean scatter plot to visualise differences.
- Effect means and interaction plots Estimated effect means with confidence intervals for each factor level. Main effect plots and interaction plots to visualise how factors combine. Leverage plots (partial residual plots) to assess the contribution of each term after accounting for all others.
- Residual diagnostics Raw and standardised residual plots, sequence and lag plots, residual distribution. Outlier and Influence plot using Cook’s D and Studentised Residuals to identify observations with undue influence on the model.
- More than just ANOVA ANOVA and ANCOVA are part of the Standard edition, which also covers descriptive analysis, hypothesis testing, simple and multiple regression, correlation, PCA, factor analysis, and categorical data analysis — all in the same Excel workflow.
Join 75,000 scientists who rely on Analyse-it. No credit card required. Full functionality from day one.
Try free for 15 days — no credit card required
