Dear MVP Readers,

I am so excited to announce my first set of On-demand short courses for ACS!!  Seeing a huuuuge need for practical knowledge of statistical data analysis for science/engineering professionals (see previous post), I’ve created 2-4 hour course modules that can be viewed on your own time, and will leave you with a much better understanding of how to best analyze your experimental or computer modeling data.

The courses that are now available on the American Chemical Society website are:

Introduction to Statistical Analysis of Laboratory Data -

Understand the fundamentals of statistical treatment of laboratory data and learn how to solve basic data analysis problems with the help of Excel.

• Introduction to Statistics and MS Excel
• Measurement
• Calibration and traceability
• Why do we need data analysis?
• Three types of error
• Accuracy and precision
• Significant figures
• Population and Sample
• Mean, Variance and Standard Deviation

Advanced Statistical Analysis - Hypothesis Testing and ANOVA

• Determining significant Systematic Error
• Testing Variances
• Hypothesis Testing
• One way ANOVA
• ANOVA in Excel
• Least Significant Difference
• Sampling
• Multi-way ANOVA

Introduction to Statistical Calibration of Laboratory Methods

• Understand the linear calibration model
• Learn to estimate the uncertainties in the calibration parameters
• Learn to perform calibration calculations in Excel
• Calculate parameters and uncertainties in the standard addition method
• Calculate the detection limits from measurements of blanks and uncertainties of the calibration method

Excel Basics for Statistical Analysis of Laboratory Data

• Introduction to MS Excel
• 12 Hands-on Excel Examples Covering:
  • Mean, Variance and Standard Deviation
  • Calculating confidence Intervals
  • Normal distribution testing
  • Test for an outlier
  • Determining significant systematic error
  • Hypothesis Testing
  • Systematic Error
  • Testing Variances
  • One way ANOVA
  • Least Significant Difference
  • Sampling
  • Two-way ANOVA
  • Linear calibration model
  • Standard addition model
  • Limits of detection

Through a combination of lectures and problem-solving sessions, these On-Demand module will teach statistical techniques you can put to immediate use in your workplace. Example Excel files demonstrated in these modules will be available for you to download.

My live on-line courses in Statistics and Chemical Kinetics are starting on Sept. 15th 2011. To register visit:

Essentials of Chemical Kinetics

Introduction to Statistical Analysis of Laboratory Data

Hope to have you as a student this fall!

Cheers,

Masha