Question: please answer correctly on excel and show excel calculation Q4. (10 points) Consider the following payoff table in which D1 through D4 represent decisions, S1

please answer correctly on excel and show excel calculation
please answer correctly on excel and show excel calculation Q4. (10 points)

Q4. (10 points) Consider the following payoff table in which D1 through D4 represent decisions, S1 through S4 represent states of nature, and the values in the cells represent profits. S1 S2 S3 S4 D1 -20 40 60 100 D2 30 120 60 -50 D3 30 30 40 40 D4 10 -60 80 70 Required a) The optimal decision under the maximax criterion is: b) The optimal decision under the minimax regret criterion is: c) The optimal decision under the maximin criterion is: d) Suppose that the probabilities of states of nature 52 and 53 occurring are equal and that the probability of state of nature S4 occurring is .50. If the probability of state of nature S1 occurring is three times the probability of state of nature S2 occurring, the optimal decision under the expected value criterion is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!