Home »
Blog » QI Macros
Improvement Insights Blog
Posts tagged "QI Macros"
Register for the upcoming FREE QI Macros Live Webinar, happening Tuesday, October 8th, 2024 at 9:00 a.m. MDT.
Learn more about it in the video below, and register at THIS link.
What: FREE QI Macros – Lean Six Sigma SPC Software for Excel Webinar.
When: Tuesday, October 8th, 2024 at 9:00 a.m. MDT.
Where: Join online from wherever you are.
How: Register for the webinar HERE.
Continue Reading "*Next Free QI Macros Live Webinar: Tuesday, October 8th, 2024"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
Over 40 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/24 QI Macros webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
I graduated from UofA in 1973 with a B.S. in Systems Engineering. Here’s my journey through TQM, Lean Six Sigma, QI Macros and beyond.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“I got hired out of out of college by Mountain Bell back in 1973 and I worked for them for many, many years. I spent three years on a rotation out to Bell Labs in New Jersey. I learned a lot of stuff about UNIX and came back.
“In my real college career I was studying Systems Engineering [and] Operations Research, which is the mathematical optimization of systems.
Continue Reading "Jay’s Quality Journey (5 min)"
Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog.
When processes aren’t working, people try adding to the process rather than subtracting. Doesn’t work. Here’s why:
“I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“I saw a phrase the other day that I liked, and I think you might get it. They called it “Addition Sickness”; Addition Sickness. What does that mean? Well, you end up adding more policies, procedures, rules, whatevers, workarounds, inspections… whatever it is. You know, Deming hated adding inspection; [he thought] that was stupid, right?
“But we tend to add things to a process to try and counteract whatever is going wrong.
Continue Reading "Have You Got Addition Sickness?"
Posted by Jay Arthur in Improvement Insights.
I’ve been working in quality improvement for 35 years. Why isn’t anything any better?
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“I’ve been at this for over 30 years (Quality Improvement), and I have to ask myself why isn’t anything any better? Why isn’t Quality pervasive? I think it’s because we made it too complex and time-consuming and too hard to do… that’s just me.
“But I have this Groundhog Day experience, right? I feel like Bill Murray. I wake up every morning and it says “same old same old.”
Continue Reading "Quality Groundhog Day"
Posted by Jay Arthur in Improvement Insights.
One of our users said she had some “troublesome data.” Do you have troublesome data? Here’s what to do about it.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“I was at the American Society for Quality Lean Six Sigma Conference and one of our users came up and we were talking. I said “I’d be happy to do a webinar for your people.” She said, “Well, we have some troublesome data. We could really use some help with our troublesome data.”
“One of the things I know is that very often, doing improvement isn’t hard, but getting the data that’s out there into some sort of useful format is often crazy and takes a little effort.
Continue Reading "Troublesome Data"
Posted by Jay Arthur in Improvement Insights.
Ever wonder why quality doesn’t get any better? Might the law of least effort.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“You know, as I look around, there’s this thing called “The Law of Least Effort,” which means humans (animals… whatever) will do the easiest thing possible. That’s why in Boston, the cows all walked certain paths and when it came time to… put in [roads for] cars and stuff, they paved the cow path because the cows knew where the [most level] ground was. Of course, that makes Boston almost impassible if you’ve ever been there.
Continue Reading "The Law of Least Effort"
Posted by Jay Arthur in Improvement Insights.
Detective shows usually have two detectives: one who leaps to arrest an obvious suspect and one who continues investigate the evidence. Which one are you?
“If you’ve ever watched detective shows, there’s always one detective that wants to leap to a solution and arrest the wrong person and just get him off the off the books, right? Then the other detective [says], “Whoa, whoa, whoa, whoa… wait… wait a minute. We haven’t looked at all the evidence.”
“I see the same thing in Quality Improvement. Every time a team comes together, they all think they know what the right answer is.
Continue Reading "Detective Number Two"
Posted by Jay Arthur in Improvement Insights.
Trendlines are often fake news. How can you separate fact from fiction? It’s easy.
“I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“One of the things that really irritates me about Excel is it’ll add a trend line to any data, but it does not add a “goodness-of-fit” metric automatically. It’s called “R squared,” and R squared should be like .8 or 80% fit in general.
“I’ve seen lots of charts and lots of posters at lots of improvement conferences where the goodness of fit metric is less than 50%. What?! So it’s not really an improvement.
Continue Reading "If It Don’t Fit You Must Forget"
Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog.
There’s often more than one way to get an answer with statistics.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma For Hospitals” and QI Macros [software].
“The other week we had somebody call in and say, “Can you do XYZ stat?” Well, by that name I didn’t understand what they were talking about, but then I looked up XYZ stat and it was our ABC stat in the QI Macros. Right?
“There’s more than one way to do things in statistics. There’s all kinds of things, all right? I just found out about something called Dixon’s Q and Grubbs’ Outlier Test for small samples… okay.
Continue Reading "More than One Way to Ken a Stat"
Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog.
