Learn how to design experiments and how to perform the correct analyzes with your experimental data. In this training we show you how to do that in Excel. Thus, you do not need to learn a new complex software but can use the tools you are already used to.

You should join this training if you are a chemical- / process- or bioengineer / natural scientists who is responsible for experimental planning, optimization or quality assurance and need to know the right tools to do that.

Among other things it will cover the following topics:

IntroductionLearn how to perform different calculations (e. g. scalar and matrix calculations) in Excel
Learn other basics from data preprocessing and how to use the Solver in Excel
Basic statistical conceptsData exploration
Hypothesis testing (F-test, t-test, ANOVA & Co.)
Data modelling and prediction (linear and non-linear regression analysis)
Multivariate data analysisMultivariate calibration
Principal component analysis and regression
Cluster analysis and distance-based classifications (k-next-neighbors etc.)
Support-vector machine classification
Introduction to artificial neural networks
Design of experiments (DoE)Introduction to various kinds of experimental designs
Factor effects, Regression analysis, Significance of effects and coefficients
Response surface modelling and analysis
Simplex optimization
Content of the training course ‘Data Analysis in Excel for chemical engineers and bioengineers’.

Are you interested? Get a quote here: