On Demand

Excel Basics for Statistical Analysis of Laboratory Data

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

On Demand
1 Module
Each Module
$199
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
  • ANOVA
  • 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.

On Demand

Online

Standard Member $199 Non-Member $199
Become a member during registration
- Less Details+ More Details

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.

To complete your registration, you will be asked to log in using your ACS ID. If you are not already logged in, you may enter your credentials or create an ID from the next screen.

Log in or Register Now

About the Instructor(s)

Masha Petrova

CEO, MVP Consulting Solutions

Dr. Masha Petrova is founder and CEO of MVP Consulting Solutions, a company focused on bridging the gap between technical experts, marketing and sales, and customers. She received her Ph.D. in combustion chemistry from the University of California, San Diego.

On Demand
1 Module
Each Module
$199
Registration Info