Skip to main content
XLSTAT is joining the Lumivero family. Learn more.

Free Data Analysis Webinars

Learn Data Science and Data Analysis with XLSTAT webinars. This article lists the recording of our past webinars.

XLSTAT Tips & Tricks

30 minutes
In this video, we’ve gathered our best XLSTAT tips & tricks for you!
WATCH THE WEBINAR

Produced by Addinsoft, directed by Thalia Anagnostou



Getting started with XLSTAT

30 minutes
In this video, you'll learn all the basics of XLSTAT: from data importation to outputs customization using concrete examples.
WATCH THE WEBINAR

Produced by Addinsoft, directed by Thalia Anagnostou



Sensory data analysis

1 hour
Part 1 - Evaluating differences between products
This webinar is an introduction to common difference methods such as sensory discrimination tests and sensory product characterization.
Part 2 - Relating preference to sensations
This webinar presents a few popular tools used for this purpose, such as Preference Mapping (PREFMAP), CATA data analysis as well as Penalty Analysis.

Produced by Addinsoft, directed by Jean-Paul Maalouf



Medical data analysis

1 hour
Part 1 - Introduction and basic tests
This webinar presents several descriptive statistical tools as well as some common statistical tests used in data from study designs.
Part 2 - Multivariate approach and Survival analysis
This webinar is an introduction to both types of approaches.

Produced by Addinsoft, directed by Jean-Paul Maalouf



Describing Data with XLSTAT

1 hour
Descriptive statistics allow summarizing information contained in datasets using simple numbers such as the mean or the standard deviation, and charts such as box plots and scatter plots.

  • Variables, individuals...

  • Describing one qualitative variable: frequencies, mode, pie charts...

  • Describing one quantitative variable: mean, standard deviation, box plot...

  • Describing the link between two qualitative variables: cross tabulation.

  • Describing the link between one quantitative variable & one qualitative variable

  • Describing the link between two quantitative variables: scatter plot


Produced by Addinsoft, directed by Jean-Paul Maalouf
PRESENTATION MATERIAL


Exploring and clustering data with XLSTAT

1 hour
Exploratory statistics allow summarizing information contained in datasets of various volumes using dimension-reduction and segmentation features.

  • Reminder: Variables, Individuals, Descriptive Statistics

  • Exploring & Clustering data

  • Exploring data: Principal Component Analysis (PCA)

  • Clustering data: Agglomerative Hierarchical Clustering (AHC)

Produced by Addinsoft, directed by Jean-Paul Maalouf
PRESENTATION MATERIAL


Statistical testing with XLSTAT

1 hour
Statistical tests allow taking decisions on rejecting or not predefined hypotheses.

  • Data description & exploration: reminder

  • Statistical tests: principles, steps, comparing two means

  • Parametric vs. non-parametric tests

  • Statistical tests: Comparison vs. Association

  • Testing the association between 2 qualitative variables

  • Testing the association between 2 quantitative variables

  • Appendices: interpreting p > alpha; independent vs. paired samples


Produced by Addinsoft, directed by Jean-Paul Maalouf
PRESENTATION MATERIAL



Statistical modeling with XLSTAT

1 hour
Statistical modeling allows investigating how variables change according to other variables, and to make predictions.

  • Reminder: Statistical Testing

  • Statistical modeling: an intuitive introduction

  • Simple Linear Regression

  • Assumptions about residuals

  • Multiple Linear regression

Produced by Addinsoft, directed by Jean-Paul Maalouf
PRESENTATION MATERIAL


Analysis of Variance - ANOVA with XLSTAT

1 hour
ANOVA is a popular statistical modeling feature. It is used to explain dependent quantitative variables using one or several qualitative explanatory variables called factors.

  • Reminder: Statistical Testing and Statistical Modeling

  • What is Analysis of Variance or ANOVA?

  • Assumptions about residuals

  • Multiple Pairwise comparisons

  • The Kruskal-Wallis test: a non-parametric equivalent for the 1-way ANOVA

  • 2-way ANOVA & interaction effect


Produced by Addinsoft, directed by Jean-Paul Maalouf
PRESENTATION MATERIAL


Supervised Machine Learning and Prediction with XLSTAT

1 hour
This webinar will introduce you to the Supervised Machine Learning which is used to optimize predictive algorithms. Applications in Excel using the XLSTAT statistical software.

  • Reminder: Statistical Modeling

  • What is Machine Learning?

  • The process of Supervised Machine Learning

  • Cross Validation of a linear regression model

  • Regression Trees

  • Random Forests: introduction & regression example

  • Appendix: Random Forests - building a tree

Produced by Addinsoft, directed by Jean-Paul Maalouf
PRESENTATION MATERIAL


Deploying an R procedure in Excel using XLSTAT-R

1 hour
XLSTAT-R is a revolutionary interface designed to use and write R procedures within XLSTAT dialog boxes in Microsoft Excel®. It has two principal audiences:

  • Coders able to write XML and R code to generate XLSTAT dialog boxes calling the R engine from Excel;

  • Statisticians who take advantage of the XLSTAT-R dialog boxes to call R procedures from Excel without needing to code.


Produced by Addinsoft, directed by Jean-Paul Maalouf
Presentation PDF (1 February 2018) ; XML source code (1 February 2018)

Was this article useful?

  • Yes
  • No