Hands On Analysis of Consumer Test Data using XLSTAT – 7, 9, 14, 16 March 2023 @ 14:00 (GMT)

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. If you are attending Module 1 we will send you a short basic statistics refresher to read before the module.

Following soon after this training we are hosting two webinars on  Preference Mapping using XLSTAT  – 21  March and Preference Modelling using Partial Least Squares in XLSTAT – 23 March 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 (7 March @ 14:00 GMT)

• Aspects of Consumer Test Design
  • Monadic or Sequential Monadic
  • Presentation Orders
  • Aspects of Risk
  • Estimating Sample Size

• 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
  • Rotating components to improve interpretability

Module 2 – Cluster Analysis (9 March @ 14:00 GMT)

• 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
  • Outline of Latent Class Clustering
  • 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 patterns
  • Cluster Plotting
  • Validating KMEANS using randomisations

Module 3  – Demographic and Free Text Data (14 March @ 14:00 GMT)

• 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 (16 March @ 14:00 GMT)

• 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
  • Analysis and mapping of RATA Data
• Ideal Product Prof
  • Ideal product scoring
  • Mapping and analysis for product optimisation

Each Module of 3.5 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. PLEASE CHECK THE TIME ZONE IS SUITABLE FOR YOU. Timings are given in UK time zone (Greenwich Mean Time).

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 (21 March)

Preference Modelling using Partial Least Squares in XLSTAT (23 March)