XLSTAT

XLSTAT is a complete analysis and statistics add-in for Excel. It has been developed since 1993. XLSTAT includes more than 240 features in general or field-specific solutions. The use of Excel as an interface makes XLSTAT a user-friendly and highly efficient statistical and multivariate data analysis package.

It includes regression (linear, logistic, nonlinear), multivariate data analysis (Principal Component Analysis, Discriminant Analysis, Correspondence Analysis, Multidimensional Scaling, Agglomerative Hierarchical Clustering, K-means, K-Nearest Neighbors, Decision trees), correlation tests, parametric tests, non parametric tests, ANOVA, ANCOVA, mixed models and much more. Field-specific solutions allow for advanced multivariate analysis (RDA, CCA, MFA), Preference Mapping and other sensometrics tools, Statistical Process Control, Simulations, Time series analysis, Dose response effects, Survival models, Conjoint analysis, PLS modelling, Structural Equation Modelling, OMICS data analysis... Optional modules include 3D Visualization and Latent Class models.

The XLSTAT statistical analysis software is compatible with all Excel versions from 2003 to 2016. A Mac version is also available on the XLSTAT website, and works on Excel 2011 & 2016.

Yang's workshop provides customised XLSTAT training workshops/ for XLSTAT-Sensory package.

Training syllabus example (fits to 3-day workshop). You are welcome to request any additional content that you wish to include.

Sensory fundamentals - Why is sensory evaluation a science discipline?
Understanding data
Introduction to XLSTAT
Understanding statistical significance
Understanding Descriptive Analysis
Visualising Descriptive Analysis by Principal Component Analysis (PCA)
Temporal profiling methods
Rapid profiling methods
Modelling sensory data with instrumental data
Consumer test fundamentals and collecting consumer data
Analysing and interpreting consumer data
Total Unduplicated Reach and Frequency (TURF)
Conjoint analysis