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 JeanPaul 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 JeanPaul 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 JeanPaul Maalouf
PRESENTATION MATERIAL
Exploring and clustering data with XLSTAT
1 hour
Exploratory statistics allow summarizing information contained in datasets of various volumes using dimensionreduction 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 JeanPaul 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. nonparametric 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 JeanPaul 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 JeanPaul 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 KruskalWallis test: a nonparametric equivalent for the 1way ANOVA

2way ANOVA & interaction effect
Produced by Addinsoft, directed by JeanPaul 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 JeanPaul Maalouf
PRESENTATION MATERIAL
Deploying an R procedure in Excel using XLSTATR
1 hour
XLSTATR 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 XLSTATR dialog boxes to call R procedures from Excel without needing to code.
Produced by Addinsoft, directed by JeanPaul Maalouf
Presentation PDF (1 February 2018) ; XML source code (1 February 2018)
Was this article useful?
 Yes
 No