Hands On Analysis of Consumer Test Data using XLSTAT – 8, 10, 15 & 17 June 2021 @ 15:00 (BST/GMT+1)

Hands on Analysis of Consumer Data from Product Tests using XLSTAT

This course is presented as four separate modules and covers the main techniques used for analysing data collected in Central Location (CLT) or Home Use (HUT) tests on products. Each session is a mix of talks and practical workshops with solutions and interpretation of the output included to help you improve your analysis skills. The methods are illustrated using XLSTAT software.

You can choose to book on all 4 modules (at a discounted price) or just choose the ones that are of most interest to you. As in all our courses, mathematical details are kept to a minimum with emphasis placed on the application of techniques and understanding of the key statistical outputs.

Following soon after this training we are hosting two webinars on Preference Mapping (22 June) and Preference Modelling (24 June) for product optimisation which complement the topics covered in these four modules. A 10% discount will be given to delegates who attended at least one of the modules of the “Hands On Analysis of Consumer Test Data from Product Tests using XLSTAT”

Module 1 – The Basics (8 June @ 15:00 BST/GMT+1) 

• Testing Differences in Product Acceptability
  • Analysis of Variance (ANOVA) to test for significant differences in average liking between products
  • Putting “significance” in its rightful place
  • Multiple Comparison tests – gains and losses
• Mapping Product Data using Principal Component Analysis (PCA)
  • PCA – How it works, graphical explanation
  • Key outputs to consider
  • Difference between covariance and correlation PCA
  • Overlaying supplementary variables – the simplest preference mapping

Module 2 – Cluster Analysis (10 June @15:00 BST/GMT+1)

• Aims of the methods
  • data requirements and pre processing
• Clustering Methods
  • Agglomerative Hierarchical Classification (AHC) – how it works , which settings to use
  • KMEANS for larger data sets
  • Latent Class Clustering will also be outlined
  • Comparison of the methods – recommendations
  • Clustering incomplete data
  • Cluster Trimming
• Internal Preference Mapping
  • Data mapping using PCA
  • Visualisation of cluster solution
• Cluster Validation
  • ANOVA modelling to confirm cluster differences in average liking patterms
  • Cluster Plotting
  • Validating KMEANS using randomisations

Module 3  – Demographic and Free Text Data (15 June @ 15:00 BST/GMT+1)

• Detecting Demographic differences in acceptability using ANOVA
  • Using nested models to model sample by demographic interactions – visualisation and significance testing
• Investigating associations between clusters and demographics
  • Chi-squared association analysis
• Mapping Associations using Correspondence Analysis
  • Correspondence Analysis – how the technique works, interpretation of maps
• Analysis of Open Comment Data
  • Analysis of open comment data using XLSTAT Text Mining

Module 4  – Other Scales (17 June @ 15:00 BST/GMT+1)

• JAR Scales and Penalty Analysis
  • Advantages and disadvantages of the approach
  • Testing significant differences between products
  • Relating JAR to Liking – XLSTAT Penalty Analysis Routine
• CATA and RATA Data
  • Significance testing of CATA data using Cochran’s Q Test
  • Product mapping of CATA data using Correspondence Analysis or PCA
  • Clustering of consumers using CATA data – XLSTAT CLUSCATA routine
  • Analysis and mapping of RATA Data
• Ideal Product Profling
  • Ideal product scoring
  • Mapping and analysis for product optimisation

Each Module of three hours is available to purchase separately as a stand alone session, or book on all four modules to get the discounted price. When booking, please confirm which modules you wish to attend – either in the comment box of the booking form, or drop us an email at askqi@qistatistics.co.uk.

Two further webinars are available to complement this course which cover techniques for product optimisation based on consumer acceptability. If you have attended any of the modules of “Hands on Analysis of Consumer Test Data using XLSTAT” you will qualify for a 10% discount on the following webinars:

Preference Mapping using XLSTAT (22 June)

Preference Modelling using Partial Least Squares in XLSTAT (24 June)