Control Chart – 2012 American Dream State Ranking Data

Ed Burghard

One of my favorite ways to look at data is by using a control chart. Typically control charts are used to evaluate data over time generated by a specific process. It is one of the Total Quality Management tools used in manufacturing to assess if a production line is in or out of control. But, another use of a control chart is to compare logically related observations taken at the same point in time. It is a quick way to determine which observations might be worth deeper consideration because they are behaving differently than the majority.

CREATE A CONTROL CHART IN  5 EASY STEPS

My 5-step process to create a control chart is simple and fast.

  1. Calculate the average score of the data set.
  2. Calculate the standard deviation of the data set.
  3. Set the upper control limit as the average + 1 standard deviation.
  4. Set the lower control limit as the average – 1 standard deviation.
  5. Plot the observations.

Any observations between the two control limits are considered “in control”. Typically, I don’t spend a lot of time on them. Observations above and below the control limits are what I focus on studying closer because their “aberrant” behavior often offers the best chance to learn something new.

If you have never used a control chart to analyze data, give it a try. It is one of the tricks I use to sort through a lot of data very quickly and prioritize where I dig deeper, I just recommend to use a VPN from https://privacyonline.com.br/ when doing this, it is always best to protect your data as much as possible. Excel has a function for calculating both the average and standard deviation of a data set, so the math isn’t really complicated.

2012 AMERICAN DREAM STATE RANKING DATA CONTROL CHART

I thought it would be interesting to control chart the American Dream Composite Index™ (ADCI) scores of the states used in the 2012 American Dream State Ranking Report. This is one way to quantitatively determine states may be worth a deeper exploration to better understand why people living there feel they are meaningfully over or under achieving the American Dream versus national average.

Here are the results of the control chart exercise.

Control Chart

Click on the image to make it larger.

DISCUSSION

The next step would be to try and answer why these states over or under performed the majority of states. I am publishing a series of case studies that compare the states based on the scores of the 35 dimensions that comprise the overall ADCI. The case studies look at published information for insight. But, the best way to understand why is through local market research to identify the specific drivers behind the sentiment. I am hopeful state economic development organizations will consider launching such research, particularly the states that are below the lower limit in the control chart. This type of study is not complicated. It can be designed and executed by any reputable market research firm.

Also, for some additional in depth information about Kaizen (total quality) tools I recommend you visit the Creative Safety Supply website.  The team there has done a great job pulling together a primer that is easy to read and apply.

Have you had any experience in using control charts? What tips can you provide on when and how to use them? Are you surprised by the states listed above and/or below the control limits?

Case Studies

Indiana versus Michigan

Florida versus North Carolina

New York versus New Jersey

California versus Texas

So, which states offer their residents the greatest chance of living the American Dream to the fullest, and which states are lagging behind?

To view the complete set of State rankings based on the ADCI and five explanatory sub-indexes, simply click this button

Ad 160X110

What do you think of this post?
  • Awesome (0)
  • Interesting (0)
  • Useful (0)
  • Boring (0)
  • Sucks (0)

3 Comments  |   Forward this to a friend Forward this to a friend   |   Number of emails sent: 542

Category Measures, Place Brand Building, Strategy

Bookmark and Share

You can follow any responses to this entry through the RSS 2.0 feed.

3 Comments so far

  1. […]   […]

  2. Brittany Holmes

    May 13, 2014

    I love a good case study. However, I can tell you I’ve been stuck in Indiana for nearly 15 years and now finally have a chance to get back into Michigan. I can’t wait to go back to Michigan where certain entities are regulated that are not at all here, where the pollution is far less (at least in the Michigan communities where I’ve lived) and where there are tenant rights associations to keep track of the slumlords coming in to buy property. Those are just a couple of the biggest reasons I cannot wait to get OUT of Indiana and INTO Michigan. I didn’t do enough research before I came to Indiana to live and work. I’m sorry I came here, but I learned a lot about poverty here. Please don’t be mislead by studies like these–go and see for yourself!

  3. Edward

    May 13, 2014

    Brittany – Going to see for yourself is always sage advice. However, it is important to understand the data in any study so you can put it in context. These specific data represent how people actually living in the state feel about the degree to which they are realizing their American Dream. I would argue that because the data represent a perspective of people actually living in the geography, it has merit and should be considered by anybody looking to live in or invest in the area. I am not sure your characterization of Indiana as an impoverished state is accurate. It certainly doesn’t align with my experience. Nor, is it aligned with the general sentiment of the Hoosiers who live there. And, since you are an N of 1 versus the statistically projectable sample represented in the study, your experience is more likely not the norm and should be evaluated in that context.

3 Responses to “Control Chart – 2012 American Dream State Ranking Data”




XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

By submitting a comment here you grant Strengthening Brand America a perpetual license to reproduce your words and name/web site in attribution. Inappropriate comments will be removed at admin's discretion.

SBA Blog