5 5 FULLER'S METHOD specification of weights for selected criteria on 09.05.2018 - 10:16:12 Input data for calculation of weights: Points Weights income (USD) 1 0.10000 housing expediture (%) 3 0.30000 employment rate (%) 2 0.20000 life expectancy 4 0.40000 homicide rate 0 0.00000 Fuller's triangle (Use shortcut Ctrl+J for change in preferences): income (USD) income (USD) income (USD) income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate housing expediture (%) housing expediture (%) housing expediture (%) employment rate (%) life expectancy homicide rate employment rate (%) employment rate (%) life expectancy homicide rate life expectancy homicide rate ##### Sheet/List 2 ##### 5 5 1 SAATY'S PROCEDURE 2 specification of weights for selected criteria 3 on 09.05.2018 - 10:17:00 4 5 6 Input data for calculation of weights: 7 Points Weights 8 income (USD) 1.44332 0.26659 9 housing expediture (%) 0.92373 0.17094 employment rate (%) 0.52234 0.09712 life expectancy 2.25568 0.41876 homicide rate 0.25023 0.04660 Lambda 5.39529 Consistency YES Saaty's triangle (Use shortcut Ctrl+J for change in preferences): CI 0.09882 Iteration 4 income (USD) income (USD) income (USD) income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate 3 3 3 5 housing expediture (%) housing expediture (%) housing expediture (%) employment rate (%) life expectancy homicide rate 3 3 5 employment rate (%) employment rate (%) life expectancy homicide rate 3 3 life expectancy homicide rate 5 Saaty's matrix: income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate income (USD) 1.00000 3.00000 3.00000 0.33333 5.00000 housing expediture (%) 0.33333 1.00000 3.00000 0.33333 5.00000 employment rate (%) 0.33333 0.33333 1.00000 0.33333 3.00000 life expectancy 3.00000 3.00000 3.00000 1.00000 5.00000 homicide rate 0.20000 0.20000 0.33333 0.20000 1.00000 ##### Sheet/List 3 ##### 5 5 Weighting sum approach - WSA Actual problem for 5 alternatives and 5 criteria on 09.05.2018 - 10:19:54 Input data: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 24 72 78.7 0.8 Austria 32544 21 72 81.3 0.4 Germany 33652 20 75 80.7 0.4 Poland 18906 23 65 76.7 0.8 Slovak Republic 20256 24 65 77.6 1.3 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Modified input data: MAX MAX MAX MAX MAX income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 0 72 78.7 0.5 Austria 32544 3 72 81.3 0.9 Germany 33652 4 75 80.7 0.9 Poland 18906 1 65 76.7 0.5 Slovak Republic 20256 0 65 77.6 0 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Ideal 33652 4 75 81.3 0.9 Basal 18906 0 65 76.7 0 Normalised criterion matrix R: MAX MAX MAX MAX MAX income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate u(alternat) Czech Republik 0.14899 0.00000 0.70000 0.43478 0.55556 0.31566 Austria 0.92486 0.75000 0.70000 1.00000 1.00000 0.90810 Germany 1.00000 1.00000 1.00000 0.86957 1.00000 0.94538 Poland 0.00000 0.25000 0.00000 0.00000 0.55556 0.06862 Slovak Republic 0.09155 0.00000 0.00000 0.19565 0.00000 0.10634 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 ##### Sheet/List 4 ##### 5 5 TOPSIS Method Actual problem for 5 alternatives and 5 criteria on 09.05.2018 - 10:20:11 Input data: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 24 72 78.7 0.8 Austria 32544 21 72 81.3 0.4 Germany 33652 20 75 80.7 0.4 Poland 18906 23 65 76.7 0.8 Slovak Republic 20256 24 65 77.6 1.3 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Modified input data: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 24 72 78.7 0.8 Austria 32544 21 72 81.3 0.4 Germany 33652 20 75 80.7 0.4 Poland 18906 23 65 76.7 0.8 Slovak Republic 20256 24 65 77.6 1.3 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Normalised criterion matrix R: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 0.36167 0.47790 0.46053 0.44540 0.44105 Austria 0.55774 0.41816 0.46053 0.46012 0.22053 Germany 0.57673 0.39825 0.47972 0.45672 0.22053 Poland 0.32401 0.45799 0.41575 0.43409 0.44105 Slovak Republic 0.34715 0.47790 0.41575 0.43918 0.71671 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Weighted criterion matrix W: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate di+ di- ci Czech Republik 0.09642 0.08169 0.04473 0.18652 0.02055 0.06016 0.01752 0.22558 Austria 0.14869 0.07148 0.04473 0.19268 0.01028 0.00638 0.06826 0.91454 Germany 0.15375 0.06808 0.04659 0.19126 0.01028 0.00142 0.07340 0.98099 Poland 0.08638 0.07829 0.04038 0.18178 0.02055 0.07005 0.01329 0.15946 Slovak Republic 0.09255 0.08169 0.04038 0.18391 0.03340 0.06769 0.00653 0.08794 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Ideal 0.15375 0.06808 0.04659 0.19268 0.01028 Basal 0.08638 0.08169 0.04038 0.18178 0.03340 ##### Sheet/List 5 ##### 5 5 ELECTRE I Method Actual problem for 5 alternatives and 5 criteria on 09.05.2018 - 10:20:36 Input data: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 24 72 78.7 0.8 Austria 32544 21 72 81.3 0.4 Germany 33652 20 75 80.7 0.4 Poland 18906 23 65 76.7 0.8 Slovak Republic 20256 24 65 77.6 1.3 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Modified input data: MAX MAX MAX MAX MAX income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 0 72 78.7 0.5 Austria 32544 3 72 81.3 0.9 Germany 33652 4 75 80.7 0.9 Poland 18906 1 65 76.7 0.5 Slovak Republic 20256 0 65 77.6 0 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Matrix C: Czech Republik Austria Germany Poland Slovak Republic Czech Republik --- 0.09712 0.00000 0.82906 1.00000 Austria 1.00000 --- 0.46535 1.00000 1.00000 Germany 1.00000 0.58124 --- 1.00000 1.00000 Poland 0.21753 0.00000 0.00000 --- 0.31465 Slovak Republic 0.17094 0.00000 0.00000 0.78247 --- Matrix D: Czech Republik Austria Germany Poland Slovak Republic Czech Republik --- 1.00000 1.00000 0.00046 0.00000 Austria 0.00000 --- 1.00000 0.00000 0.00000 Germany 0.00000 0.00054 --- 0.00000 0.00000 Poland 1.00000 1.00000 1.00000 --- 1.00000 Slovak Republic 1.00000 1.00000 1.00000 0.00074 --- Matrix P: EFEKT Czech Republik Austria Germany Poland Slovak Republic Czech Republik 0 0 0 1 1 Austria 1 0 0 1 1 Germany 1 1 0 1 1 Poland 0 0 0 0 0 Slovak Republic 0 0 0 1 0 C = 0.50000 D = 0.50000 ##### Sheet/List 6 ##### 5 5 1 - general PROMETHEE method 2 - quasi Actual problem for 5 alternatives and 5 criteria 3 - linear on 09.05.2018 - 10:21:28 4 - level 5 - indiffer 6 - Gauss Preference function: 3 3 3 3 3 income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate q-indif p-abs-pref 10000 2 2 1 0.2 sigma Input data: MAX MIN MAX MAX MIN income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 24 72 78.7 0.8 Austria 32544 21 72 81.3 0.4 Germany 33652 20 75 80.7 0.4 Poland 18906 23 65 76.7 0.8 Slovak Republic 20256 24 65 77.6 1.3 Weights 0.26659 0.17094 0.09712 0.41876 0.04660 Matrix A: Czech Republik Austria Germany Poland Slovak Republic F(+) F Czech Republik 0.00000 0.00000 0.00000 0.57445 0.58505 0.28988 -0.20721 Austria 0.90288 0.00000 0.25125 1.00000 1.00000 0.78853 0.73550 Germany 1.00000 0.21213 0.00000 1.00000 1.00000 0.80303 0.74022 Poland 0.08547 0.00000 0.00000 0.00000 0.13206 0.05438 -0.69245 Slovak Republic 0.00000 0.00000 0.00000 0.41287 0.00000 0.10322 -0.57606 F(-) 0.49709 0.05303 0.06281 0.74683 0.67928 ##### Sheet/List 7 ##### 5 5 Multicriteria evaluation of alternatives input and edit of data on 09.05.2018 min max 2 1 2 2 1 income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Test Czech Republik 21103 24 72 78.7 0.8 Dominated Austria 32544 21 72 81.3 0.4 Non-dominated Germany 33652 20 75 80.7 0.4 Non-dominated Poland 18906 23 65 76.7 0.8 Dominated Slovak Republic 20256 24 65 77.6 1.3 Dominated Weights 0.26659 0.17094 0.09712 0.41876 0.04660 ##### Sheet/List 8 ##### income (USD) housing expediture (%) employment rate (%) life expectancy homicide rate Czech Republik 21103 24 72 78.7 0.8 Austria 32544 21 72 81.3 0.4 Germany 33652 20 75 80.7 0.4 Poland 18906 23 65 76.7 0.8 Slovak Republic 20256 24 65 77.6 1.3