Visualization of Lab Data with Excel

Register
01

Next Date

Mon/Tue, 2-3/11/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 working in a lab or with large datasets, but are unsure how to visualize your data effectively? This course will provide you with an introduction to statistical methods. It is designed for anyone who has little or no prior statistical experience and aims to start analysing his own data confidently.

What Are You Going to Learn?

You will learn how to identify and understand relationships within your data. The course covers simple and generally applicable data representation methods, ensuring that you understand their correct application and interpretation. Common basic statistical terms are furthermore explained. All methods are applied using Excel, with the option to use validated EasyStat macros for added convenience, in particular in the context of numerous exercises.

Who Should Attend?

  • Lab technicians and supervisors, chemists, engineers

  • Everyone working with Excel and wishing to analyse data

  • Excel experience is an advantage but not essential

  • No previous statistical or mathematical knowledge necessary

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?

Techniques for One Variable

  • Stem-and-leaf diagram

  • Histogram

  • Mean, median

  • Standard deviation, variance, range

  • Boxplot

  • Statistical distributions, normal distribution

  • Confidence interval (basic ideas)

  • Quantile plot

  • Simple control chart

Techniques for Two Variables

  • Scatter plot

  • Correlation

  • Linear regression (introduction)

Further Recommendations

  • Pareto diagram

  • Ishikawa diagram

  • Stratification

Registration Form – Visualization 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.