Descriptive Analysis Workbook Correlation Table

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.

Setup options

To generate the Correlation Table sheet, under 2. Select Options , select Correlation table .
 


Analysis Overview

Highlight high positive or negative correlations.   Scale Range -1 to 1.
Thresholds are set at <-0.5 and >0.5



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

Example Conclusion

Sweetness Flavour is positively correlated above the threshold for Yellow Colour, Fresh Apple Aroma, Sweetness Aroma and Fresh Apple Flavour. It is also positively correlated with Opacity and Tartness Flavour but it does not meet threshold criteria.
Sweetness Flavour is negatively correlated with Brown Colour, Cooked Apple Aroma and Cooked Apple Flavour.
If we were hoping to simplify our ballot by removing attributes we might consider only have Cooked Apple Flavour or Cooked Apple Aroma as they are very highly positively correlated.
We also observe that Cooked Apple Aroma is negatively correlated with Fresh Apple Aroma, same with Cooked Apple Flavour and Fresh Apple Flavour. This is anticipated as they would not be expected to both be present at the same time.



    • Related Articles

    • 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 ...

    • 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 Only 1 ' questions when 2 or more samples ...

    • 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 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 Attribute Summary

      What is it? Attribute Summary is one of the sheets in the Descriptive Analysis Workbook . It is a summary of attributes across all panelists, reps and samples. Why would I use it? It can be helpful to gain insight into the attributes and the effect ...