Difference between revisions of "JeromeQuah Ex2 AHP"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(19 intermediate revisions by the same user not shown)
Line 12: Line 12:
 
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge crimson; border-bottom: 5px ridge crimson; font-weight:bold; font-size:15px; font-family:Times New Roman !important;; background-color: ghostwhite; color: gold;" | [[JeromeQuah_Ex2_Suitability|<span style="color:black;">SUITABILITY]]
 
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge crimson; border-bottom: 5px ridge crimson; font-weight:bold; font-size:15px; font-family:Times New Roman !important;; background-color: ghostwhite; color: gold;" | [[JeromeQuah_Ex2_Suitability|<span style="color:black;">SUITABILITY]]
 
|}
 
|}
 +
 +
 +
<!-- Preface 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 ''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. <br>
 +
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:
 +
 +
{| align=center width = 90% border=1
 +
!colspan = "3" style="text-align: center; font-weight:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#96fffb;" |'''Order of Priority for Criteria'''<br>''(1 - Most Important, 4 - Least Important)''
 +
|-
 +
| style="text-align: center; font-size:20px; font-weight:Bold; font-family:'Times New Roman', Times, serif !important;;" | Priority Number
 +
| style="text-align: center; font-size:20px; font-weight:Bold; font-family:'Times New Roman', Times, serif !important;;" | Factor
 +
| style="text-align: center; font-size:20px; font-weight:Bold; font-family:'Times New Roman', Times, serif !important;;" | Rationale
 +
|-
 +
| style="text-align: center; font-size:15x; font-family:'Times New Roman', Times, serif !important;;" | 1
 +
| style="text-align: center; font-size:15x; font-family:'Times New Roman', Times, serif !important;;" | ''Health Risk''
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;; "| 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.
 +
|-
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;;" | 2
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;;" | ''Accessibility''
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;; "| 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.
 +
|-
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;;" | 3
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;;" | ''Natural Conservation''
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;; "| 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.
 +
|-
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;;" | 4
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;;" | ''Economic''
 +
| style="text-align: center; font-size:15px; font-family:'Times New Roman', Times, serif !important;; "| 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.
 +
|}
 +
|}
 +
  
 
<!--Fundamental Scale Heading -->
 
<!--Fundamental Scale Heading -->
{| align=center
+
{| 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;"| 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
 
|}
 
|}
  
{| align=center width = 80% border=1  
+
<!-- Fundamental Scale Text -->
! colspan="3" style="font-weight:bold; background-color:#96fffb;" | AHP Fundamental Scale (Row vs Column)
+
{| 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  
 +
!colspan="5" style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#96fffb;" | AHP Fundamental Scale (Row vs Column)
 
|-
 
|-
| colspan="2" | Extremely Less Important
+
| colspan="2" style="text-align: center;"| Extremely Less Important
 
| style="text-align: center;" | 1/9
 
| style="text-align: center;" | 1/9
 
|-
 
|-
Line 28: Line 69:
 
| style="text-align: center;" | 1/8
 
| style="text-align: center;" | 1/8
 
|-
 
|-
| colspan="2" | Very Strongly Less Important
+
| colspan="2" style="text-align: center;" | Very Strongly Less Important
 
| style="text-align: center;" | 1/7
 
| style="text-align: center;" | 1/7
 
|-
 
|-
Line 34: Line 75:
 
| style="text-align: center;" | 1/6
 
| style="text-align: center;" | 1/6
 
|-
 
|-
| colspan="2" | Strongly Less Important
+
| colspan="2" style="text-align: center;" | Strongly Less Important
 
| style="text-align: center;" | 1/5
 
| style="text-align: center;" | 1/5
 
|-
 
|-
Line 40: Line 81:
 
| style="text-align: center;" | 1/4
 
| style="text-align: center;" | 1/4
 
|-
 
|-
| colspan="2" | Moderately Less Important
+
| colspan="2" style="text-align: center;"| Moderately Less Important
 
| style="text-align: center;" | 1/3
 
| style="text-align: center;" | 1/3
 
|-
 
|-
Line 46: Line 87:
 
| style="text-align: center;" | 1/2
 
| style="text-align: center;" | 1/2
 
|-
 
|-
| colspan="2" style="font-weight:bold;" | Equal Importance
+
| colspan="2" style="font-weight:bold; text-align: center;" | Equal Importance
 
| style="text-align: center;" | 1
 
| style="text-align: center;" | 1
 
|-
 
|-
Line 52: Line 93:
 
| style="text-align: center;" | 2
 
| style="text-align: center;" | 2
 
|-
 
|-
| colspan="2" | Moderately More Important
+
| colspan="2" style="text-align: center;"| Moderately More Important
 
| style="text-align: center;" | 3
 
| style="text-align: center;" | 3
 
|-
 
|-
Line 58: Line 99:
 
| style="text-align: center;" | 4
 
| style="text-align: center;" | 4
 
|-
 
|-
| colspan="2" | Strongly More Important
+
| colspan="2" style="text-align: center;" | Strongly More Important
 
| style="text-align: center;" | 5
 
| style="text-align: center;" | 5
 
|-
 
|-
Line 64: Line 105:
 
| style="text-align: center;" | 6
 
| style="text-align: center;" | 6
 
|-
 
|-
| colspan="2" | Very Strongly More Important
+
| colspan="2" style="text-align: center;"| Very Strongly More Important
 
| style="text-align: center;" | 7
 
| style="text-align: center;" | 7
 
|-
 
|-
Line 70: Line 111:
 
| style="text-align: center;" | 8
 
| style="text-align: center;" | 8
 
|-
 
|-
| colspan="2" | Extremely More Important
+
| colspan="2" style="text-align: center;"| Extremely More Important
 
| style="text-align: center;" | 9
 
| style="text-align: center;" | 9
 
|}
 
|}
 +
  
 
<!--Matrix Input Heading -->
 
<!--Matrix Input Heading -->
 
{| align=center width = 100%
 
{| 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;"| 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 112: Line 159:
 
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 1/7
 
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 1/7
 
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 1
 
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 1
 +
|-
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: Beige;" | Column Totals
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 20.00
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 2.48
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 2.25
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 11.33
 +
|}
 +
 +
 +
{| align=center width = 40% border=1
 +
!colspan="5" style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:Black; color: ghostwhite" | Legend
 +
|-
 +
| style="text-align: center; font-style:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;;" | Automatic Calculation by Matrix
 +
| style="text-align: center; font-style:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color: White"| Red
 +
|-
 +
| 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
 +
|}
 +
 +
 +
<!-- 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.
 +
|}
 +
 +
 +
<!--Results Report 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;"| RESULTS REPORT
 +
|}
 +
 +
{| 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 (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-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;" | 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-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.05
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.06
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.05
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.03
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 4.7
 +
|-
 +
| 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.35
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.40
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.44
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.26
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 36.6
 +
|-
 +
| 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.45
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.40
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.44
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fffc9e;" | 0.62
 +
| style="text-align: center; font-weight:bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: LightCyan; color:black;" | 47.9
 +
|-
 +
| 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.15
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.13
 +
| style="text-align: center; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:#fd6864; color:#ffffff;" | 0.06
 +
| 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
 +
|}
 +
 +
 +
<!--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 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
 +
|}
 +
 +
 +
<!-- 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;" | '''Lambda Maximum''' or '''&Lambda;<sub>Max</sub>''' is then calculated via the '''averaging''' of all the Lambda Column Values for each of the criteria. This value will be then be used to calculate the '''Consistency Index (CI)''' <br>
 +
 +
'''&Lambda;<sub>Max</sub>''' = (4.108 + 4.101 + 4.240 = 4.041) &divide; 4 = '''4.100 (3.d.p.)'''
 +
 +
'''CI''' = ('''&Lambda;<sub>Max</sub>''' &minus; ''n'') &divide; (''n'' &minus; 1)<br>= (4.100 &minus; 3) &divide; (4 &minus; 1)<br> = '''0.033 (3.d.p.)'''<br>
 +
 +
Lastly, the '''Consistency Ratio (CR)''' is calculated with '''CI''' &divide; '''Random Index (RI) when ''n'' = 4'''.<br>The RI is the CI of '''randomly generated pairwise matrices'''.
 +
 +
With the following values I have obtained when utilizing the SCB Template, I have arrived with the '''CR of 0.06 (3.d.p.)'''
 +
* '''&Lambda;<sub>Max</sub>''' = '''4.152'''
 +
* '''CI''' = '''0.05'''
 +
* '''RI''' when ''n'' = 4: '''0.9'''
 +
* '''CR''' = '''0.06''' or '''6%'''
 +
 +
My Input Values of the SCB Template can be downloaded [https://wiki.smu.edu.sg/1920t1smt201/img_auth.php/f/f0/Jerome_AHP.xls here]
 +
|}
 +
 +
 +
{| align=center width = 40% border=1
 +
| style="text-align: center; font-weight:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color: SpringGreen;" | Consistency Check '''(CR)'''
 +
| style="text-align: center; font-weight:Bold; font-size:20px; font-family:'Times New Roman', Times, serif !important;; background-color:MediumSpringGreen; color: Black"| 6%
 +
|}
 +
 +
 +
<!-- Consistency 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;" | This means that the '''CR = 6%''' for the '''proportion of inconsistent CRs''' is less than the standard value of '''10%'''. From this, we can assume that our pairwise matrix used is '''reasonably consistent''', in which we can continue with the decision-making process for the CDQC in Gombak with the following criteria weights for the involved factors.<br>
 +
 +
# Health Risk Factor: '''47.9%'''
 +
# Accessibility Factor: '''36.6%'''
 +
# Natural Conservation: '''10.9%'''
 +
# Economic Factor: '''4.7%'''<br>
 +
 +
These values will be utilized when deriving our Suitability Map in the next section for the CDQC area in Gombak.
 +
|}
 +
 +
 +
<!--References 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;"| REFERENCES
 +
|}
 +
 +
<!-- References Text -->
 +
{| align=center width = 100%
 +
 +
| style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family: Times New Roman !important; background-color:Azure; color: black;"|
 +
# [http://web.cjcu.edu.tw/~lcc/Courses/TUTORIAL/AHP%20Tutorial.doc 2 Aug 2018, Saaty's Analytic Hierarchy Process by Manoj Matthew. Accessed 8th November 2019]
 
|}
 
|}

Latest revision as of 22:23, 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 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


Lambda Maximum or ΛMax is then calculated via the averaging of all the Lambda Column Values for each of the criteria. This value will be then be used to calculate the Consistency Index (CI)

ΛMax = (4.108 + 4.101 + 4.240 = 4.041) ÷ 4 = 4.100 (3.d.p.)

CI = (ΛMaxn) ÷ (n − 1)
= (4.100 − 3) ÷ (4 − 1)
= 0.033 (3.d.p.)

Lastly, the Consistency Ratio (CR) is calculated with CI ÷ Random Index (RI) when n = 4.
The RI is the CI of randomly generated pairwise matrices.

With the following values I have obtained when utilizing the SCB Template, I have arrived with the CR of 0.06 (3.d.p.)

  • ΛMax = 4.152
  • CI = 0.05
  • RI when n = 4: 0.9
  • CR = 0.06 or 6%

My Input Values of the SCB Template can be downloaded here


Consistency Check (CR) 6%


This means that the CR = 6% for the proportion of inconsistent CRs is less than the standard value of 10%. From this, we can assume that our pairwise matrix used is reasonably consistent, in which we can continue with the decision-making process for the CDQC in Gombak with the following criteria weights for the involved factors.
  1. Health Risk Factor: 47.9%
  2. Accessibility Factor: 36.6%
  3. Natural Conservation: 10.9%
  4. Economic Factor: 4.7%

These values will be utilized when deriving our Suitability Map in the next section for the CDQC area in Gombak.


REFERENCES
  1. 2 Aug 2018, Saaty's Analytic Hierarchy Process by Manoj Matthew. Accessed 8th November 2019