Statistical Process Control (SPC) Using Microsoft Excel from Udemy

Statistical Process Control (SPC) Using Microsoft Excel is the one course you need to learn how to harness, analyze and report your manufacturing process data in a way that drives improvement within your organization. This course is divided into 4 major sections:

Basic Statistical Concepts: Don't worry if you've never studied statistics or are a novice using Excel. This course starts at the beginning. In this section, I explain fundamental concepts that you will use throughout this course and your career including Measures of Central Tendency, Measures of Dispersion and the different types and scales of data. Not only do I explain these concepts "on paper", but I'll take you into Excel and show you how to QUICKLY calculate the statistics you need.

Pareto Analysis: Most people do not realize the power of the Pareto Distribution. In this section, I will show you how to apply the so called "80/20 Rule" in remarkably expedient and innovative ways. I will also introduce you to Excel's Pivot Tables, which when combined with Pareto Analysis, form a powerful decision making tool for allocating your organization's capital, people and improvement effort.

Control Charting: Often considered the backbone of statistical process control, control charting allows you to graphically depict and then analyze your process and quality data. Control charting calculates the normal limits for any process, then makes obvious the trends and nuances in your process. Not only will I explain the "nut and bolts" of 7 different control charts for both variable and attribute data, but I will also walk you through the secrets of interpreting their results. You will also receive excellent reference tools and Excel reports you can use in your own improvement projects.

Regression Analysis: Regression Analysis is a remarkably powerful tool for defining the relationship between two or more variables, and then providing a formula you can use to make predictions about your own process. This section offers you the fundamentals of this immense family of statistical processes by detailing Simple Linear and Multiple Linear Regression analysis. These tools will not only allow to you analyze the inputs and outputs of your manufacturing processes, but also serve as a stepping stone into more advanced studies of the topic.

In this course, I provide you with all the theory, applications, Excel Worksheets and real life examples you need to take your analytical and problem solving skills to a whole new level.

And if you're preparing to take your ASQ Certified Quality Engineer, Certified Quality Technician, Certified Six Sigma Green Belt, Certified Six Sigma Black Belt exams, this class is an excellent starting point to develop the quality statistics skills you'll need to succeed.

"This course is best out there for any quality professional who wants to excel." - Sachin K.

"This is buy far the best Course I have taken on Udemy. Very well structured and provided a comprehensive overview on the subject. A gem on Udemy. " - Greg S.

What's inside

Learning objectives

Basic statistical concepts
Statistical process control, spc
Pareto analysis
Variable and attribute control charting
Process capability analysis

Linear and multiple regression analysis
Correlation and excel’s correlation matrix
Quality engineering statistics within microsoft excel
Key concepts of quality engineering and quality management

Basic statistical concepts
Statistical process control, spc
Pareto analysis
Variable and attribute control charting
Process capability analysis
Linear and multiple regression analysis
Correlation and excel’s correlation matrix
Quality engineering statistics within microsoft excel
Key concepts of quality engineering and quality management

Syllabus

Introduction

An introduction to this course and it's four section: Background Statistics and Terminology, Pareto Analysis, Control Charting and Regression Analysis.

What is SPC?

Types of Data

Data Scales

Probability Distributions

Central Limit Theorem

Comments on the Normal Distribution

Measures of Central Tendency

Measures of Central Tendency in Excel

Measures of Dispersion

Measures of Dispersion in Excel

Quick Quiz on Basic Statistical Concepts

Use the Excel formulas you learned in this lesson to calculate the summary statistics at the bottom of the first worksheet. The solutions are on the second worksheet.

Pareto Analysis

Introduction to Pareto Analysis

Histograms

Ordered Histograms

An Introduction to Pivot Tables

The Pareto Diagram

Pareto Analysis, Part 1

Pareto Analysis, Part 2

Pareto Analysis, Part 3

Quick Quiz on Pareto Analysis

Pareto Analysis, Practice Problems and Worksheets

Introduction to Control Charting

Control Chart Terminology

X-Bar and R Chart, Part 1

X-Bar and R Chart, Part 2

X-Bar and R Chart, Part 3

X-Bar and s Chart, Part 1

X-Bar and s Chart, Part 2

Individual X and Moving Range Chart, Part 1

Individual X and Moving Range Chart, Part 2

The p Chart, Part 1

The p Chart, Part 2

The np Chart, Part 1

The np Chart, Party 2

The c Chart, Part 1

The c Chart, Part 2

The u Chart, Part 1

The u Chart, Part 2

u Chart Addendum

Interpreting Control Charts, Part 1

Interpreting Control Charts, Part 2

Interpreting Control Charts, Part 3

Quick Quiz on Control Charting

Control Charting, Excel Workbooks

Process Capability Analysis

Manufacturing Process Development, Part 1

Manufacturing Process Development, Part 2

Manufacturing Process Development, Part 3

Manufacturing Process Development, Part 4

Groundwork for Process Capability Analysis

Measurement Systems, Part 1

Measurement Systems, Part 2

Sampling Options, Part 1

Sampling Options, Part 2

The Normal Distribution and Sampling Size

Arithmetic Mean

Standard Deviation

Building Histograms

Data Analysis Add-in For Excel

The Normal Distribution, Part 1

The Normal Distribution, Part 2

Skew and Kurtosis

Plotting the Distibution

Pp and Ppk, Part 1

Pp and Ppk, Part 2

Pp and Ppk, Part 3

Pp and Ppk for a Sample

The Run Chart Explained

Cp and Cpk, Part 1

Cp and Cpk, Part 2

Interpreting Capability Indices, Part 1

Interpreting Capability Indices, Part 2 (The Difference between Cpk and Ppk)

Interpreting Capability Indices, Part 3

Interpreting Capability Indices, Part 4 (DPPM)

SPC versus PCA

Quick Quiz on Capability Analysis

Capability Analysis, Excel Workbooks

Regression Analysis

An Introduction to Regression Analysis

Correlation

The Correlation Matrix

Excel's Trendline Feature

The Equation of a Line

Interpreting the Regression Line

Minimizing the Residuals

Excel's Goal Seek

Regression Analysis Output

Using Confindence Intervals

Multiple Regression Case Study

Regression Analysis Excel Workbook

Closing Comments on Course

Bonus Lecture

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Delves into the nitty-gritty of statistical process control and boosts learners' analytical and problem-solving skills

Tailor-made for professionals, like quality engineers, quality technicians, and Six Sigma practitioners, looking to solidify their quality statistics skills

Conveys abstract statistical concepts with practical, real-world applications through Excel worksheets and examples

Includes supplementary materials and reference tools for learners to use in their own improvement projects

Covers a wide range of topics, from basic statistical concepts to advanced regression analysis

Provides a comprehensive understanding of SPC, equipping learners to harness and analyze manufacturing process data effectively

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Statistical Process Control (SPC) Using Microsoft Excel with these activities:

Practice Excel formulas for summary statistics

Show steps

Performing the calculations of summary statistics manually enables you to solidify your understanding of their conceptual underpinnings, and deepens your fluency with the Excel functions for performing them.

Browse courses on Summary Statistics

Show steps

Download the practice worksheet provided with the course.
Use the Excel formulas you learned in this lesson to calculate the summary statistics at the bottom of the first worksheet.
Compare your results to the solutions on the second worksheet.

Organize and review your notes, worksheets, and graded assessments

Show steps

Taking time to organize and review your materials on a consistent basis will help the course content become more familiar and progressively solidified in your mind.

Show steps

Establish a system for organizing your materials.
Go through your notes, worksheets, and graded assessments and condense them.
Review them periodically leading up to major assessments.

Create a tutorial on how to use Excel's Correlation Matrix feature

Show steps

Correlation analysis is a powerful tool for understanding relationships between variables, and Excel's Correlation Matrix feature provides a convenient way to perform this analysis.

Browse courses on Correlation Analysis

Show steps

Write a step-by-step tutorial on how to use Excel's Correlation Matrix feature.
Include screenshots and examples to illustrate your instructions.
Publish your tutorial on a blog or other online platform.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create a Pareto diagram for a hypothetical process or dataset

Show steps

The ability to visualize and analyze quality control data using industry-standard tools such as the Pareto diagram is fundamental to the role of quality engineers and specialists.

Browse courses on Pareto Analysis

Show steps

Create a hypothetical process or dataset that represents a common quality issue, such as customer complaints or production defects.
Use a free or paid online resource to generate a Pareto diagram for your data.
Analyze the Pareto diagram to identify the root cause(s) of the problem.
Write a brief report summarizing your findings and recommendations.

Practice interpreting control charts and identifying out-of-control conditions

Show steps

The ability to interpret control charts and identify out-of-control conditions is essential for ensuring the quality of manufacturing processes.

Show steps

Download the practice worksheets provided with the course.
Analyze the control charts and identify any out-of-control conditions.
Write a brief report explaining your findings.

Practice using Excel's Trendline feature to perform linear regression analysis

Show steps

Linear regression analysis is a powerful tool for understanding the relationship between two or more variables, and Excel's Trendline feature provides a convenient way to perform this analysis.

Browse courses on Regression Analysis

Show steps

Download the practice worksheets provided with the course.
Use Excel's Trendline feature to perform linear regression analysis on the data.
Write a brief report explaining your findings.

Review the book 'Statistical Process Control for Engineers' by Douglas C. Montgomery

Show steps

This book provides a comprehensive overview of statistical process control techniques and their applications in manufacturing and other industries.

View Design of Experiments for Reliability... on Amazon

Show steps

Read the book and take notes on the key concepts.
Summarize the main points of each chapter in your own words.
Apply the concepts you learned to a real-world problem or scenario.

Design and implement a control chart for a manufacturing process

Show steps

Control charting is a powerful tool for monitoring and improving manufacturing processes, and the ability to create and interpret control charts is a highly valued skill in the field.

Show steps

Identify a manufacturing process that you have access to.
Collect data from the process over a period of time.
Use the data to create a control chart for one or more quality characteristics.
Implement the control chart and monitor the process over time.
Write a report on your findings and recommendations.

Career center

Learners who complete Statistical Process Control (SPC) Using Microsoft Excel will develop knowledge and skills that may be useful to these careers:

Statistician

This course provides the foundational knowledge and skills in statistics that are essential to all statisticians. You will learn how to use SPC tools for sampling, data collection, data analysis, and statistical modeling.

See salaries and explore the career path for Statistician

Process Engineer

Process Engineers use SPC to analyze and improve manufacturing processes. This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to collect, analyze, and interpret data to identify and eliminate sources of variation, and improve efficiency and quality.

See salaries and explore the career path for Process Engineer

Six Sigma Green Belt

Six Sigma Green Belts use SPC as a core tool for process improvement. This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC to identify and eliminate sources of variation, and improve quality and efficiency.

See salaries and explore the career path for Six Sigma Green Belt

Six Sigma Black Belt

Six Sigma Black Belts use SPC as a core tool for process improvement. This course will provide you with the advanced knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC to develop and implement process control plans, and lead improvement projects.

See salaries and explore the career path for Six Sigma Black Belt

Quality Engineer

Quality Engineers use SPC to monitor and improve processes, products, and services. This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to collect, analyze, and interpret data to identify and eliminate sources of variation, and improve quality.

See salaries and explore the career path for Quality Engineer

Industrial Engineer

Industrial Engineers use SPC to analyze and improve industrial processes. This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC to identify and eliminate sources of variation, and improve efficiency and quality.

See salaries and explore the career path for Industrial Engineer

Manufacturing Engineer

Manufacturing Engineers use SPC to analyze and improve manufacturing processes. This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC to identify and eliminate sources of variation, and improve efficiency and quality.

See salaries and explore the career path for Manufacturing Engineer

Business Analyst

This course provides a strong foundation in the statistical concepts and techniques that are essential for business analysis. You will learn how to use SPC tools to collect, analyze, and interpret data to identify trends and patterns, and make informed business decisions.

See salaries and explore the career path for Business Analyst

Reliability Engineer

Statistical Process Control (SPC) is essential to the practice of reliability engineering. Understanding SPC will help you monitor processes, identify sources of variation, and predict and prevent problems. This course will equip you with the ability to use SPC tools to improve the reliability of your products and systems.

See salaries and explore the career path for Reliability Engineer

Data Analyst

This course provides a strong foundation in the statistical concepts and techniques that are essential for data analysis. You will learn how to use SPC tools to collect, analyze, and interpret data to identify trends and patterns, and make informed decisions.

See salaries and explore the career path for Data Analyst

Financial Analyst

This course provides a strong foundation in the statistical concepts and techniques that are essential for financial analysis. You will learn how to use SPC tools to collect, analyze, and interpret data to identify trends and patterns, and make informed investment decisions.

See salaries and explore the career path for Financial Analyst

Quality Assurance Auditor

This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC tools to audit quality systems and processes, and ensure that they comply with regulatory requirements.

See salaries and explore the career path for Quality Assurance Auditor

Quality Control Inspector

This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC tools to inspect products and processes, and ensure that they meet quality standards.

See salaries and explore the career path for Quality Control Inspector

Operations Research Analyst

Operations Research Analysts use SPC to analyze and improve complex systems. This course will provide you with the foundational knowledge and skills in SPC that you need to be successful in this role. You will learn how to use SPC to identify and eliminate sources of variation, and improve efficiency and effectiveness.

See salaries and explore the career path for Operations Research Analyst

Quality Assurance Manager

This course provides the foundational statistical tools for implementing, maintaining, and evaluating a Quality Assurance program. Statistical Process Control is essential for defining the inputs and outputs of a process, and optimizing it based on the interrelationships between these variables. This course will show you how to use these tools to maximize quality, minimize waste and variation, and continuously improve your quality management system.

See salaries and explore the career path for Quality Assurance Manager