Reliable Six Sigma & SPC Excel Add-in
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.
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?
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 […]
Continue Reading "Are We Teaching Students the Unnecessary Things?"
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 […]
Continue Reading "Use XmR Charts instead of c, np, p and u Charts"
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 […]
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 […]
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 […]
The June, 2016 HRB article by Scott Berinato examines how to use charts and diagrams to express ideas and statistics. I agree with Anmol Garg, Tesla data scientist quoted in the article, “You can’t find anything looking at spreadsheets and querying databases. It has to be visual.” Bernato says: “Convenient is a tempting replacement for […]
Creating homemade Cp and Cpk templates often results in incorrect values. There are many, many mistakes you might make without realizing. Here are a few examples. A customer sent me their home grown template for calculating Cp and Cpk and wondered why the QI Macros got such radically different values. It was easy to see […]
Continue Reading "Cp Cpk Formulas and the Mistakes in Homemade Templates"
As John Johnson and Mike Gluck point out in their book, EVERYDATA, ice cream consumption and murder rates both go up in the summer, but that does not mean that eating ice cream causes murder. Rising summer temperatures seem to be involved. They also provide a link to Tyler Vigen’s website, Spurious Correlations. Does U.S. […]
Read What Others Say
- CNET Five Star Review
- Industry Leaders
- Our Customers
KnowWare International, Inc.
2696 S. Colorado Blvd., Ste. 555
Denver, CO 80222 USA
Toll-Free: 1-888-468-1537
Local: (303) 756-9144
© 2018 KnowWare International Inc. All Rights Reserved. Legal Information.