Schulung & Webinare

Interested in the most commonly used statistical methods? This course is for anyone who needs to learn the basics of statistical methods 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