I Said Pareto Chart? Not Potato Chart!

Does this sound familiar? You were hired for the new management position. You were tasked to turn the numbers around. You take some time reviewing the current situation. Now it's time to take a look at the current processes and get your staff together to analyze the data. You tell them that you want to brainstorm; work on a few mind maps, whip out a couple Ishikawa's to get started and then have them bring Pareto charts relative to their respective functions.

One of your department heads looks at you and asks "Ishiwhat?" "You know," you reply, "a fishbone diagram." Still blank stares. "Cause and effect?" you say as you scribble out a trout carcass on your white board. Still nothing. You're starting to think the elevator doesn't go all the way to the top. You've got your work cut out for you. So you decide to punt. "Ok, let's just start with the Pareto charts," you concede. "Sir, what is a potato chart?" asks another supervisor. "Let's take a five minute stretch break and then meet back in here so that I can welcome you to the world of Pareto charts.

A Pareto chart looks similar to a bar chart. It has columns and it also has a line graph. Generally number of occurrences (frequency) is listed on the left side and percentage on the right. This type of chart is used to graphically summarize and display the relative importance of the differences between groups of data. For example, perhaps you have determined, or at least speculate that your widgets are being rejected due to ? improper fittings, defective sorting machine, too large or too small, or other. If you look at the reports or studies and gather data on each of these reasons for failure, you can then plug the numbers into a chart. You may have assumed the reason for rejection was because the widgets were too large to fit through the tunnel. However your numbers may actually show (the data will validate) that indeed there was nothing wrong with the size of the widget, but rather the sorter was bent, thereby causing the good pieces to bounce into the reject bin.

Typically you isolate five categories to measure. A Pareto chart can be constructed by separating the data into categories. Let's look at another example. If your business was investigating the delay associated with processing mortgage applications, you could group the data into the following categories: No signature, address not valid, illegible handwriting, existing customer and other.

The left-side vertical axis of the Pareto chart is labeled Frequency (the number of counts for each category), the right-side vertical axis of the Pareto chart is the cumulative percentage, and the horizontal axis of the Pareto chart is labeled with the group names (categories) of your response variables. Are you getting the idea? Your bottom row will be labeled: No signature, address not valid, illegible handwriting, existing customer and other. Each title will have a corresponding column associated with it.

Next determine the number of data points that reside within each group and construct the Pareto chart in a spreadsheet program; Excel works very well for these types of charts. The difference between a Pareto and a typical bar chart is that the Pareto chart is ordered in descending occurrence importance.

Once you have your Pareto constructed and you can visually see what the data is telling you, and you will be able to answer a few questions. You will be able to determine the largest issues facing your team, department or business; you will be able to see what 20% of sources are causing 80% of the problems; and lastly you will know where you should focus your efforts to achieve the greatest improvements.

No more guess work. You won't be needlessly wasting more time and money trying to fix problems that weren't broken. Call a staff meeting and get to work on your potato, er a Pareto Charts!

Martin is w well-known speaker for Business Management and Event Planning Management. He always hold talks and was always visited as a guest speaker at Event Planning and Business Management. Get more info at http://event-planning.eclicksoft.com

In The News:


pen paper and inkwell


cat break through


Innovation Management ? Diversity Can Make All The Difference

Companies are welcoming a diverse range of employees (The Sunday... Read More

Smart Choices: How to Hire the Best

Your organization's continued growth and success depend on making smart... Read More

How To Rebuild Trust

Here are some quick thoughts on ways to turn things... Read More

Communicating CEOs

I see a PR firm has done a survey on... Read More

The Dog That Didnt Bark

A few weeks ago, after consultations with others in an... Read More

Quality Staffing: Stop Placing the Wrong People in the Wrong Jobs

You can possibly teach a turkey to climb a tree... Read More

Operating on Perpetual Overload?

Check Out Your E-HabitsAnother week has ended. And, despite moving... Read More

The Best Way to Keep Track of Meetings

How should you keep track of meetings?Have you ever wanted... Read More

The New Five Truths of Employee Motivation

Motivation is a term that is so widely used, yet... Read More

How to Attract and Retain the Right People

If you're one of the many executives struggling with finding... Read More

How to Meet Quality Standards with ISO 9001

In today's hectic business environment, it is vital that we... Read More

Knowledge Mapping

This module focuses on the basics of Knowledge Mapping, its... Read More

Five Ways to Influence Change in Others

Because of my work as a consultant, trainer and coach... Read More

Stopping The Brain Drain: How To Capture Key Business Knowledge Before It Walks Out The Door

The verdict is in: More and more baby boomers will... Read More

Is ISO 9001 2000 Right For My Business?

Firstly you should decide your own reasoning behind considering ISO... Read More

What is the Most Difficult Part of an Improvement Program?

Answer: Starting one.Most of us realize that there is probably... Read More

Key Control ? Who Has the Keys to Your Kingdom?

Key control, or more accurately the lack of key control... Read More

The Crisis of Modernity

Since the beginning of the industrial era our world has... Read More

Behavioral Extensions and Its Implications at Workplaces

The study of Behavioral extension involves investigating the source of... Read More

Keeping and Motivating the Best Employees

Keeping and Motivating the Best Employees ... Read More

Whatever it Takes!

I have a sign on my office door. It pretty... Read More

Saying ?No? Gracefully to Customers and Colleagues

Envision the scenario: You've just been asked at the last... Read More

Encouraging Behavior That Gets Results

You're the boss, and you have every reason to feel... Read More

Negative Self-talk is Too Expensive

I'm always fascinated by the people who lift huge weights,... Read More

Better Manager Skills - How to Learn

When you first take over a department, expectations are usually... Read More

Top 7 Methods to Empower Employees

How many times have you asked someone to do something... Read More

Business Innovation ? Core Competency and Competitive Advantage

Creativity can be defined as problem identification and idea generation... Read More

Partnering for Performance

"The difference between a boss and a leader: a boss... Read More

Best Practices Plan: Dissemination of a Great Idea

Good news spreads quickly News of the invention of the... Read More

Birds of a Feather May Be Turkeys

Birds of a Feather May Be TurkeysBy Gene Griessman, PhD... Read More

Increasing Employee Retention Through Employee Engagement

You've seen it happen many times. An organization that provides... Read More

Dont Sweat the Small Stuff with Your Credit Policy

Do you know how many customers you have that are... Read More

To Outsource or Not to Outsource

In these days of restricted head count and tight budgets,... Read More