Page 8 - Lean six sigma demystified
P. 8
Contents vii
Take the Dominos Challenge 103
Less Inventory Means Better Care 104
How to Get a Faster Hospital in Five Days 104
Quiz 107
Chapter 4 Excel Power Tools for Lean Six Sigma 109
Setting Up Your Data in Excel 110
Data Collection and Measurement for Six Sigma 113
Mistake-Proof Data Collection 117
QI Macros Introduction 123
Fill-in-the-Blanks Templates 126
Put Your Whole QI Story in One Workbook 130
Data Transformation 130
Using ANOVA and Other Statistical Tools 133
Power Tools for Lean Six Sigma 134
Analyzing Customer Service Data Hidden in
Trouble-Reporting Systems 134
Analyzing Text with Excel 135
Troubleshooting Problems 137
Chartjunk 137
Quiz 147
Exercises 149
Chapter 5 Reducing Defects with Six Sigma 151
Control Charts, Pareto Charts, and
Fishbone Diagrams 152
Six Sigma’s Problem-Solving Process 157
Getting to Lean Six Sigma 162
Problem Solving 165
A Lean Six Sigma Case Study—Reducing
Computer Downtime 178
Six Sigma Tar Pits 184
Become a Lean Six Sigma Detective 188
Mistakes, Defects, and Errors 190
Measurement Simplicity 192
Invisible Low-Hanging Fruit 194
Core Score 195
Customer–Supplier Relationships 196
The High Cost of Bad Data 198
Measuring Innovation 200
Accidents Don’t Just Happen 201
Using the QI Macros to Analyze Your Data 201
