Latest "QI Macros" Posts

Will Automation Steal Your Job? Skills to Beat AI

The March-April 2017 issue of HBR has a survey of 1770 managers in 14 countries. When asked to identify the top 3 skills needed, the managers identified two that are important to quality: 31% of managers said  Data Analysis and Interpretation 20% said Quality Management and Standards QI Macros New Data Mining Wizard can dramatically […]

Posted by Jay Arthur in Data Mining, QI Macros, Six Sigma.

Use XmR Charts instead of c, np, p and u Charts

I have found that an XmR chart is the easiest way to display attribute data. Simply convert the numerator/denominator into a ratio and plot the ratio. defects per day could be a c chart, but an XmR chart works just as well defects/samplesize could be np, p or u chart, but XmR chart works just as […]

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

What USL/LSL Do I Need for Cp>1?

Customer asked me what seemed like a strange question: What specification limits do I need to get a Cp greater than one? Usually her customer should set specification limits, but her boss wanted to know what they could deliver. Hmmmm! Then I realized that since QI Macros templates (e.g., XmR chart) calculate the average and […]

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

Cpk and Hard vs Specification Limits

A customer called upset about Cpk. He had a runout of 0.010, but was getting a very low Cpk. Turns out he’d made the classic mistake of confusing a hard limit (e.g., zero) with a specification limit. I had him use QI Macros with an Upper Specification limit (USL) and no Lower Specification Limit (LSL). […]

Posted by Jay Arthur in QI Macros, Six Sigma.

Mistake-proofing Bathroom Design

My friend, Mary LoVerde’s ezine shows a hotel bathroom she recently experienced. How would you mistake-proof this design? What are the possible failure modes and effects (FMEA)?

Posted by Jay Arthur in QI Macros, Six Sigma.

Is Fear of Math Holding You Back?

Many people avoid Six Sigma because they think it involves a lot of math and statistics. You know, formulas. I don’t think you need any formulas. You don’t need to be a statistician. You just need software that went to college and knows the formulas. In The Math Gene, Author Keith Devlin explores “why so […]

Posted by Jay Arthur in QI Macros, Six Sigma.

Quality Tool Usage at IHI 2016 Poster Presentations

I’ve been monitoring the use of quality tools at the Institute for Healthcare Improvement conference for over a decade. This year there was a slight uptick in the use of control charts, but still far below my expectations. How can healthcare hope to achieve and sustain improvements without control charts? There were over 500 posters, […]

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

Bad at Math?

At the IHI 28th Forum in Orlando, one visitor to our exhibit booth said: “I’m bad at math.” She was worried about needing to learn formulas. I hear this same concern from most people thrust into quality improvement. I told her: “You don’t need to know formulas. You just need to know how to select […]

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

Nobody Wants to Read Your Spreadsheet!

Nobody wants to read your spreadsheet! No matter how hard you try to make it pretty, create great labels or whatever, the only person who can read your spreadsheet is a CFO or Excel spreadsheet geek. And the Excel geek is going to tell you 10 ways to make it prettier. The purpose of data […]

Posted by Jay Arthur in Data Mining, QI Macros, Six Sigma.

Why Six Sigma Fails

Over the last 25 years, I’ve gotten to see Six Sigma failures and successes. But in spite of all of the belts trained and investments made, why isn’t product and service quality any better? Why is there so much hassle? Why aren’t more customer experiences hassle-free? I’ve developed a mental list of the most common […]

Posted by Jay Arthur in healthcare, Manufacturing, QI Macros, Service, Six Sigma.