The Elsmar Cove Forum and Site Map The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis


The Elsmar Cove Forum SideBar!
Monitor the Forum
Monitor New Forum Posts
New Threads Feeds
RSS FeedRSS Feed
Sponsor Link










$ Contributor Forum Access
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:


Howard's International Quality Services

Atul's Symphony Technologies

Dave Scott's Scott Quality Solutions

Praxiom Research Group


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality


All the Important Standards and Related Web Sites in the World
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 22nd September 2002, 06:32 AM
NITIN's Avatar
NITIN NITIN is offline
Involved - Posts

Registration Date: Apr 2002
Location: UAE
Age: 34
 
Posts: 33
Thanks Given to Others: 0
Thanked 1 Time in 1 Post
Karma Power: 31
Karma: 15
NITIN has less than 100 Karma points so far.
Let Me Help You What does a Pareto chart tell me that a pie chart doesn't?

Attached is a sample suvey that has been tabulated.Pray tell me what the Pareto is telling me which the pie is not.I see no reason to spend time doing a pareto when I can make the same deductions from a pie chart.
Or am I doing the wrong thing??
Please excuse my ignorance if you find this too dumb.

Last edited by NITIN; 22nd September 2002 at 06:43 AM.
Reply With Quote

Sponsored Links
  #2  
Old 22nd September 2002, 06:50 AM
NITIN's Avatar
NITIN NITIN is offline
Involved - Posts

Registration Date: Apr 2002
Location: UAE
Age: 34
 
Posts: 33
Thanks Given to Others: 0
Thanked 1 Time in 1 Post
Karma Power: 31
Karma: 15
NITIN has less than 100 Karma points so far.
Default oops-the attachment

Sorry-here is the attachment.This a random survey of a school cafetaria.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting the post it is in, 3. Use at your Own Risk.
File Type: xls survey.xls (138.5 KB, 371 views)
Reply With Quote
Sponsored Links

  #3  
Old 22nd September 2002, 10:47 AM
NITIN's Avatar
NITIN NITIN is offline
Involved - Posts

Registration Date: Apr 2002
Location: UAE
Age: 34
 
Posts: 33
Thanks Given to Others: 0
Thanked 1 Time in 1 Post
Karma Power: 31
Karma: 15
NITIN has less than 100 Karma points so far.
Default And another one

Just in case the other one did not make sense,a new one.
Again the same question-
What is the Pareto telling me that the pie chart cannot???
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting the post it is in, 3. Use at your Own Risk.
File Type: xls survey 2.xls (21.5 KB, 351 views)
__________________
We must be the world we want to create.
Reply With Quote
  #4  
Old 22nd September 2002, 10:59 AM
Ravi Khare's Avatar
Ravi Khare Ravi Khare is offline
Involved - Posts

Registration Date: Dec 2001
Location: Pune, India
Age: 48
 
Posts: 70
Thanks Given to Others: 0
Thanked 3 Times in 3 Posts
Karma Power: 35
Karma: 58
Ravi Khare has less than 100 Karma points so far.
Default

Nitin,

In principle, the Pie Chart would show you the distribution of data across parameters ( looks like complaints in your case) while Pareto Chart would also find the cumuative distribution. It is a well known theory formulated by Pareto that 80% of the effects are caused by only 20% of the causes, or in such cases 80% of the trouble is caused by 20% of the causes. A Pareto Chart will help you to identify those top 20% of the causes and prioritize the course of action.

I have perhaps reiterated what you already know.

Analyzing your spreadsheet, it looks like there are only 5 categories that share a fair amount of % of complaints each ( between 15 to 25%) giving an appearance that all categories are contributing almost equally to the complaints. In such a case I would try to resolve my survey into more specific and more categories of complaints. Frame more specific questions within each category. This should bring the picture out more clearly. Higher the resolution of the measurement system, more the information you will be able to get.

Hope this helps.
Reply With Quote
  #5  
Old 22nd September 2002, 11:03 AM
Ravi Khare's Avatar
Ravi Khare Ravi Khare is offline
Involved - Posts

Registration Date: Dec 2001
Location: Pune, India
Age: 48
 
Posts: 70
Thanks Given to Others: 0
Thanked 3 Times in 3 Posts
Karma Power: 35
Karma: 58
Ravi Khare has less than 100 Karma points so far.
Default

I was composing the reply while you posted the second Excel file.

You can see yourself that your second survey brings out the 80-20 law clearly.
Reply With Quote
  #6  
Old 22nd September 2002, 11:56 AM
NITIN's Avatar
NITIN NITIN is offline
Involved - Posts

Registration Date: Apr 2002
Location: UAE
Age: 34
 
Posts: 33
Thanks Given to Others: 0
Thanked 1 Time in 1 Post
Karma Power: 31
Karma: 15
NITIN has less than 100 Karma points so far.
Default

Hi Ravi,
I am not disputing the law.What I am saying is that to anybody who is aware of the "law' the same deduction can be made by looking at the Pie chart.What additional information does the Pareto Chart give me to help me zero in or prioitise my efforts?Looking at the Pie,I would for example decide to go after the big slices first.Looking at the Pareto,it tells me exactly the same thing.So why all this cumulative percentage conversion,charting plotting etc ?
__________________
We must be the world we want to create.
Reply With Quote
  #7  
Old 22nd September 2002, 12:16 PM
Ravi Khare's Avatar
Ravi Khare Ravi Khare is offline
Involved - Posts

Registration Date: Dec 2001
Location: Pune, India
Age: 48
 
Posts: 70
Thanks Given to Others: 0
Thanked 3 Times in 3 Posts
Karma Power: 35
Karma: 58
Ravi Khare has less than 100 Karma points so far.
Default

Sure, the pie chart would indeed tell you which slices are big and which are small.

It pays to measure numerically though, rather than describing the slices as merely big or small. The question of how big a slice should be described as big enough for attention becomes subjective. You will have to do a quick mental arithmetic to arrive at the cumulative 80% of the slices.

Once I have the cumulative frequency curve in a Pareto Chart, the method I commonly use is to project the 80% mark from the Y axis to the curve, and drop the intrecept down on the x axis from that point. All bars to the left of this dividing line can be treated as important, since they will be addressing 80% of the effects. Once this is done, I turn my attention to another process where another 80% of pressing matters demand attention.

I find this a very effective way to prioritize.

Let's say the Pareto Chart makes the 80-20 law more 'visible'.
Reply With Quote
  #8  
Old 23rd September 2002, 08:09 AM
D.Scott's Avatar
D.Scott D.Scott is offline
Super Moderator

Registration Date: Feb 2001
Location: Wellington, OH USA
Age: 69
 
Posts: 1,604
Thanks Given to Others: 80
Thanked 289 Times in 172 Posts
Karma Power: 149
Karma: 4082
D.Scott is appreciated, and has over 1700 Karma points.
D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.D.Scott is appreciated, and has over 1700 Karma points.
Send a message via Yahoo to D.Scott
Default

Spot on Ravi. Another consideration is that a Pareto is easier to handle when there are larger numbers of catagories. The more slices you make in a pie, the harder it becomes to read it accurately. Besides there is no real challenge in spelling "pie".

Dave
Reply With Quote
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis

Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors and 1 Unregistered Guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Elephant Chart Nonconformance Tracking .xls Chart - Analysis tool developed for EMS Jennifer Kirley Quality Tools, Improvement and Analysis 5 15th May 2009 11:04 AM
Sorting in Microsoft Excel .xls - I want to create a Pareto Chart Winner Excel .xls Spreadsheet Templates and Tools 15 24th April 2009 06:25 PM
Minitab Pareto Chart Text Adjustment Michaelk Using Minitab Software 10 5th August 2008 09:42 AM
U chart and X & s chart - Seeking Excel .xls templates / forms KidPaddy Excel .xls Spreadsheet Templates and Tools 3 4th October 2006 12:42 AM
U-chart Sanity/File Review - Is the chart constructed properly? Phil Fields SPC Monitoring and Statistical Analysis Techniques 2 19th July 2006 07:56 AM



The time now is 05:12 AM. All times are GMT -4.
The time zone can be changed in your UserCP --> Options.



   

All Y'All Come Back Now, Y' Hear?

Made With A Mac! FreeBSD OS Powered by Apache!
Using php4 Forums provided and maintained by Marc Smith Database by MySQL

FAIR USE and CORRECTNESS NOTICE: This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe herein constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those who have expressed a prior interest in receiving the included information for research and educational purposes. For more information go to: http://www.law.cornell.edu/uscode/17/ If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner. In addition, I do not guarantee the correctness of the content. The risk of using content from the Elsmar Cove web site and forums remains with the user/visitor.

Responsibility Statement: Each person is responsible for anything they post in the Elsmar Cove forum. Neither I, Marc Timothy Smith, nor any of the forum Moderators, are responsible for the content of posts people make. Liability for post content resides with the poster as does interpretation and/or acceptance and/or use of advice by the reader.

Complaints: If you have a complaint with a post in a forum discussion thread, including Content in general, fighting, flaming, copyright infringement, defamation and/or 'slander', please use the 'Report This Post Report This Post Button button which appears at the top of every post in every thread.

Site courtesy of:
Marc Timothy Smith - Cayman Business Systems, 8466 Lesourdsville-West Chester Road, West Chester, Ohio 45069-1929 - USA
(513) 341-6272

To contact me, click the Google Voice link below, enter Your Name and Your Phone Number and Google will ring your phone and connect you for free!

The Elsmar Cove Web Site is *CopyFree*
no new posts