Course Content
Define
Identify the problem or process that needs improvement, set project goals, and outline the scope.
0/10
Six Sigma Management at Corporate Level
Six Sigma Project Team Structure
Create team roles and responsibilities
Create a Problem Statement
Create the SIPOC process map
What is CTQ (Critical to Quality)
Create CTQ Tree
Creating a Project Charter
Stakeholder Analysis
Outcome expected after the Define Stage
Measure
Collect data to establish baselines, understand current performance, and quantify the problem. For example, measuring the average turnaround time for policy renewals.
0/4
FMEA (Failure Modes and Effect Analysis) concept
Data collection methods
Introduction to data sampling
Use of Run chart for analysis
Analyze
Examine the data to identify root causes of inefficiencies or risks. This might involve analyzing claims data to uncover bottlenecks or sources of errors.
0/12
5 Whys
Root cause analysis with Fishbone Diagram
Lean 7 Wastes concept
Value chain mapping with Value Stream map
What is a process
Components of process
Process Mapping with Swimlane diagram
Process redesign principles
80/20 analysis with Pareto Diagram
Statistical analysis with Box Plot
Hypothesis Testing
Correlation and Regression Analysis
Improve
Develop and implement solutions to address root causes. For example, streamlining workflows or introducing new digital tools to reduce manual errors.
0/4
Solution Selection Matrix
Cost Benefit Analysis
Risk Assessment
Implementation Planning
Control
Put controls in place to sustain improvements, such as regular monitoring, updated procedures, or dashboards for ongoing performance tracking.
0/4
Create Control Plan
Create Key Performance Indicator (KPI)
Prepare the Process and User Guides
Handover to Process Owner
Six Sigma DMAIC (Define, Measure, Analyze, Improve, Control)

What is Correlation and Regression

Correlation and Regression are statistical concepts that help Six Sigma teams understand whether two factors within a process are related.  It can be used to calculate whether the input is related to output in some way or whether two inputs are related. To work with regression analysis, both of the variables being studied have to be in numerical format.

How to create Correlation and Regression graph in Excel

1. An example of Correlation of students Weight vs Height shows that a group of 10 students having the weight and height as tabulated in the table below.

StudentHeightWeight
166150
268145
369160
470165
570165
671180
772175
872180
973195
1075210

2. Using the example above, enter the students’ details into the Excel spreadsheet.

3. Then select the Height and Weight columns, and click on the Insert tab and select the Scatter diagram icon as shown in the screenshot below,

Scatter diagram function in Excel

4. The Scatter diagram as above will be displayed. and it shows there is correlation between students’ weight and height

Previous
Next