Course Catalog

Excel Basics for Statistical Analysis of Laboratory Data

This module will walk you step-by-step through twelve Microsoft Excel examples that will cover a number of introductory and advanced topics in statistical analysis. By the end of this module you will be able to quickly set up Excel spreadsheets for analysis of your own experimental data. Excel files of examples, demonstrated in this module, will be available for you to download.

Course Details

Key Topics

  • 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

Information

This module will walk you step-by-step through twelve Microsoft Excel examples that will cover a number of introductory and advanced topics in statistical analysis. By the end of this module you will be able to quickly set up Excel spreadsheets for analysis of your own experimental data. Excel files of examples, demonstrated in this module, will be available for you to download.

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 (being familiar with standard deviation, normal distribution, hypothesis testing, ANOVA, and linear calibration methods). You should also have basic computer literacy. Access to MS Excel 2003 or 2007 is preferred but not required.

Benefits

  • 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

Agenda

  • 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

Course Locations

Date

TBA

This course module consists of two presentations totaling approximately 3.5 hours in length.

Register Online Register Via Mail

Venue

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.


Pricing
Standard $199 per module

About the Instructor

  • Dr. Masha Petrova

    is a founder and CEO of MVP Consulting Solutions – a company focused on bridging the gap between technical experts, marketing and sales and customers.