Among them, when the comparisons between alternatives for which the attributes are simple and the number of comparisons is small, priorities can be easily assigned, clear reasoning for the decision may be provided, and logical fallacies are also relatively very little. Just like the quote, “life is full of choices,” we make numerous choices every moment in the real world. This method has advantages that the number of comparisons can be reduced and also consistency is automatically maintained via determination of priorities first on multiple entities and subsequent comparisons between entities with adjoined priorities.

Thus, in this study, we propose a method of assigning weights, which applies hierarchy structure of AHP and pairwise comparison but complements the disadvantages of AHP. If the number of comparisons can be reduced, a comparison within a single level is optimal, and if comparison can be made while the priority among entities is maintained, consistency may be automatically maintained.

However, at the same time, the AHP has disadvantages that values vary according to the form of hierarchy structure and it is difficult to maintain consistency itself among responses. The analytic hierarchy process (AHP) has advantages that the whole number of comparisons can be reduced via a hierarchy structure and the consistency of responses verified via a consistency ratio.

Assigning weights to variables in excel