Home »
Blog » QI Macros
Improvement Insights Blog
Posts tagged "QI Macros"
Over 50 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by attendees.
If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the Improvement Project Wizard or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.
Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.
Continue Reading "*Latest webinar: 9/10/26 QI Macros webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
Statistical textbooks disagree on what constitutes Control Chart Rule 2 – Zone A: 2 of 3 points above/below 2 sigma. Which one is right?
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“Got a call from a customer this week. He was all upset because of control chart rule two, which is about having points above two sigma or below two sigma (two out of three).
“Well, guess what? Some people in their books say those two points have to be on the same side of the center line.
Continue Reading "Control Chart Rules"
Posted by Jay Arthur in Improvement Insights.
Over 50 people signed up for this webinar, with Jay Arthur demonstrating how to implement Healthcare Data Analytics to save time, save money, and (most importantly) save lives.
Books that Jay may have mentioned in the video:
You can view a short two-page illustrated guide to the Zero Harm – Trillion Dollar Prescription by clicking HERE.
Continue Reading "8/18/26 Healthcare Data Analytics Webinar"
Posted by Jay Arthur in Agile Lean Six Sigma, Data Mining, Excel, Healthcare, Lean, QI Macros, Six Sigma, Webinar.
When your Kleenex box tissues don’t pop up, what do you do? Use TRIZ.
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“I don’t know about you, but some things sort of bother me, like sometimes the Kleenex gets stuck down in there, you know. You could try and run your hand down in there to pull something out, but that screws up all the plastic in here.
“But I was thinking about TRIZ, and there’s 40-some-odd different rules for coming up with better ways to do something.
Continue Reading "Kleenex Box Hack Using TRIZ"
Posted by Jay Arthur in Improvement Insights.
I was stunned when a QI Macros user at the IHI conference told me: “QI Macros saves lives.” I love these stories.
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“I was at the Institute for Healthcare Improvement conference and one of the attendees, one of our users, came up and said, “QI Macros is doing really good work in the world. QI Macros is saving lives.” And that kind of stunned me, right?
Continue Reading "QI Macros Saves Lives"
Posted by Jay Arthur in Improvement Insights.
People ask me if QI Macros can generate random samples or do sampling and I say no. Excel’s Data Analysis Toolpak can already do that. Discover how:
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“People call in sometimes and say, ‘Do you have a tool in QI Macros to do random samples of data?’ I say, ‘No, because that’s already built into Excel. I try not to do anything Excel really does naturally.’ Most people are unaware that there’s a Data Analysis Tool Pack and you can add that into Excel and you can do things like create sample data with plus or minus so many standard deviations.
Continue Reading "Discover Excel’s Data Analysis Toolpak"
Posted by Jay Arthur in Improvement Insights.
People ask: Should I use a p or u chart, or XmR chart? Which one is right? It depends…
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“One of the things I’ve noticed is I get calls from people and they ask me, “Well, Jay, should we be using a p [chart] and u charts or an XmR chart of ratios?” And I can tell you: that depends on who your statistician leader is.
“If you’re looking at the Healthcare Data Guide, Lloyd Provost and his partner [Sandra Murray] love p and u charts… love them!
Continue Reading "p/u Charts or XmR Charts?"
Posted by Jay Arthur in Improvement Insights.
I took Deming’s workshop back in the 1990s. When asked about Total Quality Management (TQM) Deming said…
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“Back in the 1990s when I was first getting involved with Quality, I went to one of [W. Edwards] Deming‘s four-day seminars. Somewhere in there, somebody asked him about Total Quality Management.
“Deming said, ‘I have no idea where the word ‘total’ came from. That’s just wrong. It’s Quality Management.
Continue Reading "Deming on Total Quality Management (TQM)"
Posted by Jay Arthur in Improvement Insights.
When I was in grade school, we used fountain pens that had cartridges of ink that sometimes spilled or stained. It wasn’t until high school that I got my first ball point pen. Here’s why that’s critical to your business.
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“I found it interesting that the ballpoint pen was invented in 1938, the decade before I was born. In the 50s and 60s, we used what are called fountain pens: They had these little cartridges of ink, and you would put it in the pen and you could write with it, and sometimes it would spill.
Continue Reading "Ball Point Pens and Innovation"
Posted by Jay Arthur in Improvement Insights.
If a Six Sigma Yellow Belt can save $10,000 per project, wouldn’t you spend a few hundred dollars to make them more successful? What are costs of not getting them the tools they need?
Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“I forget that sometimes I can see things that other people can’t see. They’re just intuitive to me. So, Mikel Harry, I saw him maybe a decade ago and he said the next wave of Six Sigma is Yellow Belts… saving $10,000 or $20,000 per project.
Continue Reading "If a Six Sigma Yellow Belt can Save $10,000 per project"
Posted by Jay Arthur in Improvement Insights.