This training program will illustrate the underlying idea that makes ANOVA work. It will also offer an understanding of the data collection issues you should plan and how to get access to ANOVA in Excel.
This webinar will help attendees understand ANOVA and how to use it. It will explain the concept of ANOVA without the statistical details that often hinder understanding. The webinar will skip over equations, since Excel handles those details.
Data collection is an important issue, especially avoiding bias. The solution is to randomize the data collection; the webinar will explain how Excel can generate random numbers you need.
Excel’s built-in set of macros will do the ANOVA work for you. Attendees will learn how to access them, which one to use, and how to read the results. The underlying computations are complicated, but Excel handles them in the background with ease. The result gives you the information you need to help determine the effect on your process. With Excel, a powerful statistical technique becomes easily accessible.
Why Should You Attend:
You are assigned to investigate a production process in your quality management system. You need to know if it could be improved, but you don’t know how to collect and analyze the data. There is a powerful technique called Analysis of Variance (ANOVA) that will do the work for you. The solution is already in your computer; built into Microsoft Excel. You don't have to be a statistician to do the statistical analysis of your process.This webinar will help attendees understand ANOVA and how to use it. It will explain the concept of ANOVA without the statistical details that often hinder understanding. The webinar will skip over equations, since Excel handles those details.
Data collection is an important issue, especially avoiding bias. The solution is to randomize the data collection; the webinar will explain how Excel can generate random numbers you need.
Excel’s built-in set of macros will do the ANOVA work for you. Attendees will learn how to access them, which one to use, and how to read the results. The underlying computations are complicated, but Excel handles them in the background with ease. The result gives you the information you need to help determine the effect on your process. With Excel, a powerful statistical technique becomes easily accessible.
Areas Covered in the Webinar:
- The underlying idea that makes ANOVA work
- The data collection issues you should plan
- How to get access to ANOVA in Excel
- Entering the data
- Selecting among the options
- Interpreting the result
Who Will Benefit:
This webinar is applicable to all industries, but medical device manufacturers find the techniques particularly valuable. Attendees include:- Quality Engineers
- Design Engineers
- Production Engineers
- Production Supervisors
- Process Improvement Specialists
- Team Members Involved in Design Changes
Course Provider
Daniel O Leary,
