Diagrama de Pareto: Qué es y cómo se hace. Ejemplo práctico paso a paso - YouTube

Today we are going to understand what the Pareto chart is, how it is made and we are going to elaborate an example of its

application. In Excel, the Pareto chart, also called the 80/20 curve,

wall analysis or ABC distribution, is the product of rigorous analyzes carried out by Vilfredo

Pareto, which allowed scholars to establish through empirical foundations

that 80% of the consequences of a phenomenon is caused by 20 percent of the causes

what I have told you is known as the wall rule but then what is the

wall diagram in the expression of the rule made through a

bar chart which concentrates the causes in descending order, what it allows us to do is identify

which is that 80% that generates the problems in order to concentrate our efforts on their solution

. If we go to a company, what is the wall diagram for

? as one of the seven quality tools, it allows us to carry

out continuous improvement, to show how this is a situation before and after being intervened

and to analyze and prioritize pr problems but you are wondering how to make a wall diagram

first of all define what you want to do what situation you are in what is

the problem situation or phenomenon to analyze second define what are the causes or factors

that you are going to analyze and then collect all the data around them in the third

step the collected data will be sorted from highest to lowest and with this

you will be able in the fourth step to start making the necessary calculations you will calculate the accumulated

percentage and accumulated percentage so finally you will be able to graph the

wall diagram its causes will be on the x axis on the left axis it will be placed on the accumulated

and on the right axis you will have the accumulated percentage that remains then to

analyze and make the respective decisions all this we are going to understand better with an example

first of all we have to determine what is the situation that is occurring what

is the phenomenon of analysis q What are we going to solve in this case? We have an increase of 35% in the

complaints and claims received in quarter 3 of the current year. It is a significant increase, therefore, we

must go on to determine why it is happening, what is its solution, then we determine by what

is happening what are the main complaints that are being presented we have for a review of the

two pps complaint mailboxes that there are ten main types of complaints we have established

the categories and we have cut them according to the customer complaints what is the frequency

of each of the complaints, being for example that the after-sales service does not appear on time,

the most frequent complaint with 26 and the operation of the product is confusing as the one that has

presented the least with only 1, we order this from greater At least as you can see we have

already done it and from now on we are going to do the respective calculations to then have our

wall grass we already have the frequency of the data collected v We are going to determine the percentage

basically the percentage in the representation of each of these causes within the total

so first of all we are going to know how many there are in total we make the sum

of the frequency of all these causes and we have a total of 86 complaints we are going to get

the representation of each one of the complaints within the 86 therefore we divide 26 divided

86 and we do the same for the others

well we can verify that what we have done is good because when we add them it should give us

100% with this clear we are going to calculate the percentage as a side that is the accumulated percentage is the

sum of the percentage of all the complaints one after another I explain myself in the first in the first

in the first cause accumulated percentage as we only have one it is the same percentage 30% without however

in the second we are going to add 30% with the percentage of the second cause which is 23% in this case 53

percent in this way the function if we go to the operation of the product cto is confusing that it is the

last complaint the accumulated sum of all of all the causes should give me 100% let 's see

if it is indeed 100% with this of course we already have all the data to start making the

wall diagram on the axis x we are going to place the causes that we have the 10 causes that we have on the

left axis we are going to have the data collected or the frequency depending on the nature of the

problem that we are dealing with and on the right axis we are going to place the accumulated percentage

with this clear we go to have the control key one day we are going to select the causes

the percentage and the percentage as a side we are going to insert and place a bar graph

as you can see effectively the causes are on the x-axis

and the data collected are the blue ones found in the y-axis, however, the

accumulated percentage, which are the orange ones, is also found on the left axis, therefore we are going to

change the axis to the accumulated percentage and we are going to place it on the we right click on

them we are going to change the type of graph and where it says accumulated percentage we are going to give it that secondary

and we are going to change it so that it is a line graph it can be a line graph or

pillar line with markers I prefer sharp line with markers and With this we already have our wall diagram

, so look what and the analysis that we are going to do is where the 80% is concentrated,

well in this case it is 72%, this means that 72% of the complaints

received in the quarter 3 of the current year is generated by three main causes the after-

sales service does not show up on time the after-sales staff does not know how to install the product and the

contact center staff is rude or does not have a service attitude than what we are going to do

then we are going to focus all our efforts to improve the after-sales service in terms

of time and quality in addition to those I don't know I imagine that we can do new training

and Establishing new new forms of measurement to determine how good the service that

the contact center staff is providing are examples of some actions that we can do

what we do has to solve the focus of what causes the whole problem that in this case They are

the first three causes. Well, with this, of course, we have finished our Pareto diagram. Of course, we can do another analysis. Of course,

we can focus on solving these three causes and

then reapply the Pareto diagram to solve the previous causes.

prepared a wall diagram template that will allow you to do

all this work automatically, the only thing you will have to do is write what are the

causes around the phenomenon you are analyzing and the frequency or data collected from each

of them with this and through automatic calculations you will be able to obtain the Pareto diagram

so that you can analyze what you have what to do is enter the dotcom

pareto diagram company ingenuity and at the bottom go to the pareto diagram excel template and you will only have

to download it and with this we finish I hope it has been useful see you another time