You’ll be surprised how quickly you move from raw numbers to confident, data-driven decisions. XLSTAT transforms Excel from a spreadsheet tool into a statistical partner. And with this tutorial, you’ve just taken the first step.
| Category | Example tests/features | |----------|------------------------| | | Linear, logistic, Poisson, ridge, PLS | | ANOVA | One-way, two-way, repeated measures, ANCOVA | | Multivariate | PCA, correspondence analysis (CA), MDS, clustering (k-means, hierarchical) | | Machine learning | Random forests, SVM, neural networks (basic) | | Sensory analysis | Preference mapping, panel performance | | Time series | ARIMA, exponential smoothing, ACF/PACF | xlstat tutorial
If you’ve ever tried to perform serious statistical analysis in native Excel, you know the pain. The built-in Analysis ToolPak is basic, clunky, and lacks essential tests (like variance homogeneity checks, advanced PCA biplots, or proper logistic regression). Enter XLSTAT — a powerful, user-friendly add-in that transforms Excel into a full-fledged statistical and data mining workbench. You’ll be surprised how quickly you move from
In this tutorial, I’ll walk you through what XLSTAT offers and then guide you through a complete, practical example: . 1. What Is XLSTAT? XLSTAT is an Excel add-in (Windows & Mac) developed by Lumivero. It adds over 300 statistical features to Excel, from descriptive stats and regression to machine learning (random forests, SVM), multivariate analysis (PCA, MCA, PLS), and even process control charts. In this tutorial, I’ll walk you through what
| Day | Format_A | Format_B | |-----|----------|----------| | 1 | 45 | 52 | | 2 | 47 | 55 | | ... | ... | ... | | 20 | 46 | 53 |
p < 0.05 → Reject the null hypothesis.