Descriptive Analysis Workbook Correlation Table
What is it?
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
.
|
|
Highlight high positive or negative correlations.
Scale Range -1 to 1.
Thresholds are set at <-0.5 and >0.5
- Red cells
. Correlation value greater than the upper threshold.
- Orange cells
. Correlation value less than the lower threshold.
-
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 Testing
Overview Welcome to the Descriptive Analysis Testing Webinar! This webinar will take you through all of our features specifically for DA Testing, from training your panelists with FCM, having open discussions with our Show results at end feature to ...
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 ...