Difference between revisions of "JeromeQuah Ex2 AHP"
Jump to navigation
Jump to search
Line 53: | Line 53: | ||
! style="text-align: center; width:20em; height: 1em; border:5px ridge Crimson; font-weight:bold; font-size:25px; font-family:Times New Roman !important;; background-color:Black; color: White;"| AHP FUNDAMENTAL SCALE | ! style="text-align: center; width:20em; height: 1em; border:5px ridge Crimson; font-weight:bold; font-size:25px; font-family:Times New Roman !important;; background-color:Black; color: White;"| AHP FUNDAMENTAL SCALE | ||
|} | |} | ||
+ | |||
+ | <!-- Fundamental Scale Text --> | ||
+ | {| align=center width = 100% | ||
+ | | style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family: Times New Roman !important; background-color:ghostwhite; color: black;" | The following fundamental scale is utilized for the pair-wise comparison matrix for each of the criteria involved. | ||
+ | |} | ||
+ | |||
{| align=center width = 30% border=1 | {| align=center width = 30% border=1 | ||
Line 114: | Line 120: | ||
! style="text-align: center; width:20em; height: 1em; border:5px ridge Crimson; font-weight:bold; font-size:25px; font-family:Times New Roman !important;; background-color:Black; color: White;"| MATRIX INPUT | ! style="text-align: center; width:20em; height: 1em; border:5px ridge Crimson; font-weight:bold; font-size:25px; font-family:Times New Roman !important;; background-color:Black; color: White;"| MATRIX INPUT | ||
|} | |} | ||
+ | |||
+ | <!-- Matrix Input Heading Text --> | ||
+ | {| align=center width = 100% | ||
+ | | style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family: Times New Roman !important; background-color:ghostwhite; color: black;" | Based on the factor priorities, the [https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=17&ved=2ahUKEwi198HV87_lAhXhjuYKHWn1AnEQFjAQegQICRAC&url=http%3A%2F%2Fwww.scbuk.com%2FAHP%2520Template%2520SCBUK.xls&usg=AOvVaw002J8QfYIxOE_I9PYqrH8_ AHP Template provided by SCB Associates] is utilized to perform the pair-wise comparison matrix. As shown below, it is based on the format of comparing the ''Row'' Factor with the ''Column'' Factor. | ||
+ | |} | ||
+ | |||
{| align=center width = 80% border=1 | {| align=center width = 80% border=1 | ||
Line 164: | Line 176: | ||
| style="text-align: center; font-style:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Self-Input into Matrix | | style="text-align: center; font-style:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Self-Input into Matrix | ||
| style="text-align: center; font-style:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e; color: Black"| Yellow | | style="text-align: center; font-style:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e; color: Black"| Yellow | ||
+ | |} | ||
+ | |||
+ | |||
+ | <!-- Matrix Input Heading Text 2--> | ||
+ | {| align=center width = 100% | ||
+ | | style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family: Times New Roman !important; background-color:ghostwhite; color: black;" | The value of each cell in the matrix is then '''normalized''' via '''dividing the cell's value by its ''Column Total'''''. From this, the normalized values for each of the factors is '''totaled by the row''' of the matrix, and then '''divided by 4''' to get the ''average of all the weights'' for that factor. This returns the AHP Value for the respective factor. These values represent the respective '''Criteria's Weights''' in the decision-making of selecting of the suitable site for the CDQC in Gombak. The values are shown in the Results Report below. | ||
|} | |} | ||
Line 173: | Line 191: | ||
{| align=center width = 90% border=1 | {| align=center width = 90% border=1 | ||
− | !colspan="6" style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#96fffb;" | Normalised Column Weights | + | !colspan="6" style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#96fffb;" | Normalised Column Weights (2 d.p.) |
|- | |- | ||
| style="text-align: center; font-style:italic; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Row vs. Column | | style="text-align: center; font-style:italic; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Row vs. Column | ||
Line 180: | Line 198: | ||
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Health Risk Factor | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Health Risk Factor | ||
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Natural Conservation Factor | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Natural Conservation Factor | ||
− | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: Beige;" | | + | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: Beige;" | Criteria Weights (%) |
|- | |- | ||
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Economic Factor | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Economic Factor | ||
Line 209: | Line 227: | ||
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.09 | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.09 | ||
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 10.9 | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 10.9 | ||
+ | |} | ||
+ | |||
+ | |||
+ | <!--Consistency Heading --> | ||
+ | {| align=center width = 100% | ||
+ | ! style="text-align: center; width:20em; height: 1em; border:5px ridge Crimson; font-weight:bold; font-size:25px; font-family:Times New Roman !important;; background-color:Black; color: White;"| CONSISTENCY CHECKING | ||
+ | |} | ||
+ | |||
+ | <!-- Consistency Text--> | ||
+ | {| align=center width = 100% | ||
+ | | style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family: Times New Roman !important; background-color:ghostwhite; color: black;" | Lastly, to ensure that the accuracy of the Criterion Weights of the factors, the '''Consistency''' of the values are calculated via multiplying the Criteria Weights to the non-normalised values of the columns pair-wise comparison matrix that tallies with their respective factors. For further clarity:<br> | ||
+ | |||
+ | * Column Cell Value for ''Economic'' Factor * '''4.7%''' | ||
+ | * Column Cell Value for ''Accessibility'' Factor * '''36.6%''' | ||
+ | * Column Cell Value for ''Health Risk Factor'' * '''47.9%''' | ||
+ | * Column Cell Value for ''Natural Conservation'' Factor * '''10.9%'''<br> | ||
+ | |||
+ | The results are then '''totaled by row''' to acquire the '''Weighted Sum Value''' for each of the Criteria. | ||
+ | Following that, each Weighted Sum Value is then '''divided by the respective Criteria Weight''' of the criteria, and then '''totaled by row''' to acquire the '''Lambda''' for each criteria. The following shows the pair-wise comparison matrix with the mentioned calculations for Consistency. | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| align=center width = 90% border=1 | ||
+ | !colspan="7" style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#96fffb;" | Pairwise Comparison Matrix - Consistency Checking Calculations (3 d.p.) | ||
+ | |- | ||
+ | | style="text-align: center; font-style:italic; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Row vs. Column | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Economic Factor | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Accessibility Factor | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Health Risk Factor | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Natural Conservation Factor | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: Beige;" | Weighted Sum Value | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: Beige;" | Lambda | ||
+ | |- | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Economic Factor | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.047 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.052 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.053 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.036 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 0.189 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 4.108 | ||
+ | |- | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Accessibility Factor | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.329 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.366 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.479 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.327 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 1.501 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 4.101 | ||
+ | |- | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Health Risk Factor | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.423 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.366 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.479 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.763 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 2.031 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 4.240 | ||
+ | |- | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Natural Conservation Factor | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.141 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.122 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.068 | ||
+ | | style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.109 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 0.440 | ||
+ | | style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 4.041 | ||
|} | |} | ||
Revision as of 19:54, 9 November 2019
OVERVIEW | PROXIMITY | CRITERION SCORES | AHP | SUITABILITY |
---|
The Analytical Hierarchical Process (AHP) is a multi-criteria decision-making method to derive the relative weight of a number of criteria affecting for a decision to be made via the pair-wise comparison matrix. In this case, we will be applying the AHP in our decision-making for the suitable site to build the CDQC in Gombak, with the criteria being the Health Risk Factor, Accessibility Factor, Natural Conservation Factor and Economic Factor. Before utilising the AHP, the priority for the mentioned factors for the suitability map with its rationale are as follows:
|
AHP FUNDAMENTAL SCALE |
---|
The following fundamental scale is utilized for the pair-wise comparison matrix for each of the criteria involved. |
AHP Fundamental Scale (Row vs Column) | ||||
---|---|---|---|---|
Extremely Less Important | 1/9 | |||
1/8 | ||||
Very Strongly Less Important | 1/7 | |||
1/6 | ||||
Strongly Less Important | 1/5 | |||
1/4 | ||||
Moderately Less Important | 1/3 | |||
1/2 | ||||
Equal Importance | 1 | |||
2 | ||||
Moderately More Important | 3 | |||
4 | ||||
Strongly More Important | 5 | |||
6 | ||||
Very Strongly More Important | 7 | |||
8 | ||||
Extremely More Important | 9 |
MATRIX INPUT |
---|
Based on the factor priorities, the AHP Template provided by SCB Associates is utilized to perform the pair-wise comparison matrix. As shown below, it is based on the format of comparing the Row Factor with the Column Factor. |
Factor Priorities for Communicable Disease Quarantine Centre in Gombak - Pairwise Comparison Matrix | ||||
---|---|---|---|---|
Row vs. Column | Economic Factor | Accessibility Factor | Health Risk Factor | Natural Conservation Factor |
Economic Factor | 1 | 1/7 | 1/9 | 1/3 |
Accessibility Factor | 7 | 1 | 1 | 3 |
Health Risk Factor | 9 | 1 | 1 | 7 |
Natural Conservation Factor | 3 | 1/3 | 1/7 | 1 |
Column Totals | 20.00 | 2.48 | 2.25 | 11.33 |
Legend | ||||
---|---|---|---|---|
Automatic Calculation by Matrix | Red | |||
Self-Input into Matrix | Yellow |
The value of each cell in the matrix is then normalized via dividing the cell's value by its Column Total. From this, the normalized values for each of the factors is totaled by the row of the matrix, and then divided by 4 to get the average of all the weights for that factor. This returns the AHP Value for the respective factor. These values represent the respective Criteria's Weights in the decision-making of selecting of the suitable site for the CDQC in Gombak. The values are shown in the Results Report below. |
RESULTS REPORT |
---|
Normalised Column Weights (2 d.p.) | |||||
---|---|---|---|---|---|
Row vs. Column | Economic Factor | Accessibility Factor | Health Risk Factor | Natural Conservation Factor | Criteria Weights (%) |
Economic Factor | 0.05 | 0.06 | 0.05 | 0.03 | 4.7 |
Accessibility Factor | 0.35 | 0.40 | 0.44 | 0.26 | 36.6 |
Health Risk Factor | 0.45 | 0.40 | 0.44 | 0.62 | 47.9 |
Natural Conservation Factor | 0.15 | 0.13 | 0.06 | 0.09 | 10.9 |
CONSISTENCY CHECKING |
---|
Lastly, to ensure that the accuracy of the Criterion Weights of the factors, the Consistency of the values are calculated via multiplying the Criteria Weights to the non-normalised values of the columns pair-wise comparison matrix that tallies with their respective factors. For further clarity:
The results are then totaled by row to acquire the Weighted Sum Value for each of the Criteria. Following that, each Weighted Sum Value is then divided by the respective Criteria Weight of the criteria, and then totaled by row to acquire the Lambda for each criteria. The following shows the pair-wise comparison matrix with the mentioned calculations for Consistency. |
Pairwise Comparison Matrix - Consistency Checking Calculations (3 d.p.) | ||||||
---|---|---|---|---|---|---|
Row vs. Column | Economic Factor | Accessibility Factor | Health Risk Factor | Natural Conservation Factor | Weighted Sum Value | Lambda |
Economic Factor | 0.047 | 0.052 | 0.053 | 0.036 | 0.189 | 4.108 |
Accessibility Factor | 0.329 | 0.366 | 0.479 | 0.327 | 1.501 | 4.101 |
Health Risk Factor | 0.423 | 0.366 | 0.479 | 0.763 | 2.031 | 4.240 |
Natural Conservation Factor | 0.141 | 0.122 | 0.068 | 0.109 | 0.440 | 4.041 |
Consistency Check | 6% |
REFERENCES |
---|