Blog

Latest "QI Macros" Posts

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.

How to Craft an Improvement Story

In 1975, I went to work at Bell Laboratories in New Jersey. I was introduced to Unix and the Shell programming language. The cool thing about Shell was the hundreds of tools that each did simple things and could be cobbled together into scripts that would do amazingly complex things. I later wrote a book, […]

Posted by Jay Arthur in QI Macros, Six Sigma.

Users Barely Using Excel

Renu Davi, Sr. Program Manager for Excel, reported at Excelapaloosa that two-thirds of the 650 million users use Excel to make lists. The other third of users do deeper analysis, but I’m wondering how? Microsoft keeps tabs on Excel usage. Here’s some statistics for usage in an Excel workbook: Only 4.3% have a function like SUM(A1:B2) 7.5% have […]

Posted by Jay Arthur in QI Macros, Statistics.

How is a Hospital Like a Car Dealership?

I got a call from a QI Macros customer who works at  a luxury car dealership. Customers were upset because their cars were spending too long in the shop. The dealership tracked the length of stay of every car, the symptoms and barriers to getting the car done when expected. I was struck by the similarities […]

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

Data Visualizations that Really Work

The June, 2016 HRB article by Scott Berinato examines how to use charts and diagrams to express ideas and statistics. I agree with Anmol Garg, Tesla data scientist quoted in the article, “You can’t find anything looking at spreadsheets and querying databases. It has to be visual.” Bernato says: “Convenient is a tempting replacement for […]

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

Cp Cpk Formula Mistakes

A customer sent me their home grown template for calculating Cp and Cpk and wondered why the QI Macros got such radically different values. It was easy to see from their data that they were using standard deviation, not Sigma estimator (Rbar/d2) to calculate Cp and Cpk. Use Stdev to calculate Pp and Ppk, not […]

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

Most Valuable Career Skills

This month’s issue of Money Magazine discusses the 21 Most Valuable Career Skills. At the top of the list, statistical analysis increasing pay by 6.1%. Right behind statistical analysis is Data Mining at 5.1%. It’s incredibly easy to learn these two skills using QI Macros and Six Sigma. Also on the list, Customer Service Metrics […]

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