Analysis of Lab Data with Excel

Register
01

Next Date

Tue/Wed, 1-2/12/2026

icon-02

Participants

3 - 12 

icon-01

Duration

2 Days

01

Course Form

online, classroom in Basel or in-house ℹ

In-house training = tailored course contents

Our statistics courses are also available in form of in-house trainings (in English, German or French), either online or on-site. Selected topics of our standard offer can then be combined and, if desired, extended, to specify your ideal course contents. Moreover, the practical PC-based exercises can be based on your data, which facilitates very much the application of the methods learnt after the training.

The participants acquire exactly the knowledge they need to support their daily work.

Take profit of our 25 years’ experience in coaching such trainings! Just contact us for more information or a precise offer.

Trainer:
Trainer: Dr. Philippe Solot

He has over 25 years of experience in the application of statistical methods in the process industry. He has coached many training sessions on various topics, including the visualization and analysis of lab data with Excel. His wide practical knowledge allows him to make even complex concepts easily understand­able by participants.

Dr. Solot holds an M.Sc. and a Ph.D. in Applied Mathematics, both from the EPFL (Swiss Federal Institute of Technology, Lausanne).

Course Description

Are you interested in interpreting, evaluating and guaranteeing the quality of your laboratory results, for instance in an analytical context? This course will provide you with an overview of key concepts and methods required for such data analyses, e.g. for method validation. It is aimed at scientists who have basic statistical knowledge at the level of “Visualization of Lab Data with Excel” or equivalent know-how, as well as elementary Excel skills.

What are you going to learn?

This 2-day course bridges theory and practice by focusing on practical applications. Participants will work with data visualization, modelling, and validation techniques which are all applied directly in Excel and enhanced by the validated EasyStat macros. Exercises based on real-life examples constitute an important part of the class, ensuring that you gain experience in analysing and validating laboratory data.

Who should attend?

  • Lab technicians and supervisors, chemists, engineers

  • Elementary statistical knowledge is assumed (as provided in "Visualization of Lab Data with Excel")

  • Basic knowledge of Excel is essential

Course Fees

  • CHF 795.- per day + 8.1% VAT (incl. course documents and individual participant coaching during the practical exercises) for online courses
  • CHF 865.- per day + 8.1% VAT (incl. course documents, individual participant coaching during the practical exercises, break refreshments and lunch) for classroom courses.

Which topics are covered?

Basic Concepts

  • Simple graphical representation of results (histogram & boxplot)

  • Confidence interval for the mean

  • Applications in validation (accuracy, trueness and precision)

  • Outliers and outlier tests

Comparison of Samples (Series of Measurements)

  • Graphical comparisons (parallel boxplots)

  • Statistical tests for the difference between two samples

  • Analysis of variance for the comparison of several samples

Inter-Laboratory Experiments

  • Repeatability and reproducibility of measurement methods

  • Variance component analysis in the evaluation of inter-laboratory trials

Linear Regression

  • Fitting a straight line

  • Confidence intervals for slope and intercept

  • Goodness of fit and residual analysis

  • Transformations to achieve linearity

  • Prediction and calibration

  • Regression through the origin

Registration Form – Analysis of Lab Data with Excel
Title
CONFIRMDATA1
CONFIRMDATA2

Questions about Data Analysis or EasyStat?

We are always at your disposal if you have any questions. Simply call us on +41 61 686 98 77 or use the Contact Form.