Descriptive Analysis Workbook Panelist SD Table

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. 

Why would I use it?

Identify variability of your panelists' responses across sessions.

Setup options



To generate the Panelist SD Table sheet, under 2. Select Options , select Panelist performance summary .  Update the thresholds as required.



Reps are required to generate this sheet.


Analysis Overview

Using the log allows us to compare the relative difference since the means will vary from attribute to attribute so it doesn't make sense to use a linear scale.



  1. Sqrt(MSE)  . Square Root of the Mean Square Error of the panel by attribute.
  2. Panelists .  Standard Deviation (SD) for each panelist by attribute.
  3. Percentage . The total number of times outside of of the preset threshold/ total number *100.
  4. Highlighted cells . SD is greater than the percentage of the scale from the preset threshold.


Example Conclusion


The lower the values are, the better panelist responses are replicated across sessions.
All of the panelists are within our preset acceptable threshold. In this example the SD needs to be less than 16.67% (1/6th) of the scale.



    • Related Articles

    • 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 ...
    • Descriptive Analysis Workbook Panelist Consistency

      What is it? Panelist Consistency is one of the sheets in the Descriptive Analysis Workbook. Determines consistency by looking at the range of responses given across the reps. Why would I use it? Identify panelists, attributes or samples that were not ...
    • Descriptive Analysis Workbook Panelist Mean Scores

      What is it? Panelist Mean Scores is one of the sheets in the Descriptive Analysis Workbook . One table per attribute with different indicators of discrimination among panel and panelists. Why would I use it? Further investigate discrimination ability ...
    • 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 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 ...