Trainings & Webinars

Addinsoft organizes public (inter-company) and private (intra-company) sessions for all levels. You can register to one of our scheduled courses or contact us for a customized training course. All of our courses are available in virtual classrooms.

Statistics & Multivariate analysis with XLSTAT, Virtual class: December 5-7 2022 (French)

Attend this course directly over the internet without having to travel. You will learn the basics of descriptive statistics, multivariate data analysis (PCA, CA, AHC), statistical modeling (ANOVA, regression), statistical tests (parametric and nonparametric) as well as machine learning techniques. All of those essential features will be illustrated using the XLSTAT Basic+ solution. 

Language

FRENCH

LOCATION

ONLINE

price

€1,300.00
per participant

Dates

From
to

hours

From
to
CET

duration

5 DAYS
21H

Documents

arrow down

Introduction to statistics and multivariate analysis with XLSTAT-Basic+

This course covers the most commonly used data analysis methods in a wide variety of fields, including research, biostatistics, marketing, sensometrics, finance and industry. The methods are illustrated with numerous examples and implemented in XLSTAT Basic+, with an in-depth interpretation of the results. Participants will have time to practice on real data provided by the instructor. At the end of the course, participants should be able to quickly find and implement appropriate statistical methods to answer their own data-related questions using XLSTAT Basic+.

Main topics covered in this training:

  • Descriptive statistics
  • Exploratory statistics
  • Statistical tests
  • Statistical modeling 
  • Machine learning

Required experience:

Trainees must have:

  • Basic experience using Microsoft Excel

Syllabus:

Introduction

  • A few definitions: individuals, variables, sample, population
  • Preparation of a dataset for analysis

Univariate, and bivariate descriptive statistics

  • Quantitative variables: mean, standard deviation, variance, median, quartiles, histograms, box plots, scatter plots
  • Categorical variables: sorting, mode, bar chart, crosstabs

Multivariate exploratory statistics

  • Reducing dimensionality: Principal Component Analysis, Correspondence Analysis
  • Clustering data: Hierarchical Ascending Classification, k-means

Statistical tests

  • Null hypothesis significance testing & p-values
  • Parametric vs. non-parametric tests
  • Comparison & association tests

Statistical modeling

  • Linear regression 
  • One-way ANOVA and multiple comparisons 
  • 2-way ANOVA

Machine learning

  • Introduction to supervised and unsupervised Machine Learning

TRAINER PROFILES


Jean-Paul Maalouf

Senior statistics consultant

Jean-Paul-Maalouf_XLSTAT_Trainer.png

Jean-Paul Maalouf is a senior statistics consultant who joined the Addinsoft team in 2014. He holds a PhD in biology and has extensive experience in teaching statistics, which he has been doing intensively since 2012. He has taught at the largest French research institutions (INRA, CNRS, INSERM, CIRAD, several universities), as well as at private companies around the world. His teaching methods are based on a conceptual approach and are more focused on concrete examples than on the explanation of complex mathematical formulas. The concepts are thus easily grasped by people who do not necessarily have a background in mathematics but wish to become quickly operational in the field of data analysis.

Qualiopi quality certification

The quality certification has been delivered for the following category of action:

Training actions