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:
| Introduction | Learn 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 concepts | Data exploration Hypothesis testing (F-test, t-test, ANOVA & Co.) Data modelling and prediction (linear and non-linear regression analysis) |
| Multivariate data analysis | Multivariate 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 |
Are you interested? Get a quote here: