You are trying to determine which city to live in. New York and Chicago are under consideration. Four objectives will determine your decision: housing cost, cultural opportunities, quality of schools...

You are trying to determine which city to live in. New York and Chicago are under consideration. Four objectives will determine your decision: housing cost, cultural opportunities, quality of schools and universities, and crime level. The weight for each objective is in the file P09_39.xlsx. For each objective (except for quality of schools and universities), New York and Chicago scores are also given in this file.

Suppose that the score for each city on the quality of schools and universities depends on two things: a score on public school quality and a score on university quality. The pairwise comparison matrix for public school and university quality is also shown in this file. To see how each city scores on public school quality and university quality, use the pairwise comparison matrices also shown in this file. You should be able to derive a score for each city on the quality of schools and universities objective. Then use AHP to determine where you should live.