Included inXLSTAT-Base XLSTAT-Sensory XLSTAT-Marketing XLSTAT-Forecast XLSTAT-Biomed XLSTAT-Ecology XLSTAT-Psy XLSTAT-Quality XLSTAT-Premium
Some definitions: Observed Means and Least Squares MeansIn this article, we will frequently refer to two types of means defined as follows:
- Observed Means: Regular arithmetic means that can be computed by hand directly on your data without reference to any statistical model.
- Least Squares Means (LS Means): Means that are computed based on a linear model such as ANOVA.
Dataset to illustrate the difference between Observed Means & LS Means
An Excel sheet with both the data and the results can be downloaded by clicking on the button below:Download the data
The data correspond to several ratings given by two judges for two products A & B. The data are unbalanced as the number of ratings for each product differs according to the judge.
One-way ANOVA: Observed Means & LS means are always the sameImagine a situation where two judges are rating the same product. Each judge rates the product several times. We want to compare the mean grade per judge. In this case, the mean grade of each judge computed by hand will be exactly the same as LS Means arising from a 1-way ANOVA.
Means & LS means differ when dealing with a bit more complex models such as unbalanced multi-way ANOVAs that include interactions.
Unbalanced multi-way designs: Observed Means & LS Means differConsider now the original dataset where each judge rates two products several times such as:
- Judge 1 x Product A: 6 ratings
- Judge 1 x Product B: 10 ratings
- Judge 2 x Product A: 7 ratings
- Judge 2 x Product B: 4 ratings
Let’s get back to the comparison mean rating per judge, considering means first and LS means second.
Using the regular observed means:
Mean of Judge 1 is the mean of the 16 ratings performed by judge 1 (6 for Product A and 10 for Product B).Mean of Judge 2 is the mean of the 11 ratings performed by judge 2 (7 for Product A and 4 for Product B).
Using the LS mean based on a Two-way ANOVA with an interaction:Mean of Judge 1 is the mean of two numbers:
1) The mean of the 6 replicates of Product A tested by Judge 1
2) The mean of the 10 replicates of Product B tested by Judge 1
Mean of Judge 2 is the mean of two numbers:
1) The mean of the 7 replicates of Product A tested by Judge 2
2) The mean of the 4 replicates of Product B tested by Judge 2
SummaryHere are the values for the two types of means:
Why should you prefer LS Means compared to Observed Means?In unbalanced, multi-way designs, the LS means estimation is often assumed to be closer to reality. LS Means somehow correct the design’s imbalance. In our case, LS Means estimation gives the same weight to both products when estimating mean ratings for judges. Conversely, for judge 1, the observed mean estimation incorporates a weight of 6 for product A and a weight of 10 for product B, which gives a judge rating estimation biased in favor of product B.
In balanced designs, or in unbalanced 1-way ANOVA designs, observed means and least squares means are the same.
How to obtain LS Means in Excel using XLSTAT?When running an ANOVA in XLSTAT, the software computes LS means by default.
After opening XLSTAT, go to Modeling Data / ANOVA.
In the General tab, select Grade as a Quantitative dependent variable. Select Judge and Product in the Qualitative Explanatory variables.
In the Options tab, activate Interactions / Levels option, and set the level of interactions at 2.
In the Outputs / Means tab, make sure you activate the LS Means option.
Activate all the factors and interactions, then click OK.
The LS Means report for each effect appears at the bottom of the results report: