Statistics add-in software for statistical analysis in Excel

ANOVA and ANCOVA software for group comparisons One-way, two-way, and multi-factor ANOVA and ANCOVA — with nine multiple comparison procedures, interaction plots, leverage plots, residual diagnostics, and Welch's ANOVA for unequal variances. NIST-validated calculations.

Try free for 15 days — no credit card required Analyse-it rated 4.9/5 on Capterra

Trusted by 75,000 researchers, analysts, and scientists at leading universities, hospitals, and companies worldwide — for over 30 years.

logo logo logo logo logo logo

Beyond the one-way case

One-way, two-way, and full multi-factor ANOVA and ANCOVA in the same workflow — crossed factors, polynomial terms, interactions, and continuous covariates. Full factorial and custom model structures with Type I and Type III tests for each term.

Nine multiple comparison procedures

Tukey-Kramer and Dwass-Steel-Critchlow-Fligner for all pairs. Dunnett and Steel against a control. Hsu with the best. Scheffe for all contrasts. Student's t and Wilcoxon-Mann-Whitney for individual comparisons. The right procedure for the specific question your analysis requires.

NIST-validated accuracy

All calculations run in Analyse-it's own validated engine — not Excel's built-in functions. Validated against NIST Standard Reference Datasets with IEEE 754 double-precision arithmetic throughout.

Excel's built-in ANOVA tool handles the simple one-way case, produces a static output table, and stops there. No interaction plots. No multiple comparisons. No way to include covariates or build multi-factor models. No way to check whether the assumptions hold. For anything beyond the simplest design, it is not a viable tool — and the results it does produce cannot be iterated or updated when the data changes.

Analyse-it provides a complete ANOVA workflow. Build one-way and multi-factor models with crossed factors, polynomial terms, interactions, and continuous covariates. Test for homogeneity of variances with Bartlett, Levene, and Brown-Forsythe before committing to a model. Examine main effects and interactions visually with effect mean plots and interaction plots. Use leverage plots to assess the contribution of each term after accounting for all others. When the residuals suggest a problem — non-normality, heteroscedasticity, influential observations — adjust the model and re-run immediately. Everything updates in the same workbook.

Knowing that groups differ is only the start. The nine multiple comparison procedures answer the specific question the analysis requires. Tukey-Kramer for all pairwise comparisons. Dunnett for comparisons against a control. Hsu for comparisons with the best. Scheffe for arbitrary contrasts. Dwass-Steel-Critchlow-Fligner and Steel as non-parametric alternatives. Each procedure controls the family-wise error rate appropriately for its comparison structure. For designs with a continuous covariate, ANCOVA adjusts for the covariate, examines adjusted effect means, and runs the same multiple comparison procedures on the corrected estimates.

75,000 researchers, analysts, and scientists at leading universities, hospitals, and companies worldwide have relied on Analyse-it for over 30 years.

What's included

  • Compare groups with 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.

  • Build multi-factor models with ANOVA and ANCOVA

    Multiple factors, crossed factors, polynomial terms, interactions, and continuous covariates. Categorical variables coded automatically. Full factorial and custom model structures. Type I and Type III tests for each term. ANCOVA with adjusted effect means.

  • Handle repeated measures designs

    One-way within-subjects ANOVA for repeated measures. Friedman non-parametric alternative. Paired comparisons with appropriate error terms.

  • Answer the specific question with the right comparison

    Nine multiple comparison procedures: Tukey-Kramer and Dwass-Steel-Critchlow-Fligner for all pairs; Dunnett and Steel against a control; Hsu with the best; Scheffe for all contrasts; Student's t and Wilcoxon-Mann-Whitney for individual comparisons. Mean-Mean scatter plot to visualise differences.

  • See how factors combine with interaction and effect plots

    Estimated effect means with confidence intervals for each factor level. Main effect plots and interaction plots. Leverage plots to assess each term's contribution after accounting for all others.

  • Check assumptions with 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.

  • Part of the Standard edition

    ANOVA and ANCOVA are part of the Standard edition, which also covers simple and multiple regression, logistic regression, PCA and factor analysis, descriptive analysis, hypothesis testing, and categorical data analysis. All the professional statistics you need — at a fraction of the cost of dedicated packages.

  • Analyse-it has helped tremendously. Previously I used Prism and Microsoft Excel, but Analyse-it has made my life so much easier and saved so much time.
    Man Khun Chan, M.Sc., ART
    Test Development Medical Technologist
    The Hospital For Sick Children, Toronto, Canada
  • I purchased Analyse-it and I love it. Thank you so much for the superb and easy to use program. Technical support is the best I have ever seen.
    Addy Alsumidaie, MD, Ph.D.
    Director, Clinical Development
    Johnson and Johnson
  • 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
  • Although we only scratch the surface of Analyse-it’s capabilities, we have a very high volume of use for the statistics we need. It’s saved us time and the reports look professional.
    Michael Savage
    Chemistry Supervisor
    Baptist Hospital East

Trusted by 75,000 researchers, analysts, and scientists at leading universities, hospitals, and companies worldwide — for over 30 years.

Try free for 15 days — no credit card required Analyse-it rated 4.9/5 on Capterra


statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.