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

Product code: Hands on Analysis June 2021 (USA)

Remote training

June 17, 2021 - June 17, 2021

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)



Select currency

$516.58$2,780.37 (Excluding any applicable taxes)

Other course information

About The Trainer
Anne Hasted began her career as an academic statistician at Reading University, but is now senior consultant at Qi Statistics Ltd offering statistical training, software and consultancy support to research and industry. She has wide training and consultancy experience in many different commercial fields and has an international reputation for “user friendly” training.


You will need the latest version of XLSTAT installed on your computer. If you don’t have a licence you can download a 14-day trial version, or purchase a copy through us with a discount* (see below).


Each module is 3 hours (please allow extra time for any connectivity issues up front, and questions at the end).

Please check your time zones to make sure the timings are suitable for your country.



1 Module: £395.00 ex VAT

2 Modules: £790.00 ex VAT

3 Modules: £1185.00 ex VAT

4 Modules (Complete Course): £1450.00 ex VAT

Academic Delegate discount is available.
10% reduction for multiple bookings from same organisation


XLSTAT purchase will be added to the course price only if this option is selected. The discount only applies if training is taken and only applies to the first year price. At the time of renewal the full price will be charge directly by XLSTAT.

Please contact us for more details.