Blog

Latest "QI Macros" Posts

HIMSS says Healthcare Needs Data Analysts Who Are Problem Solvers

This article discusses the need for data analysts in healthcare: http://www.himss.org/library/healthcare-needs-data-analysts-who-are-problem-solvers The QI Macros Data Mining Wizard makes it easy to crunch the data about medical mistakes and errors, denied claims, patient falls and whatever else you can find. Learn more here: https://www.qimacros.com/data-mining-analysis-excel/data-mining-wizard/  

Posted by Jay Arthur in QI Macros, Six Sigma.

Unnecessary Online Credit Card Field

Ever notice that most online order forms ask what kind of credit card you are using? This field is unnecessary. Amex cards begin with a “3”; Visa with a “4”, Mastercard with a “5” or “2”; Discover cards begin with a “6”. You can get this information from the card number. So asking for type […]

Posted by Jay Arthur in Lean, QI Macros.

Quality Tool Usage at ASQ World 2017

This year, I tallied the quality tools used in poster presentations by presenting teams. Once again, quality tools were in short supply. Only one control chart, Pareto and histogram? Two fishbones? Mainly line and bar charts (72%) the dumbest charts available for performance improvement. Shouldn’t American Society for Quality set a higher standard?

Posted by Jay Arthur in QI Macros, Six Sigma.

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.