Question: how to do ahp analysis in excel?
Answer: Calculate the weighted average rating for each decision alternative. Choose the one with the highest score. Decompose the decision-making problem into a hierarchy of criteria and alternatives. The first step in the AHP procedure is to make pair wise comparisons between each criterion.