Free Data Analysis Webinars

 

Overview

Learn Data Science and Data Analysis with our XLSTAT webinars. This article lists the recordings of our past webinars presented in English. Recordings in other languages are available on dedicated pages:

• Free Data Analysis Webinars – French / Webinaires en français

• Free Data Analysis Webinars – Spanish / Webinars en español

 

Getting Started

Getting started with XLSTAT

30 min - English - Produced by Addinsoft - Presented by Thalia Anagnostou
Learn all the basics of XLSTAT, from data importation to output customization, using concrete examples.

 

Tips & Tricks

30 min - English - Produced by Addinsoft - Presented by Thalia Anagnostou
We’ve gathered our best XLSTAT tips & tricks for you in this video!

 

---

 

Learn Data Science

A progressive series covering the essentials of data science, from describing data to machine learning and R integration.

 

Describing Data

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar introduces descriptive statistics, which summarize datasets using simple indicators like the mean and standard deviation, along with charts such as box plots and scatter plots.
After covering the basics (variables, individuals), it explains how to describe a single variable, whether qualitative (frequencies, mode, pie charts) or quantitative (mean, standard deviation, box plot). It then examines the links between two variables: two qualitative variables through cross tabulation, a quantitative and a qualitative variable, and two quantitative variables using scatter plots.

 

Exploring and Clustering Data

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar introduces exploratory statistics, which summarize the information contained in datasets of various sizes using dimension-reduction and segmentation techniques.
After a reminder on variables, individuals, and descriptive statistics, it explains how to explore and cluster data, focusing on Principal Component Analysis (PCA) for exploration and Agglomerative Hierarchical Clustering (AHC) for segmentation.

 

Statistical Testing

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar introduces statistical tests, which help decide whether to reject a predefined hypothesis.
After a reminder on data description and exploration, it covers the principles and steps of statistical testing through the comparison of two means, the distinction between parametric and non-parametric tests, and the difference between comparison and association tests. It then shows how to test the association between two qualitative variables and between two quantitative variables, before closing with appendices on interpreting p > alpha and distinguishing independent from paired samples.

 

Statistical Modeling

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar introduces statistical modeling, which examines how variables change in relation to others and enables predictions.
After a reminder on statistical testing, it offers an intuitive introduction to modeling, then covers simple linear regression, the assumptions about residuals, and multiple linear regression.

 

Analysis of Variance (ANOVA)

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar covers ANOVA, a popular statistical modeling technique used to explain a quantitative dependent variable using one or several qualitative explanatory variables called factors.
After a reminder on statistical testing and modeling, it introduces the principles of analysis of variance, the assumptions about residuals, and multiple pairwise comparisons. It then presents the Kruskal-Wallis test, a non-parametric equivalent of the one-way ANOVA, before concluding with two-way ANOVA and interaction effects.

 

Supervised Machine Learning and Prediction

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar introduces supervised machine learning, used to optimize predictive algorithms, with applications in Excel using the XLSTAT statistical software.
After a reminder on statistical modeling, it explains what machine learning is and how the supervised machine learning process works. It then covers the cross-validation of a linear regression model, regression trees, and random forests, illustrated with a regression example, before closing with an appendix on building a tree within a random forest.

 

Deploying an R Procedure in Excel using XLSTAT-R

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar introduces XLSTAT-R, an interface designed to use and write R procedures within XLSTAT dialog boxes in Microsoft Excel®.
It targets two main audiences: coders who can write XML and R code to generate XLSTAT dialog boxes that call the R engine from Excel, and statisticians who use the existing XLSTAT-R dialog boxes to run R procedures from Excel without any coding.

Presentation PDF (1 February 2018) ; XML source code (1 February 2018)

 

---

 

Statistics in Practice: ANOVA & Descriptive Statistics

 

Tips & tricks for ANOVA in XLSTAT

45 min - English - Produced by Addinsoft - Presented by Valentin Bartkowiak
The Analysis of Variance (ANOVA) is among the most popular features of XLSTAT. We will teach you how to use some of its most useful options and interpret their corresponding outputs to get powerful and significant insights from your data.

 

Tips & tricks for Descriptive Statistics in XLSTAT

40 min - English - Produced by Addinsoft - Presented by Thalia Anagnostou
Descriptive Statistics is among the most popular features of XLSTAT. We will teach you how to use its numerous options and outputs to describe a large number of quantitative and qualitative variables with a few clicks.

 

Testing Mediating and Moderating Effects Using the Process Macro

50 min - English - Produced by Lumivero - Presented by Renaud Lunardo
Because most social & business research involves testing mediating and/or moderating effects (and even moderated-mediation), this seminar shows how the Process macro can easily and usefully help researchers test such effects. The emphasis is first on the theoretical rationale for these effects, and importantly, on how to conduct the analyses and report the results.

 

---

 

Sensory Data Analysis & Consumer Research

 

Sensory data analysis – Part 1: Evaluating differences between products

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
An introduction to common difference methods such as sensory discrimination tests and sensory product characterization.

 

Sensory data analysis – Part 2: Relating preference to sensations

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar presents a few popular tools used for this purpose, such as Preference Mapping (PREFMAP), CATA data analysis, and Penalty Analysis.

 

Gain Confidence when Presenting your Quantitative Results

45 min - English - Produced by Lumivero - Presented by Iván Méndez
When results are expected to be delivered "for yesterday", it is essential to take the time to review our database and better understand our research. Today’s tools let us validate our information quickly and efficiently. In this webinar, we review descriptive sensory research.

 

Medical Data Analysis

 

Medical data analysis – Part 1: Introduction and basic tests

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
This webinar presents several descriptive statistical tools as well as some common statistical tests used with data from study designs.

 

Medical data analysis – Part 2: Multivariate approach and Survival analysis

1 hour - English - Produced by Addinsoft - Presented by Jean-Paul Maalouf
An introduction to both types of approaches.

 

Text Mining

 

Exploring the World of Text Mining with XLSTAT

1 hour - English - Produced by Lumivero - Presented by Valentin Bartkowiak
Unlock the full potential of text mining with this engaging webinar. From cleaning text data and extracting features to creating word clouds and performing sentiment analysis, you will gain a comprehensive understanding of the essential techniques and best practices for harnessing insights from your textual data with XLSTAT.

 

 

See more content on the XLSTAT YouTube channel