Home »
Blog » QI Macros » Page 47
Improvement Insights Blog
Posts tagged "QI Macros"
Most of the improvement posters at this year’s Institute for Healthcare Improvement (IHI) conference are still using line, bar and pie charts, not the tools of quality improvement. There were several posters using QI Macros control charts, Pareto charts and fishbones this year from Sutter Health and Howard University Hospital.

Continue Reading "IHI 2017 Quality Tool Usage"
Posted by Jay Arthur in QI Macros, Six Sigma.
People have been trying to make statistics simple and easy to understand for decades.
But statistics aren’t simple. Maybe we should change how we teach them?
Continue Reading "Statistics are Simple"
Posted by Jay Arthur in Improvement Insights, QI Macros, Statistics.
Everyone seems to think that top down, leadership-driven is the only way to implement Lean Six Sigma. It’s not.
50 years of research proves that it fails half the time. Yep, 50% failure rate. That’s less than 1 sigma.
This type of failure is so common that it even has a name: The Stalinist Paradox.
Continue Reading "Top Down Change Doesn’t Work"
Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma.
The recent collapse of GE stock price has led to a lot of discussion. Here’s my two cents.
Jack Welch implemented Six Sigma at GE which drove many CEOs to do the same. From scuttlebutt I’ve picked up over the years, this lead to crazy rules like every employee had to do two Six Sigma projects a year. This would violate Pareto’s Rule: if only 20% of the business is creating 80% of the defects, waste and rework, having employees try to fix the remaining 80% of the business is a waste of resources. Six Sigma needs focus, not spread.
Jeffery Immelt reduced leadership support for Six Sigma.
Continue Reading "GE’s Problems – Strategy or Six Sigma?"
Posted by Jay Arthur in QI Macros, Six Sigma.
“Our evolutionary instincts sometimes lead us to see patterns when there are none there. People have been doing this all the time – finding patterns in random noise.” – Tomaso Poggio
People just need a way to separate the Signal from the Noise.
Here are some insights from the book by Nate Silver.
Continue Reading "Signal versus Noise"
Posted by Jay Arthur in Data Mining, Improvement Insights, Jay Arthur Blog, Six Sigma.
People often get stuck before the “Analyze” phase of DMAIC because of ugly data.
You can’t analyze data until it is in the right format for analysis.
In this data about medications that might affect patient falls, we have to:
- Transpose the data
- Use Excel’s Text-to-column feature to split the meds into separate cells
- Use QI Macros UnStack Columns tool to get all of the meds into a single column
- Use QI Macros Data Mining Wizard to create a PivotTable and Pareto chart of medications involved in patient falls
You can watch the video below:
Continue Reading "It’s Hard to Do Data Analysis on Ugly Data… Part 2"
Posted by Jay Arthur in Data Mining, Improvement Insights.
This recent article talks about how GE measured Six Sigma success:
“Engineers and scientists were measured on how many Six Sigma projects they completed during the year.”
Since I know that 4% of the business is causing over half of the waste, rework and lost profit (the 4-50 rule), making everyone do “Six Sigma projects” is a form of overproduction (violating a Lean rule). It creates waste, rework and unhappy employees. It makes people put trivial improvements in Six Sigma format to achieve the goals.
Measure Six Sigma success by bottom-line, profit and productivity enhancing results, not projects. Use data to focus improvements to maximize results and minimize effort.
Continue Reading "Measuring Six Sigma Success"
Posted by Jay Arthur in QI Macros, Six Sigma.
Lean Six Sigma Fundamentalists believe:
– Get management commitment
– Train lots of black and green belts
– Implement wall-to-wall floor to ceiling
Lean Six Sigma Revolutionaries believe:
-Engage informal leaders
-Train money belts
-Laser-focused, data-driven breakthrough improvements
Continue Reading "Lean Six Sigma Fundamentalists vs Revolutionaries"
Posted by Jay Arthur in QI Macros, Six Sigma.
The next time you hit a glitch are you going to
0. Ignore it
1. Find a work around
2. Take heroic action to fix it.
3. Fix the glitch and then take the time to prevent it from ever happening again?
Continue Reading "Glitches are Opportunities"
Posted by Jay Arthur in QI Macros, Six Sigma.
The July/August 2017 HealthLeaders magazine had a series of charts about the impact of Adverse Events. In general, the magazine used column charts:

But wouldn’t a Pareto chart illuminate the important adverse events more clearly? The first three accounted for over 57% of 2013 deaths.

Continue Reading "Excel Bar Charts Hide The Signal in Noise"
Posted by Jay Arthur in Excel, QI Macros, Six Sigma.