Blog

Latest "QI Macros" Posts

Measuring Six Sigma Success

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” […]

Posted by Jay Arthur in QI Macros, Six Sigma.

The Difference Between Lean Six Sigma Fundamentalists and Revolutionaries

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

Posted by Jay Arthur in QI Macros, Six Sigma.

Glitches are Opportunities

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?

Posted by Jay Arthur in QI Macros, Six Sigma.

One-Third of Food is Lost or Wasted

As reported in the ISE magazine, the United Nations Food and Agriculture Organization reported that “one third of food produced in the world is lost or wasted, which affects not only world hunger but carbon emission, water and land use.” I was recently rereading Juran on Quality by Design (1992) in which Joseph Juran lists “high […]

Posted by Jay Arthur in QI Macros, Six Sigma.

Excel Column 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.

Data Science is On The Rise

The Sept-Oct 2017 Harvard Business Review reports that the job market for data scientists is growing rapidly. Over 2.3 million of these jobs were listed in 2015. And the demand is expected to grow by 39%. But these positions are expensive and hard to fill. In a related column about how companies use big data, […]

Posted by Jay Arthur in QI Macros, Six Sigma.

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.