I Said Pareto Chart? Not Potato Chart!

Home
>
Business Management
>
I Said Pareto Chart? Not Potato Chart!

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:

Yahoo! News: Top Stories

Key panel recommends impeaching Ill. governor (AP)

AP - A key panel unanimously recommended impeachment for Gov. Rod Blagojevich on Thursday, setting up a vote that could make him the first governor to face such fate in Illinois' sordid political history. Blagojevich should lose his job for abusing power, mismanaging government and committing possible criminal acts, including federal allegations he tried to sell off a U.S. Senate seat, the special committee concluded.

Cheney: CIA did nothing illegal in interrogations (AP)

AP - Vice President Dick Cheney said Thursday that he sees no reason for President George W. Bush to pre-emptively pardon anyone at the CIA involved in harsh interrogations of suspected terrorists. "I don't have any reason to believe that anybody in the agency did anything illegal," he said.

UN halts Gaza aid as deal OK'd on truce resolution (AP)

AP - The U.N. suspended food deliveries to Gaza and the Red Cross accused Israel of blocking medical assistance after forces fired on aid workers, killing two, as the threat of a wider conflict emerged with Lebanon. With violence unabated in Gaza, key Arab nations and Western powers reached an agreement Thursday on a proposed U.N. resolution calling for an immediate and durable cease-fire between the two sides and moved for a vote late Thursday night.

Democrats criticize Obama's proposed tax cuts (AP)

AP - President-elect Barack Obama's proposed tax cuts ran into opposition Thursday from senators in his own party who said they wouldn't do much to stimulate the economy or create jobs. Senators from both parties agreed that Congress should do something to stimulate the economy. But Democratic senators emerging from a private meeting of the Senate Finance Committee criticized business and individual tax cuts in Obama's stimulus plan.

Obama: Congress must act boldly and now on economy (AP)

AP - President-elect Barack Obama implored Congress on Thursday to "act boldly and act now" to fix an economy growing perilously weaker. Leading lawmakers set an informal goal of mid-February for enacting tax cuts and government spending that could cost as much as $1 trillion.

Madoff 'victims' do math, realize they profited (AP)

AP - The many Bernard Madoff investors who withdrew money from their accounts over the years are now wrestling with an ethical and legal quandary.

Fatal police shooting sparks violent protests (AP)

AP - In grainy cell-phone videos played over and over on the Internet, police officers force an unarmed black man to the ground and hold him face-down on a crowded train platform. Suddenly one of the officers draws his gun and fatally shoots the man in the back then looks up.

Court papers: Gotti neighbor was dissolved in acid (AP)

AP - It is perhaps the most intriguing unsolved mystery from the gaudy gangland career of John Gotti: Whatever happened to the neighbor who accidentally ran over and killed the mobster's 12-year-old son and then vanished?

Man allegedly caused flats with nails in driveways (AP)

AP - Police in upstate New York say a man has been sprinkling roofing nails on the driveways of people he didn't like to cause flat tires for two years. Stony Point police Lt. Peter Quinn said Michael Delisio was arrested Tuesday after an officer staking out one victim's home saw nails being thrown from Delisio's car.

Florida, Oklahoma play for college football crown (AP)

AP - The Oklahoma Sooners and the Florida Gators meet tonight for the BCS championship. It's a matchup that includes a pair of Heisman Trophy winners, an SEC vs. Big 12 debate and more than its share of trash talk.

Israel faces criticism as Gaza toll hits 765 (Reuters)

Reuters - Recovery teams ventured into battlegrounds of the Gaza Strip on Thursday to gather bodies from the rubble, and Hamas officials said the Palestinian death toll in Israel's 13-day-old offensive had risen to 765.

Obama pushes stimulus, warns on recession (Reuters)

Reuters - President-elect Barack Obama warned on Thursday the U.S. economy could stay mired in recession for years without bold action and he urged lawmakers to work day and night to pass a massive stimulus plan.

Citi backs measure to help avoid foreclosures (Reuters)

Reuters - Financial giant Citigroup Inc will support a proposal in Congress to rewrite U.S. bankruptcy law to help troubled mortgage borrowers avoid foreclosure, Chief Executive Vikram Pandit said on Thursday.

U.S., Iran share interests in Afghanistan: Petraeus (Reuters)

Reuters - The United States and its allies share some interests with Iran when it comes to stabilizing Afghanistan, Army Gen. David Petraeus, head of the U.S. military's Central Command, said on Thursday.

Illinois panel recommends governor's impeachment (Reuters)

Reuters - A legislative committee on Thursday recommended the impeachment of Illinois Gov. Rod Blagojevich, citing widespread abuse of power including allegations he tried to sell the U.S. Senate seat vacated by President-elect Barack Obama.

Madoff had $173 million in checks ready, U.S. says (Reuters)

Reuters - Accused swindler Bernard Madoff had signed checks totaling more than $173 million in his office desk ready to be sent out before his arrest, U.S. prosecutors said in court papers on Thursday asking a judge to jail him.

Obama names Virginia gov as Democratic Party head (Reuters)

Reuters - President-elect Barack Obama named Tim Kaine as head of the Democratic Party on Thursday, rewarding an early supporter with a high-profile political post even as he continues to serve as Virginia governor.

Wal-Mart and other U.S. retailers warn after dismal holiday (Reuters)

Reuters - Wal-Mart Stores Inc and other top U.S. retailers delivered disappointing December same-store sales and profit warnings on Thursday, sparking fresh recession concerns that hit stock and currency markets.

Diplomats push for Gaza ceasefire as UN agency halts work (AFP)

AFP - Diplomatic efforts to end the Gaza conflict intensified Friday with Western and Arab diplomats agreeing to call for an immediate ceasefire as the death toll from the two-week-old war rose past 760.

EU announces breakthrough in Russia-Ukraine gas dispute (AFP)

AFP - Russian Prime Minister Vladimir Putin agreed Thursday on the terms for the deployment of gas monitors in Ukraine, paving the way for an end to a Europe-wide energy crisis, the EU presidency said.

I Said Pareto Chart? Not Potato Chart!

Business Management Business Management