Introduction to Biostatistics with Excel

Register
01

Next Date

By arrangement

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

Do you work in biology, medicine or pharmacy and need to analyse data with statistical methods? In this course, you will learn about essential biometric methods. While no advanced skills are required, basic statistical knowledge at the level of “Visualization of Lab Data with Excel” and elementary Excel know-how are advantageous.

What Are You Going to Learn?

This course introduces key statistical methods used in biology, medicine, and pharmacy. It covers statistical distributions, basic test theory (t-test), outlier and nonparametric tests, and analysis of variance (ANOVA), including experimental design, sample size, and repeated measures. The focus is on practical data analysis and sample comparison, with minimal mathematical formalism. Hands-on exercises are performed on PC using Excel and, optionally for added convenience, EasyStat macros.

Who Should Attend?

  • Scientists in research and development who need to analyse their data with statistical methods

  • Excel and basic statistical knowledge is assumed (at least at the level of the course “Visualization of Lab Data with Excel”)

Course Fees

Standard Fees Conditions for the EU
Standard 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.
Conditions for the EU

Which Topics Are Covered?

Basics

  • Continuous statistical distributions: normal distribution, t-distribution, F-distribution and χ2-distribution

  • Confidence interval for the mean

  • Statistical test concept

  • Outliers and outlier tests

Comparison of Two Samples

  • Unpaired and paired random samples

  • Statistical tests: t-tests

  • Influence of sample size

  • Non-parametric tests: Wilcoxon-Mann-Whitney-U

Comparison of Several Samples

  • Simple variance analysis: basics

  • Variance analysis for two factors

  • Aspects of DoE: fixed-effects or random-effects

  • Multiple comparisons

  • Repeated measurements

Sample Size

  • Case of the t-test

Analysis of Contingency Tables

  • χ2-test for independence or homogeneity

  • General contingency tables

Registration Form – Introduction to Biostatistics 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.