Descriptive Analysis Workbook Panelist vs Panel Correlation Table

Descriptive Analysis Workbook Panelist vs Panel Correlation Table

What is it?

Panelist vs Panel Correlation Table is one of the sheets in the Descriptive Analysis Workbook. Displays the panel agreement for all attributes for all panelists using Pearson's Correlation Coefficient.

Why would I use it?

 To see if there is a positive or negative correlation for panelists in comparison to the panel.

Setup options


To generate the Panelist vs Panel Correlation Table sheet, under 2. Select Options , select Panelist vs panel correlation .
 


Analysis Overview

Provides insights on panelist performance by identifying panelist not in agreement with the panel.
Highlight high positive or negative correlations.  Scale Range -1 to 1.



  1. Green cells . Correlation value greater than the upper threshold.
  2. Red cells . Correlation value less than the lower threshold.
  3. White cells . Correlation value between the thresholds.

Example Conclusion

We already know that Noel Crabtree flipped the scale for Fresh Apple Aroma/Flavour and Cooked Apple Aroma/Flavour so it is anticipated that there would be a negative correlation for these attributes.
We also know that Tabitha Rouse had a slightly different use of the scale for Sweetness Flavour. Here we see that there is still a positive correlation, so she hasn't totally flipped the scale, but the correlation does not meet our preset threshold value and is therefore not highlighted.
For the most part, we see that our panel has good overall agreement.