Thanks to feedback from Mihail, here a few words about the numerical accuracy when using the AHP excel template.
AHP requires the calculation of the principal Eigenvalue, the weights are derived from the Eigenvector. In my calculations I use the power method. It is an iterative method, and only one of several techniques that can be used to approximate the eigenvalues of a matrix.
The whole calculation is shown in work sheet ’10×10′. I use 12 iterations; at the end of the sheet I do a check (the reverse calculation), using the Eigenvalue equation: (A–λ I) X = 0, with A the AHP matrix; λ the principal Eigenvalue, and X the estimated Eigenvector. The resulting check value in cell B33 shows the sum of all matrix element of the Eigenvalue equation using the iterated Eigenvector and Eigenvalue. Ideally it should be zero.
From version 2014-05-09 onward the template shows the convergence of the power method, when calculating the eigenvalue. In the summary sheet a threshold (squared Euclidean distance d2) can be set, to show how many iterations it takes, until the change of the approximated eigenvector is below the given threshold. By default the value is set to Thresh: 1E-07. As the number of iterations in the template is fixed to 12, care should be taken if the value reaches 12.
Here a practical example comparing the results from the power method, as now implemented in my template, with an example (7 criteria) given by Saaty in Int. J. Services Sciences, Vol. 1, No. 1, 2008 (p 86, table 2). The AHP matrix is:
The result according Saaty is
(0.177, 0.019, 0.042, 0.116, 0.190, 0.129, 0.327) with consistency ratio of 0,022
The result from my AHP Excel template is
(0.1775, 0.0191, 0.0418, 0.1164, 0.1896, 0.1288, 0.3268) with CR 0f 0.022
exactly the same. The check value in sheet ‘8×8 is 4E-12.
You can find more examples here.
Please download the latest version with the improved accuracy from here.
Incoming search terms:
- how to calculate Euclidean distance in ahp