# Visualization of Lab Data with Excel

**Tue/Wed, 28-29/4/2020**
The training session gives an elementary introduction to the use of statistical methods. The simplest but generally applicable data representation tools are described. The emphasis is on graphical techniques. Practical examples are included using the Excel macros EasyStat.

No knowledge in statistics or in Excel required.

**What would you learn ?**You will learn how to recognize and understand relationships existing within your data. The course gives an elementary introduction to the use of statistical methods. The simplest but generally applicable data representation methods are shown, together with their correct application and interpretation. These include Histograms, Boxplots, Quantile plots, Scatter Diagrams and Correlation. Other techniques such as linear regression and control charts are briefly mentioned. Graphical methods are emphasized. Basic statistical terms in common use are explained, e. g. Means, Standard deviation, Normal distribution etc. The different methods are applied using Excel and Excel macros ( EasyStat ).

**Who should attend ?** - Lab technicians and supervisors, chemists, engineers
- Everyone working with Excel and wishing to analyze data
- Excel experience is an advantage but not essential
- No previous statistical or mathematical knowledge necessary

**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 |

| Scatterplot Correlation Linear regression (introduction) |

Recommendations for other applications |

| Pareto diagram Ishikawa diagram Stratification |

**Any questions ?** - Course duration: 2 days

- Participants: 4-12 (one PC per participant)
- Costs: including complete course documentation, coffee and lunch: see registration form
- Dates: see registration form
- Further information: see contact page