XLSTAT: Create a Products/Assessors Table in Excel

 

Dataset for Example

The attached dataset used in this example consists of 210 samples, where 15 assessors evaluated 14 products based on 6 descriptors. A sample view of the data is shown below:

 

Setting Up

• Open XLSTAT.

• Click on the Sensory/ Sensory profiling data menu and select the Create a Products/Assessors table feature.

• The dialog box pops up.

• In the XLSTAT interface, select the data corresponding to the descriptors, the product identifiers, and the assessor identifiers.

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

The resulting report provides an overview of the data, including the number of assessors, products, and sessions.

The Product/Assessor table is displayed, with the following features:

• 1st Row - labels of the assessors.

• 2nd Row -  labels of the descriptors.

• 1st Column - labels of the products.

The body of the table presents the data organized by assessors.

The table helps analyze how assessors rate products using specific descriptors, revealing patterns and differences in evaluations.