XLSTAT - ANCOVA (Analysis of Covariance)

Principles of ANCOVA (Analysis of Covariance)

ANCOVA (ANalysis of COVAriance) can be seen as a mix of ANOVA and linear regression as the dependent variable is of the same type, the model is linear and the hypotheses are identical. In reality it is more correct to consider ANOVA and linear regression as special cases of ANCOVA.

ANCOVA model

If p is the number of quantitative variables, and q the number of factors (the qualitative variables including the interactions between qualitative variables), the ANCOVA model is written as follows:

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

where yi is the value observed for the dependent variable for observation i, xij is the value taken by quantitative variable j 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 and ANOVA: the errors εi follow the same normal distribution N(0,s) and are independent.

Interactions in ANCOVA

XLSTAT enables you to perform one and multiple way ANCOVA up to order 4 interactions between factors can be included in the model. One of the features of ANCOVA is to enable interactions between quantitative variables and factors to be taken into account. The main application is to test if the level of a factor (a qualitative variable) has an influence on the coefficient (often called slope in this context) of a quantitative variable. Comparison tests are used to test if the slopes corresponding to the various levels of a factor differ significantly or not.

Results for an Analysis of Covariance in XLSTAT

The results contain residuals analysis, Type I SS, Type III SS, and predictions.

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.

The Dunnett's test is available to allow users to perform multiple comparisons with control (MCC) and Multiple comparison with the best (MCB).


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