Mathematics Homework Help

DATA 353 UMW Decision by Optimistic Decision Maker Using Optimization Models Excel

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Order Now

SHOW STEPS IN EXCEL FILE FOR ALL WORK

A payoff (profit) table is given as

State of Nature

Decision s1 s2 s3

d1 10 8 6

d2 14 15 2

d3 7 8 9

a. What decision should be made by the optimistic decision maker?

b. What decision should be made by the conservative decision maker?

c. What decision should be made under minimax regret? Show the regret table.

d. If the probabilities of s1, s2, and s3 are .2, .3, and .5, respectively, then what decision should be made under expected value. SHOW STEPS IN EXCEL FILE FOR ALL WORK