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

Excel 6-Sigma Quality Tools Part-2

Course Outline

This is part-2 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:

1. Defects
2. Data
3. Samples
4. Math Tools
5. Hypothesis
6. ANNOVA
7. Correlation

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;
Look up sigma values with Excel’s Normsdist;
Use the Excel spread sheets provided to organize statistical data;
Use Excel to estimate process parameter quality;
Understand the, "Central Limit Theorem";
Compare process run charts of differing quality;
Monitor a chemical process by taking small samples;
Calculate confidence interval of small samples and total population;
Analyze small samples using the t-distribution;
Calculate the probability of industrial processes exceeding specification limits;
Use Excel to calculate probabilities of normally distributed processes;
Use a spread sheet to calculate: Mean values, Sigma, and Z-Score;
Make numbers of defective parts calculations;
Optimize quality parameters with Excel’s, “Goal Seek”;
Calculate: sample variance, confidence level with the, “Descriptive Statistics” function;
Apply the null and alternate hypotheses to quality problems;
Determine the significance level of statistical data;
Adjust parameters to optimize a process;
Use Excel to calculate the Chi-Square distribution to compare observed and expected sample frequencies;
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 sample histograms;
Use Excel to calculate sample variance; and
Obtain several web links to Six-Sigma 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 optimize many product and process parameters for quality and reliability.

Course Introduction

The market place for industrial products today demands 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 manufacturing system quality elements are outlined in this two part course.

Course Content

You need to download and study the following spreadsheet:

Excel 6-Sigma Quality Tools Part-2

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 is provided in these notes and 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.