Description

Statistics are essential tools in many sectors of the company to exploit numerical data and compare results. They are used to model a phenomenon, validate the relevance of differences in results between them, predict, make estimates in the future, understand the relationships between factors. This training gives you the keys and statistical tools to know how to process data by assessing the associated risks of errors.

Who is this training for ?

For whom ?

Anyone who needs to statistically process data to make comparisons and/or forecasts.

Prerequisites

Training objectives

Identify and practice statistical tools allowing estimates and comparisons of numerical data to be made.

Identify the relationships between two factors. Understand the principle of forecasting.

Training program

• Lay the foundations for statistical analysis
  • - Collect and prepare statistical data.
  • - Choose the right statistical method based on the nature of the data and the desired result.
  • - Install the statistical data utility analysis in Excel or the XLTSTAT free add-in.
• Estimate results and know how to evaluate the associated precision
  • - Estimate a mean or proportion by the confidence interval.
  • - Evaluate the precision of the result, define the minimum sample size.
  • - Define a representative sample and apply an adjustment.
• Compare numerical results with each other
  • - Comparison of means and proportions.
  • - Use hypothesis tests (Chi Square, Student, Fisher).
  • - Detect influential factors through analysis of vairiance (ANOVA with one or more factors).
  • - The risks to avoid.
• Look for the relationship between several factors
  • - Measure the relationship between several variables.
  • - Calculate the correlation matrix and plot the correlogram.
  • - Model a numerical variable by multiple regression.
• Forecast data into the future Detect and extend a trend over time. Identify seasonal phenomena.
  • - Predict exponential smoothing and interpret the prediction interval.