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

---

Management Consultants, Creativity, Innovation

Most firms have intelligent, capable, knowledgeable managers who are very... Read More

Another Use for Meetings

Every meeting is a laboratory where you can observe and... Read More

Communicating with Case Studies

A few weeks ago, a couple of colleagues and I... Read More

Leadership Style: What Makes A Good Boss?

In today's competitive environment, companies realize that a good boss... Read More

Hold Your Applause!

It's amazing what you can accomplish if you don't care... Read More

Medical Collection. How Organized is Your Office?

At one time or another, all of us have experienced... Read More

Your Biggest Problem in Business? Work Ethic

US Work Ethic Issues and Lack of serviceWell many... Read More

Results of Poor Cross Cultural Awareness

Results of Poor Cross Cultural Awareness. Having a poor understanding... Read More

Five Strategies To Strengthen Your Company?s Financial Management

Too many businesses wait until a crisis occurs before they... Read More

A Checklist for Organized Executives

I could begin this article by providing a checklist of... Read More

The Punitive Approach to Marginal Performers

MANAGING A MARGINAL PERFORMER: Often a marginal performer, even after... Read More

Business Intelligence & Data Warehousing in a Business Perspective

Business IntelligenceBusiness Intelligence has become a very important activity in... Read More

Biometrics and ?Return On Investment?

At this time of tight budgets, the mantra of business... Read More

Delegating Responsibility

Too many managers waste both time and energy performing tasks... Read More

Meetings: Don?t Just Show Up, Stand Out and Shine

Meetings, whether they're regularly scheduled routines in your company or... Read More

Beyond Management Coaching: When Things Are Getting Out of Control

Leaders and Managers often ask us, 'What do you do... Read More

How to Coach Your Employees - 5 Simple Steps Anyone Can Do!

Want to get more from your people, but you don't... Read More

Outsourcing NOT Just for Big Business

Outsourcing has become a controversial issue and a hot topic... Read More

Narcissism in the Boardroom

The perpetrators of the recent spate of financial frauds in... Read More

Innovation Management ? idea selection, development and commercialisation, what are the differences?

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

Effective Meetings - Quick Survey

Here's an easy quiz to check the health of your... Read More

Innovation Management ? Emotion, Habit, and Culture can be Hard to Change!

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

5 Ideas To Leverage The 3 Stages Of Career Development In Your Organization

In most industrialized nations, the average age a student graduates... Read More

Proven Secrets to Keeping Your People and Increasing Your Profits

Why are people changing jobs so quickly these days?Here are... Read More

6 Ways to Keep Things Simple

Six Ways to Keep Things Simple We can have greater... Read More

Think Twice Before Selling ROI

When we're selling to business people, our value proposition has... Read More

Questions To Ask Employees You Want To Retain

Times of cost cutting and downsizing has dramatically impacted the... Read More

Joint Accountability: Another Key for Your Effectiveness

I once was part of a group of management professors... Read More

Are You the Culprit?

Are you a business, non-profit or association manager who pretty... Read More

The Significance of the Mundane

This article begins with a tip of the hat to... Read More

I Am Not A Number - Why Too Many Change Projects Fail

Many of you will recognise this quote from the 1960s... Read More

Making Meetings Work

We have all attended meetings that were boring, mindless and... Read More

Using the Six-Sigma Methodology to Improve Wafer Fab Productivity

As a result of consolidation of operations and significantly increased... Read More