Project Tools

Blog posts and articles about tools and techniques that help keep Lean and Six Sigma projects on track.

Working with healthcare-related data often feels different than working with manufacturing data. After all, the common thread among healthcare quality improvement professionals is the motivation to preserve and improve the lives of patients. Whether collecting data on the number of patient falls, patient length-of-stay, bed unavailability, wait times, hospital acquired-infections, or readmissions,... Continue Reading
We often receive questions about moving ranges because they're used in various tools in our statistical software, including control charts and capability analysis when data is not collected in subgroups. In this post, I'll explain what a moving range is, and how a moving range and average moving range are calculated. A moving range measures how variation changes over time when data are collected as... Continue Reading

7 Deadly Statistical Sins Even the Experts Make

Do you know how to avoid them?

Get the facts >
As a recent graduate from Arizona State University with a degree in Business Statistics, I had the opportunity to work with students from different areas of study and help analyze data from various projects for them. One particular group asked for help analyzing online survey data they had gathered from other students, and they wanted to see if their new student program was beneficial. I would... Continue Reading
Depending on how often and when you use statistical software like Minitab, there may be specific tools or a group of tools you find yourself using over and over again. You may have to do a monthly report, for instance, for which you use one tool in our Basic Statistics menu, another in Quality Tools, and a third in Regression.  But there are a lot of functions and capabilities in our software, and... Continue Reading
Did you know that Minitab provides several tools you can use to view patterns in data over time? If you want to examine, say, monthly sales for your company, or even how the number of patients admitted to your hospital changes throughout the year, then these tools are for you! 1. Time Series Plot Time series plots are often used to examine daily, weekly, seasonal or annual variations, or... Continue Reading
Most of us have heard a backwards way of completing a task, or doing something in the conventionally wrong order, described as “putting the cart before the horse.” That’s because a horse pulling a cart is much more efficient than a horse pushing a cart. This saying may be especially true in the world of statistics. Focusing on a statistical tool or analysis before checking out the condition of your... Continue Reading
In my last post, I discussed how a DOE was chosen to optimize a chemical-mechanical polishing process in the microelectronics industry. This important process improved the plant's final manufacturing yields. We selected an experimental design that let us study the effects of six process parameters in 16 runs. Analyzing the Design Now we'll examine the analysis of the DOE results after the actual... Continue Reading
I used to work in the manufacturing industry. Some processes were so complex that even a very experienced and competent engineer would not necessarily know how to identify the best settings for the manufacturing equipment. You could make a guess using a general idea of what should be done regarding the optimal settings, but that was not sufficient. You need very precise indications of the correct... Continue Reading
P values have been around for nearly a century and they’ve been the subject of criticism since their origins. In recent years, the debate over P values has risen to a fever pitch. In particular, there are serious fears that P values are misused to such an extent that it has actually damaged science. In March 2016, spurred on by the growing concerns, the American Statistical Association (ASA) did... Continue Reading
Like so many of us, I try to stay healthy by watching my weight. I thought it might be interesting to apply some statistical thinking to the idea of maintaining a healthy weight, and the central limit theorem could provide some particularly useful insights. I’ll start by making some simple (maybe even simplistic) assumptions about calorie intake and expenditure, and see where those lead. And then... Continue Reading
After my husband’s most recent visit to the dentist, he returned home cavity-free...and with a $150 electric toothbrush in hand.  I wanted details. It began innocently. His dreaded trip to the dentist ended in high praise for no cavities and only a warning to floss more. That prompted my programming-and-automation-obsessed husband, still in the chair, to exclaim, "I wish there was a way to automate... Continue Reading
You have a column of categorical data. Maybe it’s a column of reasons for production downtime, or customer survey responses, or all of the reasons airlines give for those riling flight delays. Whatever type of qualitative data you may have, suppose you want to find the most common categories. Here are three different ways to do that: 1. Pareto Charts Pareto Charts easily help you separate the vital... Continue Reading
What is an interaction? It’s when the effect of one factor depends on the level of another factor. Interactions are important when you’re performing ANOVA, DOE, or a regression analysis. Without them, your model may be missing an important term that helps explain variability in the response! For example, let’s consider 3-point shooting in the NBA. We previously saw that the number of 3-point... Continue Reading
While the roots of Lean Six Sigma and other quality improvement methodologies are in manufacturing, it’s interesting to see how other organizational functions and industries apply LSS tools successfully. Quality improvement certainly has moved far beyond the walls of manufacturing plants! For example, I recently had the opportunity to talk to Drew Mohler, a Lean Six Sigma black belt and senior... Continue Reading
There's nothing like a boxplot, aka box-and-whisker diagram, to get a quick snapshot of the distribution of your data. With a single glance, you can readily intuit its general shape, central tendency, and variability. To easily compare the distribution of data between groups, display boxplots for the groups side by side. Visually compare the central value and spread of the distribution for each... Continue Reading
If you need to assess process performance relative to some specification limit(s), then process capability is the tool to use. You collect some accurate data from a stable process, enter those measurements in Minitab, and then choose Stat > Quality Tools > Capability Analysis/Sixpack or Assistant > Capability Analysis. Now, what about sorting the data? I’ve been asked “why does Cpk change when I... Continue Reading
In my time at Minitab, I’ve gotten a good understanding of what types of graphs users create. Everyone knows about histograms, bar charts, and time series plots. Even relatively less familiar plots like the interval plot and individual value plot are still used quite often. However, one of the most underutilized graphs we have available is the area graph. If you’re not familiar with an Area... Continue Reading
In an earlier post, I shared an overview of acceptance sampling, a method that lets you evaluate a sample of items from a larger batch of products (for instance, electronics components you've sourced from a new supplier) and use that sample to decide whether or not you should accept or reject the entire shipment.  There are two approaches to acceptance sampling. If you do it by attributes, you... Continue Reading
Now that we've seen how easy it is to create plans for acceptance sampling by variables, and to compare different sampling plans, it's time to see how to actually analyze the data you collect when you follow the sampling plan.  If you'd like to follow along and you're not already using Minitab, please download the free 30-day trial.  Collecting the Data for Acceptance Sampling by Variable If you'll... Continue Reading