XLSTAT - Mixed Models

Principles of Mixed models

Mixed models are complex models based on the same principle as general linear models. They make it possible to take into account, on the one hand, the concept of repeated measurement and, on the other hand, that of random factor. The explanatory variables could be as well quantitative as qualitative. Mixed models can be used to carry out repeated measures ANOVA.

Mixed models equation

A mixed model is written as follows:

y = Xβ + Zγ + ε

where y is the dependent variable, X gathers all fixed effects (these factors are the classical OLS regression variables or the ANOVA factors), β is a vector of parameters associated with the fixed factors, Z is a matrix gathering all the random effects (factors that cannot be set as fixed), γ is a vector of parameters associated with the random effects and ε is an error vector.

Parameters are estimated using the maximum likelihood estimator. XLSTAT propose different covariance matrix between the errors within the framework of mixed models.

In addition, the interactions to be used in the model can be easily defined in XLSTAT.

Results for Mixed models in XLSTAT

XLSTAT allows computing the type I, II and III tests of the fixed effects. The principle of these tests is the same one as in the case of the linear model. Nevertheless, their calculation differs slightly.

As in classical ANOVA, in repeated measures ANOVA multiple comparisons can be performed. It is aimed at checking whether the various categories of a factor differ significantly or not. For example, in the case where four treatments are applied to plants, we want to know not only if the treatments have a significant effect, but also if the treatments have different effects.
Numerous tests have been proposed for comparing the means of categories.

The majority of these tests assume that the sample is normally distributed. XLSTAT provides the main tests. In the case of repeated measures ANOVA, standard deviations are obtained using the maximum likelihood estimates.


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