XLSTAT: STATIS analysis in Excel

This tutorial will show you how to run and interpret a STATIS analysis in Excel using the XLSTAT statistical software.

 

Background

The STATIS method is a multi-configuration data analysis commonly used in sensory analysis. The configurations represent the various assessors, subjects or judges. This method can be particularly used in the case of projective mapping / Napping, conventional profiling or free choice profiling. The great interest of STATIS is that atypical configurations have a smaller weight than the weight of central configurations. The analysis, therefore, best reflects the general point of view and not those atypical configurations.

 

Dataset for Example

The data come from a projective mapping / Napping study carried out in Rennes by AGROCAMPUS OUEST. 8 smoothies were tasted by 24 subjects (panelists) and then placed on a tablecloth. The coordinates were collected for the STATIS analysis. If a panelist considers two products to be similar, the latter ones are placed closed by on the tablecloth, so they have similar coordinates. The original file can be obtained with the R SensoMineR package.

The goal of this tutorial is to study and visualize the links between smoothies as well as to determine the agreements between the subjects.

 

Setting Up

• Open XLSTAT.

• Click on the Sensory profiling menu and select the STATIS feature.

• The STATIS dialog box will appear.

In the General tab:

• Select the data on the Excel sheet of the demo file that corresponds to the configurations (a configuration corresponds here to the set of coordinates given by a subject).

• Set the Number of configurations equal to 24 subjects.

• As each configuration has 2 variables, let XLSTAT know that the number of variables is constant by selecting the Equal option. If the number of variables is different for a least one configuration, you need to select a column that contains the number of variables for each configuration.

• Activate the options Variable labels and the Object labels (in our case the smoothies).

In the Options tab:

• Choose to Globally reduce the configurations to avoid the scale effect. Since all the variables are on the same scale within each configuration, it is so not necessary to reduce the variables.

In the  Outputs tab:

• Choose to display the RV matrix, as well as the RV among the configurations and the consensus to have indicators of proximity between the subjects.

In the Charts tab:

• The options remain as default.

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

In this example, the percentage of variability represented by the first two factors is not very high (68.43%). The following graph is the main objective of STATIS: to represent the observations on a 2-dimensional map, and thus to identify the proximities. For example, we see that "Casino_PBC" and "Innocent_PBC" smoothies are perceived as close, but they are very different from "Casino_SRB". 

If we are interested in two particular subjects (panelists), it is useful to look at the RV matrix which gives the coefficient RV among each subject (this coefficient is between 0 and 1 and increases with the proximity of the subjects). We see here that subject 1 has a very similar opinion about subject 2, but very different from subject 4 (which has low RV values with many other subjects here).

It may be very important to assess the proximity of one subject to all the others, i.e. the overall point of view reflected by the consensus. Thus, the following bar chart shows that subject 4 is a rather atypical subject, unlike 18 or 23.

Finally, the following graph gives the residuals by object, which indicates which objects were placed in the same way by the subjects, like the smoothie "Innocent_PBC", or rather differently, like the smoothie "Carrefour_SB".