Webinar-Aufzeichnungen
Latest webinars on Sensory and Medical data analysis:
WEBINAR: Sensory data analysis - Part 1 - Evaluating differences between products
WEBINAR: Sensory data analysis - Part 2 - Relating preference to sensations
WEBINAR: Medical data analysis - Part 1 - Introduction and basic tests
WEBINAR: Medical data analysis - Part 2 - Multivariate approach and Survival analysis
Table of contents of available webinars to Learn Data Science with XLSTAT:
WEBINAR #1: Describing Data - Learn Data Science with XLSTAT
WEBINAR #2: Exploring and clustering data - Learn Data Science with XLSTAT
WEBINAR #3: Statistical testing - Learn Data Science with XLSTAT
WEBINAR #4: Statistical modeling - Learn Data Science with XLSTAT
WEBINAR #5: Analysis of Variance - ANOVA - Learn Data Science with XLSTAT
WEBINAR #6: Supervised Machine Learning and Prediction - Learn Data Science with XLSTAT
WEBINAR #7: Deploying an R procedure in Excel using XLSTAT-R
This article lists the most recent XLSTAT elearning Statistics webinar recordings along with the data and the presentations files.
The data used are the same for all sessions.
WEBINAR #1 : Describing Data - Learn Data Science with XLSTAT
Describing Data - 1 hour
Descriptive statistics allow to summarize 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 | |
---|---|
WEBINAR #2 : Exploring and clustering data - Learn Data Science with XLSTAT
Exploring and clustering data - 1 hour
Exploratory statistics allow to summarize 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 | |
---|---|
WEBINAR #3 : Statistical testing - Learn Data Science with XLSTAT
Statistical testing - 1 hour
Statistical tests allow to take 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; independant vs paired samples
Produced by: Addinsoft Directed by: Jean-Paul Maalouf PRESENTATION MATERIAL | |
---|---|
WEBINAR #4 : Statistical modeling - Learn Data Science with XLSTAT
Statistical modeling - 1 hour
Statistical modeling allows to investigate 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 | |
---|---|
WEBINAR #5 : Analysis of Variance - ANOVA - Learn Data Science with XLSTAT
Analysis of Variance - ANOVA - 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 | |
---|---|
WEBINAR #6 : Supervised Machine Learning and Prediction - Learn Data Science with XLSTAT
Supervised Machine Learning and Prediction - 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
Produit par : Addinsoft Présenté par : Jean-Paul Maalouf PRESENTATION MATERIAL | |
---|---|
WEBINAR #7: Deploying an R procedure in Excel using XLSTAT-R
Deploying an R procedure in Excel using XLSTAT-R - 1 hour - English.
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.
Produit par : Addinsoft Présenté par : Jean-Paul Maalouf Presentation PDF (1 February 2018) XML source code (1 February 2018) | |
---|---|
War dieser Artikel nützlich?
- Ja
- Nein