Home »
Blog » Six Sigma » Page 22
Improvement Insights Blog
Latest "Six Sigma" Posts
Nobody wants to read your spreadsheet! No matter how hard you try to make it pretty, create great labels or whatever, the only person who can read your spreadsheet is a CFO or Excel spreadsheet geek. And the Excel geek is going to tell you 10 ways to make it prettier.
The purpose of data is to provide insights for action, not just report past performance.
How Do I Know That Most Excel Users Try to Make Their Spreadsheets Readable By People?
According to Renu Davi, Sr. Program Manager for Excel, Microsoft tracks how people use Excel. The vast majority of the 650 million users use it for lists and reports.
Continue Reading "Nobody Wants to Read Your Spreadsheet!"
Posted by Jay Arthur in Data Mining, QI Macros, Six Sigma.
Over the last 25 years, I’ve gotten to see Six Sigma failures and successes. But in spite of all of the belts trained and investments made, why isn’t product and service quality any better? Why is there so much hassle? Why aren’t more customer experiences hassle-free? I’ve developed a mental list of the most common types of failures. Here’s my fishbone diagram for Six Sigma failures. I’d encourage you to develop your own.
80% of the businesses in the U.S. are service businesses, yet Six Sigma training is extensively focused on the manufacturing factory floor. It takes too long to teach people everything they might need to know to solve all of the problems they might ever encounter.
Continue Reading "Why Six Sigma Fails"
Posted by Jay Arthur in Healthcare, Manufacturing, QI Macros, Service, Six Sigma.
I got a call from a QI Macros customer who works at a luxury car dealership. Customers were upset because their cars were spending too long in the shop. The dealership tracked the length of stay of every car, the symptoms and barriers to getting the car done when expected.
I was struck by the similarities between what he was describing and a hospital. Patients come in, get diagnosed, treated, admitted and eventually discharged. This is the same problem as the maintenance shop.
I asked if the maintenance department had information about the type of problem, missing parts, age of the car and so on.
Continue Reading "How is a Hospital Like a Car Dealership?"
Posted by Jay Arthur in Healthcare, Lean, QI Macros, Service, Six Sigma.
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 good, but it will lead to charts that are merely adequate or, worse, ineffective.” He separates visualizations into four components: idea generation, idea illustration, visual discovery and everyday dataviz. Simple line, bar and pie charts are great for idea generation and illustration, but terrible for visual discovery and dataviz.
Continue Reading "Data Visualizations that Really Work"
Posted by Jay Arthur in QI Macros, Six Sigma, Statistics.
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 from their data that they were using standard deviation, not Sigma estimator (Rbar/d2) to calculate Cp and Cpk. Use Stdev to calculate Pp and Ppk, not Cp and Cpk:
They had run the QI Macros histogram on two columns of data, one measured at 0 degrees and one measured at 90 degrees.
Continue Reading "Cp Cpk Formulas and the Mistakes in Homemade Templates"
Posted by Jay Arthur in Manufacturing, QI Macros, Six Sigma, Statistics.
This month’s issue of Money Magazine discusses the 21 Most Valuable Career Skills. At the top of the list, statistical analysis increasing pay by 6.1%. Right behind statistical analysis is Data Mining at 5.1%. It’s incredibly easy to learn these two skills using QI Macros and Six Sigma.
Also on the list, Customer Service Metrics (4.3%). I have found that the written comments in customer service systems can be easily analyzed using the QI Macros Word Count tool to identify the most common type of call or complaint. Then simple root cause analysis can reduce or eliminate those calls.
Business analysis (3.8%) is easy with QI Macros Control Chart Dashboards.
Continue Reading "Most Valuable Career Skills"
Posted by Jay Arthur in Healthcare, Lean, Manufacturing, QI Macros, Service, Six Sigma.
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. spending on space, science and technology cause suicides? No, but they are correlated at a 99.79%. These and other crazy correlations are available.
So don’t confuse correlation with causation.
Continue Reading "Correlation not Causation"
Posted by Jay Arthur in Jay Arthur Blog, Six Sigma, Statistics.
At this years American Society for Quality World Conference in Milwaukee, winning teams improvement projects were displayed in posters in the exhibit hall. As I did at IHI in December, I took a stroke tally of the types of tools used. Like IHI, the vast majority of tools were line and bar charts, which are the dumbest charts on the planet. Only a few teams out of 36 used control charts, Pareto charts, histograms or fishbones.
Shouldn’t quality improvement stories should be told with tools of quality, not simple line and bar charts? Shouldn’t we be using charts that went to college and took statistics?
Continue Reading "ASQ 2016 Quality Tool Usage in Poster Presentations"
Posted by Jay Arthur in Healthcare, Manufacturing, QI Macros, Service, Six Sigma.
Charles Duhigg, in his book Smarter, Faster, Better, describes a condition he calls “information blindness.” When faced with too much information, people shut down because they don’t know what to do with it.
I find this is true in most companies. They collect tons of data, but can’t “winnow” the data down into the vital few bits of information that would transform their business. What I invariably do is use PivotTables, control charts and Pareto charts to find the “vital few” bits that tell us exactly where to find and fix the problems that cause over half of the waste, rework and lost profits.
Continue Reading "Information Blindness"
Posted by Jay Arthur in Six Sigma.
A customer called today confused about her data. She wanted to draw a control chart and thought the data might have a binomial or poisson distribution. She thought it was attribute data. She’d used the QI Macros Control Chart Wizard to create a control chart of her data and it chose an XmR chart. She wasn’t sure that was right. When I asked her what kind of data she had, she said, “write-offs”.
Write-offs are money, plain and simple. Money is variable (a.k.a. continuous or measured) data.
I explained that to her and suggested she stop worrying about what kind of distribution she has and just look at her data.
Continue Reading "Binomial, Poisson, Attribute, Continuous Data Control Chart Confusion"
Posted by Jay Arthur in QI Macros, Six Sigma.
