Appendix 21. AHP Using Microsoft Excel™
The analytic hierarchical process (AHP) is a powerful technique for decision making. It is also quite elaborate and if you wish to obtain exact results you will probably want to acquire specialized software, such as Expert Choice 2000 (www.expertchoice.com). However, if all you need is a good approximation, and if you are willing to forgo some of the bells and whistles, you can use a spreadsheet to perform the analysis. To demonstrate this, we will use Microsoft Excel to repeat the analysis we performed in Chapter 3.
Get The Six Sigma Handbook, Revised and Expanded, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
