XLSTAT - ANOVA (Analysis of Variance)

Principles of the Analysis of Variance

Analysis of variance (ANOVA) is a tool used to partition the observed variance in a particular variable into components attributable to different sources of variation.

Analysis of variance (ANOVA) uses the same conceptual framework as linear regression. The main difference comes from the nature of the explanatory variables: instead of quantitative, here they are qualitative. In ANOVA, explanatory variables are often called factors.

ANOVA model

If p is the number of factors, the ANOVA model is written as follows:

yi = ß0 + Σj=1...q ßk(i,j),j + ei

where yi is the value observed for the dependent variable for observation i, k(i,j) is the index of the category of factor j for observation i and εi is the error of the model.

The hypotheses used in ANOVA are identical to those used in linear regression: the errors εi follow the same normal distribution N(0,s) and are independent. It is recommended to check retrospectively that the underlying hypotheses have been correctly verified. The normality of the residues can be checked by analyzing certain charts or by using a normality test. The independence of the residues can be checked by analyzing certain charts or by using the Durbin Watson test.

Options for ANOVA in XLSTAT

XLSTAT enables you to perform one and multiple way ANOVA (MANOVA). Interactions up to order 4 can be included in the model as well as nested and random effects.

XLSTAT can handle both balanced and unbalanced ANOVA.

Results for the analysis of variance in XLSTAT

The results given are a residuals analysis, parameters of the models, the model equation, the standardized coefficients, Type I SS, Type III SS, and predictions are displayed.

In addition several multiple comparison methods can optionally be performed: Bonferroni's and Dunn-Sidak corrected t test, Tukey's HSD test, Fisher's LSD test, Duncan's test, Newman-Keuls' (SNK) method and the REGWQ method. Also the Dunnett's test is available to allow users to perform multiple comparisons with control (MCC) and Multiple comparison with the best (MCB).

Charts for the analysis of variance in XLSTAT

  • Regression chart:
    The chart shows the observed values, the regression line and both types of confidence interval around the predictions.
  • Standardized residuals as a function of the explanatory variable:
    This chart shows the standardized residuals as a function of the explanatory variable. In principle, the residuals should be distributed randomly around the X-axis. If there is a trend or a shape, this shows a problem with the model.
  • The evolution of the standardized residuals as a function of the dependent variable.
  • The distance between the predictions and the observations:
    For an ideal model, the points would all be on the bisector.
  • The standardized residuals on a bar chart:
    The last chart quickly shows if an abnormal number of values are outside the interval]-2, 2[ given that the latter, assuming that the sample is normally distributed, should contain about 95% of the data.


This analysis is available in the XLStat-Basic addin for Microsoft Excel

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey


Like us on Facebook Facebook

Get in Touch

  • Email:
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414