On-Demand Excel Basics for Statistical Analysis of Laboratory Data

Improve your ability to write clear, concise, and readable technical reports.

Pricing: USD 199
Duration: 1–2 hours
Registration Info

About the Course

Learn how to quickly set up Microsoft Excel spreadsheets for analysis of your own experimental data. We’ll walk step-by-step through 12 Excel spreadsheets that will cover a number of introductory and advanced topics in statistical analysis. Sample Excel files will be available for you to download.

  • Mean, Variance and Standard Deviation
  • Hypothesis Testing
  • Systematic Error
  • Linear calibration model
  • Standard addition model
  • Limits of detection

What You Will Learn

  • 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 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

Who Should Attend

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 assumes some knowledge of statistics (i.e., familiarity with standard deviation, normal distribution, hypothesis testing, ANOVA, and linear calibration methods). You should also have basic computer literacy.

Access to MS Excel is preferred but not required.

Course Outline

  • Introduction to Microsoft 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

Dates, Locations, and Prices

On Demand course modules can be purchased a la carte for $199, each. All modules are held on a rolling basis throughout the year to accommodate your schedule and budget.


Early Bird Full Price
Member(Premium Package) $199
Member or Associate(Standard or Basic Package) $199
Non-Member $199

The registration fee includes seven days of access to the content, lecture slides (provided in PDF format), and email access to the instructor. Each person attending must register individually for this course.