QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

How Many SPC Books and Formulas Do You Need?

Most people are terrified of statistical formulas. How many do you need to know? I think my answer will surprise you.



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

“Next to my desk at the office I have dozens of books about Statistical Process Control and Quality Improvement and all the other stuff. How many of those formulas do I think you all need to know?

“My answer is zero. The software will do all of that for you. You do not need to know a single formula. I go to these conferences and I talk to people and I talk about control charts and people all start to get anxious about, “Oh my god, do I have to learn any formulas?”

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

QI Macros Software Demo

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.

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.

2/9/21 QI Macros webinar

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

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.