AICOS News
23.02.2020
AICOS Technologies at PCH Meetings 2020 in Lyon
News PCH Lyon March, 2020
más
05.01.2020
Datos de primavera cursos en línea !
La agenda de cursos para la primera mitad del año...
más
26.01.2011
News
más
Búsqueda
Cursos

# Visualization of Lab Data with Excel

Tue/Wed, 28-29/4/2020

# Disculpe las molestias, la página solicitada no está disponible en español.

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 ?