d e f es 
AICOS News
05.01.2020
Datos de primavera cursos en línea !
La agenda de cursos para la primera mitad del año... 
más Linie
Búsqueda
Go
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 ?
powered by Swisscom AG
c