Latest "Statistics" Posts

20th vs 21 Century Quality

Too many quality professionals are clinging to the way things have always been done. There’s some sort of taboo about doing things quickly and easily. What are the differences between 2oth and 21st Century Quality? Watch and find out:

Register for the upcoming FREE QI Macros Live Webinar, happening Tuesday, January 8th, 2019 at 1:00 p.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, January 8th, 2019 at 1:00 p.m. MDT

Where:  Join online from wherever you are.

How:  Register for the webinar HERE.

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

The Book of Why?

Statisticians say “correlation does not equal causation,” but what if we can prove cause and effect using new tools? The Book of Why, by Judea Pearl explains how this new science of cause and effect has shifted statistics over the last 30 years.

Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog, Statistics.

8/14/18 QI Macros Webinar

Another great webinar where Jay Arthur shows some of the capabilities of QI Macros to a group of folks who signed up and attended. Some were familiar with the software and already use it, and some had not yet begun to use it; all were interested in learning new ways that QI Macros can help them with their Quality Improvement efforts. (You can hear him answering questions 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 automated Value Stream Map), 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, Six Sigma, Statistics.

Fear of Ridicule and What to Do About It

I’ve noticed a disturbing trend. Customers call us wanting to know all of the background about the hows, whys and formulas of a chart. I think they are afraid someone will challenge or ridicule their analysis. Here’s what I think.


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

Statistics are Simple

People have been trying to make statistics simple and easy to understand for decades.

But statistics aren’t simple. Maybe we should change how we teach them?

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

Are We Teaching Students the Unnecessary Things?

I’m here at the IISE (Institute of Industrial and Systems Engineers) conference in Pittsburgh.

One professor had been teaching students how to use Excel to create control charts, but he was beginning to feel like that was a waste of classroom time (duh!).

I beat him up a little for teaching DIY Excel stuff to students. If the professor does it, they think that’s how it’s done. With QI Macros he can get them right into analysis.

I feel the same way at ASA (American Statistical Association) when they use “R” to do statistics. Sure it’s free, but should statisticians be programming in “R” or just using software to achieve the same result.

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

Use XmR Charts instead of c, np, p and u Charts

I have found that an XmR chart is the easiest way to display attribute data. Simply convert the numerator/denominator into a ratio and plot the ratio.

  • defects per day could be a c chart, but an XmR chart works just as well
  • defects/samplesize could be np, p or u chart, but XmR chart works just as well using the ratio

Almost two decades ago, Tom Pyzdek said: X chart provides an excellent approximation to the p chart.

More recently, Donald Wheeler noted that XmR chart limits will be very close to c, np, p or u chart limits if the underlying distribution is correct.

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

What USL/LSL Do I Need for Cp>1?

Customer asked me what seemed like a strange question: What specification limits do I need to get a Cp greater than one? Usually her customer should set specification limits, but her boss wanted to know what they could deliver. Hmmmm!

Then I realized that since QI Macros templates (e.g., XmR chart) calculate the average and sigma estimator, the LSL/USL for Cp = 1.0 would be:

LSL = Average – 3*SigEst     USL = Average+ 3*SigEst

For Cp = 1.33, just change the 3 to a 4; Cp = 1.66, change the 3 to a 5. Here’s an XmR chart template with some sample data and calculations to reverse engineer spec limits:



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

Statistical Bullies

At IHI, I spoke with one Quality Improvement Adviser who was getting blow back from certain statisticians in her organization. They were challenging her methods and tools and analysis.

As I have written before, I call these folks “Stat Bastards” because they belittle others rather than help them.

As a member of the American Statistical Association, almost every statistician I meet is incredibly kind, generous and helpful. The few that flaunt their training rather than helping are impeding the forward progress of their organization.

I say, if they have better data, bring it. If they have better analysis, bring it. If they have better tools, bring it.

Posted by Jay Arthur in Six Sigma, Statistics.

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 Pivottables
  • 17% use Freeze Panes
  • 54% use Merged Cells (instead of Center Across Selection which works much better in many ways)

I wonder why we need any new features if the vast majority of users don’t or won’t use them. Maybe we need to invest in teaching people how to use the Excel features they have.

Posted by Jay Arthur in QI Macros, Statistics.