d e f es 
AICOS News
15.03.2020
Coronavirus: continuation of our activities
Independently of the coronavirus epidemic... 
more Linie
20.02.2020
AICOS Technologies at PCH Meetings 2020 in Lyon
Lyon - 25.-26.11.2020: International business... 
more Linie
05.01.2020
Our training schedule for spring / summer 2020 is on-line!
You want to deepen your knowledge in data... 
more Linie
Search
Go
Courses

Visualization of Lab Data with Excel

Tue/Wed, 28-29/4/2020 (online) or
Mon/Tue, 19-20/10/2020 (classroom)

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