The Best European Football League: What the CTQ’s and Minitab Can Tell Us

by Laerte de Araujo Lima, guest blogger

In a previous post (How Data Analysis Can Help Us Predict This Year's Champions League), I shared how I used Minitab Statistical Software to predict the 2013-2014 season of the UEFA Champions league. This involved the regression analysis of main critical-to-quality (CTQ) factors, which I identified using the “voice of the customer” suggestions of some friends.

Since that post was published, my friends have stopped discussing the UEFA Champions league—they were convinced by the results I shared.

But now they’ve challenged me to use Six Sigma tools to...

I Think I Can, I Know I Can: A High-Level Overview of Process Capability Analysis

Remember "The Little Engine That Could," the children's story about self-confidence in the face of huge challenges? In it, a train engine keeps telling itself "I think I can" while carrying a very heavy load up a big mountain. Next thing you know, the little engine has done it...but until that moment, the outcome was uncertain.

It's a wonderful story for teaching kids about self-confidence. But from a quality and customer service viewpoint, it's a horror story: if your business depends on taking the load up the hill, you want to know you can do it.

That's where capability analysis comes in. 


Creating a Custom Report using Minitab, part 2

Now that you’ve seen how to automatically import data and run analyses in my previous post, let’s create the Monthly Report!

I will be using a Microsoft Word Document (Office 2010) and adding bookmarks to act as placeholders for the Graphs, statistics, and boilerplate conclusions.

Let’s go through the steps to accomplish this:

  • Open up an existing report that you have previously created in Microsoft Word.
  • Highlight a section of the document where you would like to place the created Minitab graph or statistic.
  • Go to the Insert tab, click the Bookmark link, and type in the name of what you will be...

Creating a Custom Report using Minitab, part 1

As a member of Minitab’s Consulting and Custom Development Services team, I get to help companies across a variety of industries create many different types of reports for management. These reports often need to be generated weekly or monthly. I prefer to automate tasks like this whenever possible, so that new or updated reports can be created without much effort. A little investment up front can save a lot of time by eliminating the need to recreate the wheel every time management wants a current report. 

I’m going to tell you how to use Minitab Statistical Softwareto automatically generate a...

Introducing the Bubble Plot

When you're evaluating a dataset, graphical analysis can be very important. While an analysis like a regression or ANOVA can be backed up by numbers, being able to visualize how your dataset is behaving can be even more convincing than a group of p-values—especially to those who aren’t trained in statistics.

For example, let’s look at a few variables we think may be correlated. In this specific example, we will take the Unemployment Rate and the Crime Rate for each state in the U.S. We have 3 columns of data in Minitab: C1, which contains the State Name; C2, which contains the Crime Rate; and...

Create a DOE Screening Experiment with the Assistant in Minitab 17

If you’ve been looking at Minitab 17, you’ve noticed a lot of new enhancements. For me, the biggest of these is the addition of Design of Experiments (DOE) to the Assistant. DOE in the Assistant has so many exciting aspects it’s hard to take it all in at once, but here are 5 highlights for when you plan and create a screening experiment:

1. Just-in-time guidance

If you’re lucky, you’ve had the chance to study DOE with an expert. If not, even the flow chart that opens with the Assistant to plan an experiment might seem intimidating. Fortunately, you don’t have to go scouring the thrift store for...

Using Statistics to Show Your Boss Process Improvements

Ughhh... your process is producing some parts that don't meet your customer's specifications! Fortunately, after a little hard work, you find a way to improve the process.

However, you want to perform the appropriate statistical analysis to back up your findings and make it easier to explain the process improvements to your boss. And it's important to remember that your boss is much like the boss in Eston's posts -- he's not too familiar with statistics, so you'll have to take it slow and show lots of "visual aids" in your explanation. How should you begin? 

Enter before-and-after process...

Got Good Judgment? Prove It with Attribute Agreement Analysis

Many Six Sigma and quality improvement tools could be applied in other areas. For example, I wonder whether my son's teachers could benefit from a little attribute agreement analysis. 

He seemed frustrated the other day when I picked him up at school. He'd been working on a presentation that needed to be approved by his teachers. (My son attends a charter school, and each class is taught by a two-person teaching team.)

"What's wrong?" I asked when he clambered into the car with a big sigh.

My son explained that he'd given the presentation to teacher Jennifer that morning. A few minor suggestions...

Re-analyzing Wine Tastes with Minitab 17

In April 2012, I wrote a short paper on binary logistic regression to analyze wine tasting data. At that time, François Hollande was about to get elected as French president and in the U.S., Mitt Romney was winning the Republican primaries. That seems like a long time ago…

Now, in 2014, Minitab 17 Statistical Software has just been released. Had Minitab 17, been available in 2012, would have I conducted my analysis in a different way?  Would the results still look similar?  I decided to re-analyze my April 2012 data with Minitab 17 and assess the differences, if there are any.

There were no...

Opening Ceremonies for Bubble Plots and Poisson Regression

By popular demand, Release 17 of Minitab Statistical Software comes with a new graphical analysis called the Bubble Plot.

This exploratory tool is great for visualizing the relationships among three variables on a single plot.

To see how it works, consider the total medal count by country from the recently completed 2014 Olympic Winter Games. Suppose I want to explore whether there might be a possible association between the number of medals a country won and its maximum elevation. For that, I could use a simple scatterplot, right?

But say I want to throw a third variable into the mix, such as...

Unleash the Power of Linear Models with Minitab 17

We released Minitab 17 Statistical Software a couple of days ago. Certainly every new release of Minitab is a reason to celebrate. However, I am particularly excited about Minitab 17 from a data analyst’s perspective. 

If you read my blogs regularly, you’ll know that I’ve extensively used and written about linear models. Minitab 17 has a ton of new features that expand and enhance many types of linear models. I’m thrilled!

In this post, I want to share with my fellow analysts the new linear model features and the benefits that they provide.

New Linear Model Analyses in Minitab 17

We’ve added...

Revisiting the Relationship between Rushing and NFL Wins with Binary Fitted Line Plots

Back in November, I wrote about why running the football doesn’t cause you to win games in the NFL. I used binary logistic regression to look at the relationship between rush attempts (both by the lead rusher and by the team) and wins. The results showed that the model for rush attempts by the lead rusher and wins fit the data poorly. But the model for team rush attempts and wins did fit the data well (although we went on to show that the team rushing attempts wasn’t causing the winning).

We were able to conclude this by looking at the p-value and goodness-of-fit tests. But what if we wanted...

Say "I Love You" with Data on Valentine's Day

When we think about jobs with a romantic edge to them, most of us probably think of professions that involve action or danger.  Spies, soldiers, cops, criminals -- these are types of professions romantic leads have. Along with your occasional musician, reporter, or artist, who don't have the action but at least bring drama.

But you know who never shows up as a romantic lead?  Quality improvement professionals, that's who.  Can you name just one movie that features a dedicated data analyst or quality practitioner as the love interest...just one?  No, you can't.  Doesn't exist.

Love of Quality:...

Is Your Statistical Software FDA Validated for Medical Devices or Pharmaceuticals?

We're frequently asked whether Minitab has been validated by the U.S. Food and Drug Administration (FDA) for use in the pharmaceutical and medical device industries.

Minitab does extensive testing to validate our software internally, but Minitab’s statistical software is not—and cannot be—FDA-validated out-of-the-box.

Nobody's can.

It is a common misconception that software vendors can go through a certification process to achieve FDA software validation. It's simply not true.

Software vendors who claim their products are FDA-validated should be scrutinized. It is up to the software purchaser to...

Five Ways to Make Your Control Charts More Effective

Have you ever wished your control charts were better?  More effective and user-friendly?  Easier to understand and act on?  In this post, I'll share some simple ways to make SPC monitoring more effective in Minitab.

Common Problems with SPC Control Charts

I worked for several years in a large manufacturing plant in which control charts played a very important role. Virtually thousands of SPC (Statistical Process Control) charts were used to monitor processes, contamination in clean rooms, monitor product thicknesses and shapes as well as critical equipment process parameters. Process engineers...

(We Just Got Rid of) Three Reasons to Fear Data Analysis

Today our company is introducing Minitab 17 Statistical Software, the newest version of the leading software used for quality improvement and statistics education.    So, why should you care? Because important people in your life -- your co-workers, your students, your kids, your boss, maybe even you -- are afraid to analyze data.    There's no shame in that. In fact, there are pretty good reasons for people to feel some trepidation (or even outright panic) at the prospect of making sense of a set of data.

I know how it feels to be intimidated by statistics. Not long ago, I would do almost...

Gauging Gage Part 3: How to Sample Parts

In Parts 1 and 2 of Gauging Gage we looked at the numbers of parts, operators, and replicates used in a Gage R&R Study and how accurately we could estimate %Contribution based on the choice for each.  In doing so, I hoped to provide you with valuable and interesting information, but mostly I hoped to make you like me.  I mean like me so much that if I told you that you were doing something flat-out wrong and had been for years and probably screwed somethings up, you would hear me out and hopefully just revert back to being indifferent towards me.

For the third (and maybe final) installment, I...

Using nonparametric analysis to visually manage durations in service processes

My main objective is to encourage greater use of statistical techniques in the service sector and present new ways to implement them.

In a previous blog, I presented an approach you can use  to identify process steps that may be improved in the service sector (quartile analysis). In this post I'll show how nonparametric distribution analysis may be implemented in the service sector to analyze durations until a task is completed.

Knowing how much time you need to complete a task may be very useful when assessing process efficiency, and is an important factor in many businesses.

Consider a...

Lessons in Quality During a Long and Strange Journey Home

I didn’t expect that our family trip to Florida would end with me driving a plane load of passengers nearly 200 miles to their homes, but it did.

Yes, it was a long and strange journey home. A journey that started in the tropical warmth of southern Florida and ended the next morning in central Pennsylvania, which felt like the arctic wastelands thanks to the dreaded polar vortex.

During this journey, I didn’t just experience temperature extremes, but also extremely different levels in the quality of customer care. Working at Minitab, I'm very aware of the quality of service because quality...

Applying Six Sigma to a Small Operation

Using data analysis and statistics to improve business quality has a long history. But it often seems like most of that history involves huge operations. After all, Six Sigma originated with Motorola, and became adopted by thousands of other businesses after it was adopted by a little-known outfit called General Electric.

There are many case studies and examples of how big companies used Six Sigma methods to save millions of dollars, slash expenses, and improve quality...but when they read about the big dogs getting those kind of results, a lot of folks hear a little voice in their heads...