Excel 6-Sigma Quality Tools Part-3 - a PDH Online Course for Engineers, Surveyors and Architects

Excel 6-Sigma Quality Tools Part-3

Course Outline

This is part-3 of a two part course. This 8 PDH course includes essential Six-Sigma quality control problem solving methods applicable to the statistics and technology of the: industrial, chemical, mechanical, electrical, and production engineering disciplines. The focus is on solving basic product and process quality problems using Excel math tools.

Any value of an input parameter can be found for a target value of an Excel calculated item by using the “Goal Seek” tool in Excel.

This online course describes basic Six-Sigma quality calculations. Major topics are:

A. Basic Statistics
B. ANOVA Examples
C. ANOVA Problems
D. Quality Experiments
E. Response Surface
F. Math Tools

The course includes a multiple-choice quiz at the end, which is designed to enhance the understanding of the course materials.

Learning Objective

At the conclusion of this course the student will:

Increase knowledge of basic Six Sigma calculations;
Correlation and experimentation are compared;Apply the null and alternate hypotheses to quality problems;
Use a spread sheet to calculate: Mean values, Sigma, and Z-Score;
Full and fractional test runs are discussed;
A typical design of experiments cube plot is presented;
Analysis of Variance ANOVA is defined;
Control factors, control levels, and response parameters are analyzed;
Control factor interaction examples are provided;
Two way ANOVA tables are calculated using Excel’s spread sheet;
The null hypothesis is evaluated using the F-distribution;
Excel calculates any F-distribution value;
Two factor ANOVA with and without test run replications are calculated;
Two factor ANOVA, three level problems are solved;
Design of Experiment DOE examples are presented;
Optimizing a machining operation example is given;
Full factor number of test runs is calculated;
The, “Three Point Method” reduces the number of test runs;
A process variable response surface is illustrated;
Process variable sensitivity is analyzed;
Defects per million opportunities are calculated;
Excel’s, “Goal Seek” tool for optimizing processes is presented;
Apply analysis of variance, ANOVA to compare several sets of data values;
Plot graphs and determine, “Best Fit Equations” with Excel’s, “Chart Wizard”;
Use Excel to plot process test run results; and
Obtain several web links to Six-Sigma and DOE related WEB sites.

Intended Audience

The information will be especially useful to students, entrepreneurs, engineers, and innovators who want to update their knowledge base concerning some of the most important elements of Six sigma applied to manufacturing and process quality control.

Benefit to Attendees

Attendee of this course will be able to use Excel to design quality experiments (DOE) and optimize many product and process parameters for quality and reliability.

Course Introduction

The market place for industrial products today demands world class: innovation, improved designs, high reliability, quality, and low prices. This means rapid prototyping and production systems that are agile and able to change more rapidly. Basic industrial system quality control elements are outlined and DOE is described in this course.

Course Content

You need to download and study the following spreadsheet:

Excel 6-Sigma Quality Tools Part-3

DISCLAMER: "This spreadsheet is provided for illustrative teaching purpose only, and is not intended for use in any specific project. Anyone making use of theinformation contained in this spreadsheet does so at his/her own risk and assumes any and all resulting liability arising therefrom."

Course Summary

A brief and to the point summary of basic quality control analysis and Design of Experiments is provided in these notes and Excel spreadsheet calculations that will provide information that can be applied to real world industrial applications.

Related Links

A. Six Sigma Summary: http://en.wikipedia.com/wiki/Six_Sigma.

B. Six Sigma started at Motorola: http://www.motorola.com/motorolauniversity.jsp

C. The Six Sigma Forum offers opportunities for you to learn from other Six Sigma professionals and share your own knowledge and solutions. http://www.asq.com/sixsigma/

D. The United States Patent and Trademark Office Home Page at www.uspto.gov provides links to information about all aspects pertaining to invention patents.

Quiz

Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.

DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.