QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

QI Macros Software Demo – 2021 ASQ World Conference on Quality & Improvement

Thanks for attending the 2021 ASQ World Conference on Quality & Improvement. Click below to see a quick demo of how QI Macros can help you prevent waste, rework and lost profit. 

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

*Latest webinar: 4/13/21 QI Macros webinar

Over 65 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.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar 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, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

3/9/21 QI Macros webinar

Over 125 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.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar 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, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

An Easy Way to Tell if Data is Variable or Attribute

Six Sigma students are often confused by terminology. Variable and attribute data are often confusing. Calling it measured or counted doesn’t help that much. Here’s a way to explain it that almost everyone can understand quickly.



“Early on when I was teaching Quality Improvement, people kind of struggled with the whole idea of variable and attribute data, and telling them that it was measured and counted didn’t seem to help a lot.

“As a programmer, the way I think about it is: If it has a decimal point, it has to be measured, right? If it’s an integer, it’s most likely counted, right?

Posted by Jay Arthur in Improvement Insights, QI Macros, Statistics.

Great IT PRO – 2/17/21 Webinar

Jay Arthur was the featured speaker for the Great IT Pro Webinar on 2/17/21. His topic was “Problem Solving With Data.” You may view the recorded video of Jay’s webinar below:



If you’re interested in learning more about QI Macros for Excel (the software Jay wrote and developed), click HERE and view the demo video in the yellow box. You may also sign up for a free 30 day trial of the software by filling out the form on that page next to the video, or by signing up at THIS link. If you’re interested in learning more about Jay’s ideas on Agile Lean Six Sigma, you can download a free brief summary of Jay’s ideas in his “Agile Lean Six Sigma Manifesto,” available at THIS link.

Posted by Jay Arthur in QI Macros, Service, Webinar.

Start Using XmR Charts for All of Your KPIs

Do you spend too much time chasing why one number is too high or another is too low? Are these kinds of wild goose chases wasting time while the real problems go wanting? The XmR chart is the answer to your dreams.



“Dr. Donald Wheeler calls the XmR chart (or Individuals and Moving Range chart) “the Swiss Army knife of control charts.” You can use it for all kinds of things.

“I believe if every company in America started using XmR charts to track all of their key process indicators, I don’t care if it’s financial results or defects or patient length of stay or I don’t care what it is.

Posted by Jay Arthur in Improvement Insights, QI Macros, Statistics.

QI Macros Software Demo – 2021 Lean Six Sigma World Conference

Thanks for attending the 2021 Lean Six Sigma World Conference. Click below to see a quick demo of how QI Macros can help you prevent waste, rework and lost profit.



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

QI Macros Software Demo – 2021 ASQ Lean and Six Sigma Conference

Thanks for attending the 2021 ASQ Lean and Six Sigma Conference. Click below to see a quick demo of how QI Macros can help you prevent waste, rework and lost profit.



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

Arthur’s 4-50 Rule – The Secret to Breakthrough Improvement

We’re all familiar with Pareto’s rule: 20% of causes produce 80% of the results. But are you familiar with Arthur’s 4-50 rule? Typically, 4% of any process – one step out of 35 – is the cause of more than 50% of waste, rework and lost profit.



“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software].

“Now I’ve probably talked to you about this before, but we’re all familiar with Pareto’s rule that 20% of what you do produces 80% of the mistakes, errors, waste, rework, lost profit. 20% of your customers produce 80% of your revenue.

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

1/15/21 QI Macros webinar

Over 100 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.

Some attendees were familiar with the software and already use it, some had only begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions and comments typed in by webinar 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 Templates Wizard, the Fixed Limit indicator or the automated Process Change Wizard), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.