The results are given by a table on criteria, one or more tables on subcriteria and a table on the alternatives. Below are presented tables and graphs of the results obtained for each evaluator. The first results are tables and graphs presenting the mean values of the results obtained by the evaluator. Interpreting the results of an AHP analysis In the General tab, choose a worksheet that contains a DHP design generated by XLSTAT, here AHP design.Īfter clicking the OK button, the computations start and the results are displayed in a new sheet named AHP. Once all the tables are completed, click on the XLSTAT / Advanced features / Decision aid / AHP menu to open the AHP Method dialog box or click on Run the analysis button situated below the design table. According to the Saaty scale, this means that the cost is judged to be very important compared to the style criterion. Below is an example of filling in the criteria comparison table by the evaluator Owen.įor example, Owen has evaluated the cost versus the style at 7. The Saaty table provides the values to be used by the 3 evaluators in order to fill in the comparison tables. The data summary table, the Saaty table and the instructions for filling in the comparison tables of the design are displayed in the output sheet. Then select the column that contains the criteria in the field with the same name, the 4 subcriteria columns in the respective field and finally the column that contains in the field Evaluators labels.Īfter clicking the OK button, the design of the experiment is generated and displayed in a new sheet named AHP design. In the General tab, select the car list (Datasheet of the demo Excel file) in the Alternatives field. The dialog box Designs for AHP analysis appears. Launch XLSTAT and click on the menu XLSTAT / Advanced features / Decision aid / DHP: The first step is to generate a design of experiment with the DHP tool. Setting up an AHP analysis with XLSTAT Step 1: Generate the AHP design The goal of this tutorial is to find which car is the best choice according to the opinions of the three evaluators. The data is grouped in a table as follows: The solutions to the problem are called alternatives. Six car models are evaluated using all criteria and subcriteria. The criterion capacity includes 2 subcriteria which are the number of passengers and the capacity of cargo. The criterion cost is divided into subcriteria which are the purchase price, the fuel cost, the maintenance, and resale. The criteria are the cost, safety, capacity and style of the car. We have 3 evaluators named Steeve, Owen, and Jack who participate in the decision making. The data correspond to the parameters of a decision problem about the purchase of a new car. The AHP feature proposed in XLSTAT has the advantage of not having any limitations on the number of criteria, of subcriteria and of alternatives and allows the participation of a large number of evaluators. It is better adapted when the criteria number remains reasonable, and when the user is able to evaluate 2 by 2 the elements of his problem. What is Analytic Hierarchy Process (AHP)?ĪHP is a decision aid method based on a criteria hierarchization. This tutorial shows how to configure an Analytic Hierarchy Process (AHP) and how to interpret the results using XLSTAT in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |