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.

Power calculations and sample size estimation - Putting XLSTAT to work

Streamlining your statistical analyses is one of your objectives? This course will help you understand the essential steps to ensure the statistical quality of your results with XLSTAT.


1 day




arrow down

This course is intended for people who conduct hypothesis testing and who wish to master the concepts of alpha risk, beta risk, test power and required sample sizes. Beyond the statistical tools used, the course will define the best experimental design practices. Emphasis will be placed on finding the optimal sample size in order to compare means or proportions. Throughout the course, the following underlying question will be essential: "When I want to compare populations, how many (what n) values should I sample to ensure a statistical conclusion of acceptable quality?". This is a step that precedes statistical processing and is often overlooked, which can lead to erroneous conclusions in the statistical approach to comparisons. If, at the end of a hypothesis test, I cannot conclude that there is a difference between the means of two samples, is it because there is actually no difference, is it because the sample I have selected is not representative of the population or is the sample size just not optimal for me to detect it? As specified earlier, during this course, we will focus on solving the issues caused by the last reason: finding the optimal sample size in order to test a hypothesis.

Main topics covered in this training:

  • Alpha risk
  • Beta risk 
  • Power of a test
  • Confidence interval for a mean 
  • Confidence interval for a proportion
  • Comparison of means
  • Comparison of variances
  • Comparison of proportions

Required experience:

It is essential that participants have a good knowledge of basic statistical concepts: Descriptive data analysis, Confidence intervals, General hypothesis testing procedures (H0/H1, p-value), Student Tests.


General information on experimental design

  • Main goals while setting up an experiment:
    • Determining the trials to be performed
    • Determining the number of repetitions needed
    • Organizing trials within experimental constraints
    • Ensuring a relevant level of statistical quality
  • The constraints:
    • Cost constraints 
    • Logistical constraints
    • Quality requirement levels for statistical analyses
  • Control of the risks associated with experimental practice: 
    • Risk of pure experimental error
    • Statistical risk due to sampling error (alpha, beta risks)
  • Measurement error:
    • Repeatability error 
    • Reproducibility error x
  • Best sampling practices: 
    • Consequences of sampling on statistical conclusions 
    • Consequences of sampling on decisions (relevant and erroneous)

Review of the tools needed for hypothesis testing and power calculations

  • Descriptive data analysis: 
    • Measures of position 
    • Measures of dispersion 
    • Graphical tools
  • Individual value distributions: Normality
  • Difference between standard deviation and SEM
  • Confidence intervals: 
    • Of a mean
    • Of a standard deviation
    • Of a proportion proportion
  • General approach to hypothesis testing:
    • H0/H1 and real-life applications
    • P-value
    • Alpha risk
    • Decision making and risk rating
    • Statistically significant effect

Impact of alpha risk and sample size on confidence intervals 

  • Link between the alpha risk and the range of a confidence interval
  • Link between the sample size and the estimation quality of a statistical parameter
  • Explanation of a confidence interval: 
    • Of a mean
    • Of a standard deviation
    • Of a proportion

Power of a test

  • Definitions of beta risk and test power 
  • Relationship between alpha risk, beta risk and power of a test
  • Relationship between test power and detectable (or detected) delta
  • Graphical illustrations of the different relationships (alpha, beta, delta, standard deviation, n)
  • The aim depending on the context:
    • Calculate the n
    • Calculate the power 
    • Calculate the effect

Applications and implementation

  • Designing a Student-type comparison test of 2 means
  • Designing an ANOVA-type, k-means comparison test
  • Designing a comparison of proportions test such as Chi-square, or Fisher's exact


Thierry Anthouard

Statistics instructor


Thierry Anthouard is the head of the Arkesys Group's statistical training program and has always been passionate about the field of statistics. In 1992, he launched the development of the Arkesys Group's statistics training program. His "by example" pedagogical approach  allows him to popularize statistics and to make it accessible to all learners. As a consultant supporting of key accounts, he adapts to all types of contexts and learning issues. 

Jérôme-Philippe Garsi

Statistics instructor


Jérôme-Philippe Garsi is a statistical instructor with 13 years of experience in the training field. Since his doctorate on clinical issues, his work is mainly focused on the interest of populations, their health and well-being. At ease with any audience, he makes pedagogy and the simplification of scientific knowledge a priority. To do so, he always takes the greatest care to be clear in his written documents as well as in his oral presentations.