Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to draw a Pareto chart in Microsoft Excel? What is it's significance in Quality Management?

user-image
Question ajoutée par Adnan Sardar , Assistant Director (Technical) , Local Government, KPK
Date de publication: 2016/10/19
Mohamed Ezzdin
par Mohamed Ezzdin , QHSE manager , Ostool Transport Co.

To build Pareto Chart using Excell Do the following

  1. Set up your data. ...
  2. Sort your data from largest to smallest amount. ...
  3. Use the SUM() function to add your Amount range. ...
  4. Create a Cumulative Amount column. ...
  5. To automatically fill the rest of the column, double click the Autofill Handle.
  6. Next, create a Cumulative Percent column.

 

Pareto Chart is very significant tool for Quality Managment as it derives you to solve 80% of the problems which is always due to 20 % of the causes. but using it depends on the type of buisiness you are woeking in and how you categorize your data. If you need any further assistance you can e-mail me

Muhammad Zahid
par Muhammad Zahid , IT Project Manager , Cozmuler (PVT) Ltd

How to draw a Pareto chart in Microsoft Excel?

Please visit the following link

http://www.brighthubpm.com/templates-forms/8708-creating-pareto-charts-with-microsoft-excel/

 

What is it's significance in Quality Management?

http://blog.dataparcsolutions.com/using-pareto-charts-for-quality-control

More Questions Like This