Pareto Chart Tagged Improvement Insights

Improvement Insights Blog

Posts tagged "Pareto Chart"

What Kind of Data Should I Use?

Someone recently asked: “What kind of data should I use for control charts and Pareto charts.” The answer is simple. Here it is:



“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].

“I got a call from someone last week who was talking about how they’ve been a longtime user of QI Macros, and then how educated they were… and then they asked me, “Uh, Jay… I’m not quite sure how to set up… what kind of data should I use for a control chart, and what kind of data should I use for a Pareto chart?”

Posted by Jay Arthur in Improvement Insights.

Brainstorming is a Terrible Way to Start a Team

Did your quality instructors teach you to gather a team and brainstorm a problem to solve? That’s terribly bad advice. Use data to pinpoint the problem. Then, and only then do you know who should be on the root cause analysis.



I don’t know about you, but when I first got my quality training they said, “Get a team together and brainstorm a problem to solve and then go start trying to find the data, define the data, measure the data,” or something else. Now that’s the dumbest damn advice I ever got in quality training. I’ve looked at a lot of different training packages over the years and they still have all that same stupid stuff in there.

Posted by Jay Arthur in Data Mining, Improvement Insights, QI Macros.

Arthur’s 4-50 Rule – The Secret to Breakthrough Improvement

We’re all familiar with Pareto’s rule: 20% of causes produce 80% of the results. But are you familiar with Arthur’s 4-50 rule? Typically, 4% of any process – one step out of 35 – is the cause of more than 50% of waste, rework and lost profit.



“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software].

“Now I’ve probably talked to you about this before, but we’re all familiar with Pareto’s rule that 20% of what you do produces 80% of the mistakes, errors, waste, rework, lost profit. 20% of your customers produce 80% of your revenue.

Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma, Statistics.

Ask Jay – What Kind of Chart Should I Use?

People still seem to be confused about what kind of Quality Improvement chart to use. Here’s the short and simple answer:



Posted by Jay Arthur in Ask Jay, Jay Arthur Blog.

Yankee Spirit Goal Setting

Yankee Spirit (50% reduction in delay, defects and deviation) is easy to achieve. It’s imperative. Here’s why:

“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software].

“When I first got started in Quality Improvement, our training folks talked about Yankee Spirit as a method of setting a goal. What’s Yankee Spirit? Well, Yankee Spirit is simply a 50% reduction in delay, defects and deviation.

“Well, that just sounds like we’re just taking a dartboard throwing a thing at it, but it was years later that I realized that this is actually scientifically doable. As I started to look at it, Pareto’s rule says 20% of what you do produces 80% of the waste, rework, lost profit, patient harm… whatever you want to call it.

Posted by Jay Arthur in Improvement Insights, Six Sigma.

Why Are People Using Line and Bar Charts, not Control Charts?

If you look at improvement project posters at quality conferences around the country, you’ll find that almost everyone is using Excel line and bar charts. Even after decades of Six Sigma training and association membership. What’s the hold up? Here’s my take:

“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].

“Every year I look at lots of improvement posters and I keep wondering, “Why isn’t anyone using the tools of Quality?” Control charts, Pareto charts, histograms… Most of them are just using plain old Excel line and bar charts. Now it might be because they don’t know about the power and beauty and how easy it can be now to do Control charts, Pareto charts and fishbones.

Posted by Jay Arthur in Improvement Insights, Lean, Six Sigma.

U.S. Deaths by Age Group as of 4/24/2020

People over age 55 account for 92% of COVID-19 Deaths (data from CDC). Sweden is using similar data to leave the country open for most citizens while asking seniors to stay at home. How do we reopen the economy? Self-quarantine seniors; let everyone else get back to work.

Here’s the 2019-2020 Influenza (i.e., Flu) deaths. Again, seniors are 83.5% of deaths. The flu death rate is about 1 per 1,000. COVID-19 death rate is 1-2 per 100, perhaps lower in people under the age of 55 and higher for those over age 55.

Countermeasure: Self-quarantining seniors will help flatten the curve and prevent overwhelming healthcare.

Posted by Jay Arthur in Healthcare, Jay Arthur Blog, QI Macros.

Making Pareto Charts by Hand?

Sometimes you’ll hear people say that software isn’t necessary for Quality Improvement. Let me demonstrate how much time you’re wasting if you create ONE Pareto chart by hand, instead of using software.

“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and the QI Macros [software].

“If you’ve listened to any of my Insight videos or seen me present at conferences or [had me] train you in a workshop, you know that I don’t believe you can do Quality Improvement without software. We have to stop doing Quality Improvement the 20th century manual, slow way. We have to start doing it the 21st century way, and we have to start doing it quickly.

Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights, QI Macros.

2020 New Years Resolution Part 1 – Learn One Tool Per Month

Many people tell us that they have QI Macros, but they don’t know how to use it. Make a resolution to learn how! Here are my suggestions.

“Hi, I’m Jay Arthur and… it’s 2020. How did that happen? A new year; a new decade. Seems like just yesterday everybody was worried about Y2K. Somebody out there is thinking, “What’s Y2K?” That was a thing that happened back in the year 2000… you probably forgot all about it, but I’ve been at this for over twenty years now in the software field around Quality Improvement, so I’ve seen a lot of things.

Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma.

Excel Bar Charts Hide The Signal in Noise

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.

Posted by Jay Arthur in Excel, QI Macros, Six Sigma.