Difference between revisions of "JeromeQuah Ex2 AHP"

From Geospatial Analytics for Urban Planning
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;" | AHP-1(%)
+
| 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:

Order of Priority for Criteria
(1 - Most Important, 4 - Least Important)
Priority Number Factor Rationale
1 Health Risk When taking into account the purpose of the CDQC which would be to house those who are ill with contagious diseases, the well-being and health of the rest of the Gombak population is of the utmost importance.
2 Accessibility With the health of the unaffected Gombak population being the most important, the second would be the ease of transportation of materials during the construction phase of the CDQC and also the diseased post-construction. This is to ensure that the diseased are able to arrive at the CDQC as quick as possible, and to prevent the spread of the disease to others within the area after discovery of the disease.
3 Natural Conservation After health and accessibility comes the protection of the diseased in the CDQC from wildlife or fauna which could incur further illness and hygiene issues within both the internal and external parameters of the CDQC.
4 Economic Developmental costs are considered to be detrimental to the budget of the CDQC during its construction, but cost should not be a priority when it comes to building the facility that puts the health of its users first.


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:
  • 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%

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
  1. 2 Aug 2018, Saaty's Analytic Hierarchy Process by Manoj Matthew. Accessed 8th November 2019