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.

Fuzzy topsis excel template