1. Could you solve the following problem using excel. Besides the maximin, maximax, and EMV criteria, there are other possible criteria for making decisions. One possibility involves regret. The idea behind regret is that if you make any decision and then some outcome occurs, you look at that outcomes column in the payoff table to see how much more you could have made if you had chosen the best payoff in that column. For example, if the decision you make and the outcome you observe lead to a $50 payoff, and if the highest payoff in this outcomes column is $80, then your regret is $30. You regret looking back and seeing how much more you could have made, if only you had made a different decision. Therefore, you calculate the regret for each cell in the payoff table (as the maximum payoff in that column minus the payoff in that cell), calculate the maximum regret in each row, and choose the row with the smallest maximum regret. This is called the minimax regret criterion.

   Apply this criterion to the example in Simple Decision Problem.xlsx. Which decision do you choose?

A B C D E F H 1 Decision 1 2 Payoff/Cost Probability 3 $50,000 0.1 4 $10,000 0.2 5 $5,000 0.7 6 7 EMV $3,500 Decision 2 Payoff/Cost Probability $5,000 0.6 $1,000 0.4 Decision 3 Payoff/Cost Probability $3,000 1 EMV $2,600 EMV $3,000