Decision Making Lab3
Laboratory work №3
Topic: Finding solutions based on binary relations preference.
"ELECTRE" method of thresholds of inequality
Goal of the work:
- study of the features of the application of binary relations of preference for decision-making;
- study of the "ELECTRE" method of inequality thresholds;
- implement the the "ELECTRE" method in the MS Excel environment.
The order of work
1. Study the features of binary relations preferences in decision-making and the decision-making algorithm by the method of "ELECTRE" inequality thresholds.
2. Present initial data and search for the optimal solution using the "ELECTRE" method in the MS Excel environment.
3. Make a graphic representation of the problem. Explain the result by showing the optimal solution on the graph. Demonstrate the process of finding solutions to the teacher.
4. Make a report on laboratory work.
5. Defend laboratory work.
Content of the report
1. Topic of the work.
2. Goal of the work.
3. Individual task.
4. Description of the work execution.
5. Interpretation of the obtained results.
6. Conclusions.
Individual tasks
According to the individual task (Table 1), find the best solutions by performing the necessary calculations in MS Excel. Set the values of the agreement and disagreement indices yourself.
Table 1
ID
|
Number of alter-natives
|
Number of criteria
|
Range of weighting factors for evaluation criteria
|
1
|
5
|
4
|
(1-10)
|
2
|
4
|
4
|
(1-5)
|
3
|
3
|
5
|
(1-20)
|
4
|
4
|
5
|
(1-12)
|
5
|
5
|
6
|
(1-10)
|
6
|
4
|
4
|
(1-5)
|
7
|
4
|
5
|
(1-10)
|
8
|
5
|
5
|
(1-12)
|
9
|
6
|
4
|
(1-5)
|
10
|
5
|
4
|
(1-10)
|
11
|
3
|
4
|
(1-12)
|
12
|
4
|
5
|
(1-20)
|
13
|
5
|
4
|
(1-7)
|
14
|
4
|
4
|
(1-10)
|
Theoretical material
"ELECTRE" method of thresholds of inequality
The ELECTRE methods (acronym stands for ELimination and ChoiceExpressingREality) is a family of multi-criteria decision analysis (MCDA) methods.
There are two main parts to an ELECTRE application: first, the construction of one or several outranking relations, which aims at comparing in a comprehensive way each pair of actions; second, an exploitation procedure that elaborates on the recommendations obtained in the first phase. The nature of the recommendation depends on the problem being addressed: choosing, ranking or sorting.
Criteria in ELECTRE methods have two distinct sets of parameters: the importance coefficients and the veto thresholds. ELECTRE method cannot determine the weights of the criteria.
Stages of the ELECTRE procedure:
1) for each criterion, a discrete scale of possible values of this criterion and weighting coefficients are assigned;
2) a graph is constructed for each criterion, the vertices of which are individual objects of the set and the arcs indicate the dominance relationship between objects according to this criterion;
3) taking into account the importance of the criteria and the preference of the objects, the matrices of the values of the special coefficients – indices of agreement and disagreement are calculated;
4) for each pair of objects (xi, xj) ∈ X, the preference ratio, xi over xj, is considered established if the value of the corresponding index of agreement is greater than some threshold value, and the index of disagreement is less than the corresponding threshold value.
5) a generalized preference graph is constructed, the structure of which depends on the selected threshold values.
Example.
Let X be the set of students participating in the scholarship competition.
It is necessary to determine the best candidates based on the conducted examinations.
The number, composition of disciplines and possible ways of evaluating students in disciplines may vary according to the specific features of the higher education institution.
Let's consider the evaluations of three students in three disciplines on a five-point scale (Table 2).
Table 2 - Assessments of the examination session
Student
|
Discipline
|
Mathematics
|
Physics
|
Computer graphics
|
х1
|
5
|
3
|
4
|
х2
|
5
|
4
|
3
|
х3
|
4
|
5
|
3
|
Notations:
x1, x2, x3 ∈ X the set of evaluated objects (students);
yi – grade of the object х∈Х according to the criterion i, i =1, m (grade by discipline);
cki – weight factor of the criterion ki, i =1,m (importance of the discipline);
0 < cki < 1(10,100, ...).
Let ck1 = 5, ck2 = 3, ck3 = 2.
For each criterion i we build a graph Gi = (X, Vi), where Vi is a set of graph arcs Gi.
An arc in the graph Gi from vertex хi to vertex xj exists if ai ≥ aj, equality of grades ai = aj in the graph is displayed as two arcs from хi to xj and from xj to хi.
Let's build graphs of binary relations for the disciplines specified in the problem.
Figure 1 – Graphs of binary relations in mathematics (a), physics (b) and computer graphics (c).
The combined graph characterizes the complete agreement of the preference of some objects over others.
Let's build a combined graph G0 = (X, V0), where is the intersection of three graphs with arcs Vi.
Figure 2 – Combined graph G0 = (X, V0)
In our example, V0 = {Ø}, since there are no arcs in the three graphs that coincide in direction at the same time.
Let's build a matrix of agreement indices of preference of objects:
Let's consider a couple of objects (xi, xj)∈ X. Regarding them, the set of all criteria can be divided into two "opposite" classes. To the first class C(xi, xj) we include all the criteria ki for which xi ≥ xj , i =1,m, j =1,m, that is, the criteria according to which in the graphs Gi there is an arc (xi, xj):
In criterion language, we will determine the advantages of alternatives by performing pairwise comparisons. Alternative x1 is better than x2 according to the criteria k1, k3; alternative x1 is better than x3 according to the criteria k1, k3; alternative x2 is better than x1 according to the criteria k1, k2, etc.:
C(x1, x2) = {k1, k3}, C(x1, x3) = {k1, k3},
C(x2, x1) = {k1, k2}, C(x2, x3) = {k1, k3},
C(x3, x1) = {k2}, C(x3, x2) = {k2, k3}.
Agreement indices express the degree of agreement with the preference of xi over xj .
We will calculate agreement indices using formulas
where cij is the value of the index of agreement with the preference of the alternative xi over xj;
cki is weight factor of the criterion ki ;
с is the sum of the coefficients of the criteria's importance;
m is the number of criteria.
In our example, ck1=5 – Mathematics, ck2=3 – Pphysics, ck3=2 – Computer graphics, respectively, с = ck1 + ck2 + ck3 =5+3+2=10.
We will calculate the values of the agreement index matrix:
c12=( ck1+сk3)/( ck1 + ck2 + ck3)=(5+2)/(5+3+2)=7/10=0.7;
c13=( ck1+сk3)/( ck1 + ck2 + ck3)=(5+2)/(5+3+2)=7/10=0.7;
c21=( ck1+сk2)/( ck1 + ck2 + ck3)=(5+3)/(5+3+2)=8/10=0.8;
c23=( ck1+сk3)/( ck1 + ck2 + ck3 k3)=(5+2)/(5+3+2)=7/10=0.7;
c31=( ck2)/( ck1 + ck2 + ck3)=(3)/(5+3+2)=3/10=0.3;
c32=( ck2+ ck3)/( ck1 + ck2 + ck3)=(3+2)/(5+3+2)=5/10=0.5.
Matrix of agreement indices C(xi, xj):
Let's build a matrix of indices of disagreement with the preference of objects.
Indices of disagreement express the degree of disagreement with the preference of xi over xj.
The second class D(xi, xj) includes pairs of objects (xi, xj) according to the criteria ki, for which in the graphs Gi there are no arcs (xi, xj):
На критеріальній мові визначимо відсутність переваг альтернатив, виконуючи попарні порівняння. Альтернатива x1 гірше ніж x2 за критеріями k2; альтернатива x1 гірше ніж x3 за критерієм k12; альтернатива x2 гірше ніж x1 за критерієми k13 і т.д.:
In criterion language, we will determine the lack of advantages of alternatives by performing pairwise comparisons. Alternative x1 is worse than x2 according to k2 criteria; alternative x1 is worse than x3 according to the criterion k12; the alternative x2 is worse than x1 according to the criteria k13, etc.:
Student
|
Discipline
|
Mathematics
|
Physics
|
Computer graphics
|
х1
|
5
|
3
|
4
|
х2
|
5
|
4
|
3
|
х3
|
4
|
5
|
3
|
D(x1, x2) = {k2}, D(x1, x3) = {k2},
D(x2, x1) = {k3}, D(x2, x3) = {k2},
D(x3, x1) = {k1, k3}, D(x3, x2) = {k1}
We will calculate the disagreement indices as follows:
,
where d=2 is the normalizing coefficient, which is equal to the maximum difference of grades on the entire set of criteria.
In our original table, the maximum score is equal to 5, and minimum is equal to 3, so d=5-3=2.
We will calculate the values of the matrix of disagreement indices:
d12= |y12-y22|/d=|3-4|/ 2 =1/2=0.5 (по предмету k2);
d13= |y12-y32|/d=|3-5|/ 2 =2/2=1 (по предмету k2);
d21= |y23-y13|/d=|3-4|/ 2 =1/2=0.5 (по предмету k3);
d23= |y22-y32|/ d =|4-5|/ 2 =1/2=0.5 (по предмету k2);
d31= max{|y31-y11|;|y33-y13|}/ d =max{|4-5|; |3-4|}/ 2 =1/2=0.5; (by subjects k1, k3);
d32= |y31-y21|/d =|4-5|/ 2 =1/2=0.5 (by subject k1).
Matrix of disagreement indices D(xi, xj):
Let's introduce the preference ratio on the objects through the threshold values p for the agreement indices (it should be closer to one) and q for the disagreement indices (it should be closer to zero).
The object xi has precedence over the object xj, if c(xi, xj) ≥ p and d(xi, xj) ≤ q, that is, the following conditions are met:
• set of criteria (taking into account their relative importance) according to which the alternative has a sufficient advantage (more than the threshold p);
• evaluations according to other criteria do not provide sufficient grounds for rejecting the preference (threshold q), the degree of distrust in this assumption does not exceed the permissible limit q.
Let's build a generalized preference graph for threshold values {1,0}:
For thresholds {1,0} all students are equal, it is impossible to make a choice.
Let's build a generalized preference graph for threshold values {0.8, 0.5}:
In this case, it can be concluded that preference should be given to the student х2.
Conclusions:
1) the method is designed to solve tasks in which a given number of the best alternatives must be selected from the available set of alternatives, taking into account their evaluations according to several criteria, as well as the importance of these criteria;
2) the application of the method made it possible to choose the best candidate for the scholarship.