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.



    • Related Articles

    • Descriptive Analysis Workbook p vs MSE (Panelist)

      What is it? p vs MSE (Panelist) is one of the sheets in the Descriptive Analysis Workbook. One graph per panelist with attribute p and MSE values plotted. Why would I use it? Quickly identify which attributes panelists are struggling with ...
    • Descriptive Analysis Workbook Review

      Overview The Descriptive Analysis Workbook provides detailed analyses on product and panelist performance. The report is compatible with sample related Line Scale , Category , LMS , Numeric , and ' Choose 1 ' questions when 2 or more samples are ...
    • Descriptive Analysis Workbook Panelist SD Table

      What is it? Panelist SD Table is one of the sheets in the Descriptive Analysis Workbook . A table with the Square root of Mean Square Error (Sqrt(MSE)) value by attribute and the Standard Deviation (SD) from a 1-way ANOVA by panelist and attribute. ...
    • Descriptive Analysis Workbook Correlation Table

      What is it? Correlation Table is one of the sheets in the Descriptive Analysis Workbook . Displays the attribute correlation across all samples and reps. Why would I use it? To see if there is a positive or negative correlation between attributes. ...
    • Descriptive Analysis Workbook Panelist Cards

      What is it? Panelist Cards is one of the sheets in the Descriptive Analysis Workbook . Displays a table/card for each panelist showing their response broken down by each attribute, including all samples for each rep. Why would I use it? Provide a ...