Objectives of the Presentation
Why Should you Attend
- 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
You receive an assignment to investigate a production process in your Quality Management System. You need to know if the process 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 help you complete the assignment. 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 helps you understand ANOVA and its use. The webinar explains the concepts of ANOVA without the statistical details and computations that often hinder understanding. The webinar skips the equations, since Excel handles these details.
Data collection is an important issue, especially avoiding bias. The solution is to randomize the data collection; the webinar explains how Excel can generate random numbers you need.
Excel's built-in set of macros will do the ANOVA work for you. The webinar explains 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, this powerful statistical technique becomes easily accessible.
Who can Benefit
This webinar is applicable to all industries, but medical device manufacturers find the techniques particularly valuable.
Attendees should include:
- Quality Engineers
- Design Engineers
- Production Engineers
- Production Supervisors
- Process Improvement Specialists
- Team Members involved in Design Changes