
Explore how the analytical hierarchy process supports decision making by structuring criteria, comparing alternatives, and reaching consensus, with examples like buying a car and a hands-on Excel solution.
Apply the Analytical Hierarchy Process to combine qualitative and quantitative analysis in a hierarchical, matrix-based framework for complex decisions, including site selection and planning, with Excel implementations.
Dear Learners,
Now that we have learned the Theoretical concepts of AHP, we now move towards solving some real life Examples using MS Excel.
Before you proceed with the next lecture I would recommend you to download the AHP Resource file from the link given below and practice the concept as you learn along with me.
Lets now jump into problem solving.
Explore the steps involved in the analytic hierarchy process (ahp), defining the problem, building a hierarchy, gathering expert input, performing pairwise comparisons on a 1–9 scale, and evaluating alternatives.
Set up an Analytical Hierarchy Process (AHP) by defining the decision problem, building a graphical structure with goals, criteria, and alternatives, and applying judgments to weigh criterion importance.
Apply Analytical Hierarchy Process in Excel to solve a mobile phone selection with pairwise comparisons, normalization, and consistency checks, deriving priorities and best brand.
This lecture demonstrates an AHP workflow in Excel: normalize by sum, compute weights, and check consistency to pick the best brand based on camera quality and battery life.
Examine the benefits and limitations of the Analytical Hierarchy Process (AHP), a flexible decision model that blends qualitative insights with quantitative analysis, while warning against subjectivity and calculation errors.
Apply the analytical hierarchy process to enhance your decision making and engage you in a concise, results-driven exploration of choice optimization.
What is the role of AHP in Decision Making and Quality Management?
Analytic Hierarchy Process (AHP) is one of Multi Criteria decision making and Problem Solving method that was originally developed by Prof. Thomas L. Saaty. In short, it is a method to derive ratio scales from paired comparisons.
Taking up this course will enable you to
Build Ability to align decisions with Organizational Objectives.
Select one alternative from a given set of alternatives, usually where there are multiple decision criteria involved.
Build ability to implement a structured and repeatable decision making approach by utilizing organizational Expertise.
Checking the consistency of your judgements.
Apply AHP in building concensus, prioritizing customer needs and choosing the best alternatives.