This 5 days course is designed to understand the fundamentals of statistical treatment of laboratory data and learn how to solve basic data analysis problems with the help of Excel. Through a combination of lectures and problem solving sessions, this On-Demand module will teach statistical techniques you can put to immediate use in your workplace.
Upon successful completion of this course, the delegates will be able to:
- Reduce the number of measurements required for certain applications
- Enhance your ability to extract more meaningful data from your experimental data sets
- Reduce the number of measurements required for certain applications
- Learn useful and unambiguous recipes for analyzing data
- Gain confidence in the use of basic statistical methods
- Learn how to best utilize MS Excel functions to analyze experimental data
- Improve your decision-making abilities
- Understand the language of data statistics
- Learn new ways to look at data
Day 1
- Introduction to Statistics and MS Excel
- Measurement
- Calibration and traceability
- Why do we need data analysis?
- Three types of error
Day 2
- Accuracy and precision
- Significant figures
- Population and Sample
- Mean, Variance and Standard Deviation
- Measurement
- Accuracy And Precision
- Standard Deviation
- Decisions
- Confidence Intervals
- Statistical Samples
- Means
Day 3
- Standard Deviations
- Student’s t
- Statistical Testing
- Values And Power
- Algebra And Logic
- Hypothesis Testing
- Pooling
- Formal Statistical Tests
- One-Sample t Test
- Two-Sample t Test
Day 4
- Paired t Test
- Fisher’s F Test
- One-Way ANOVA
- Outliers
- Central Limit Theorem
Day 5
- Sensitivity
- Selectivity
- Limit Of Detection
- Minimum Detectable Amount
- Limit Of Quantization
This course is intended for all laboratory technicians, scientists, engineers, laboratory managers, R&D managers, manufacturing and production managers, and others who need to understand statistical methods for data analysis. This course is suitable for your professionals who does not previous knowledge of statistics.