The question set 2 need help in it, and please use excel formulas and show the formas for understanding. if if its not in excel formulas unfortunatly i would have ti give negative rating.

Question Set 2. This question set uses the table of outcomes from Question Set 1 for Microsoff's strategies. Assume that the probabilities for scenarios are: - P( Scenario 1)=0.15 - P( Scenario 2)=0.25 - P( Scenario 3) =0.20 - P( Scenario 4)=0.40 1. What decision will maximize Google's expected monetary value? (9pts) 2. What is the expected value of perfect information? (6pts) The outcomes of the possible strategies (in millions of dollars) depend on how the competitors behave. Microsoft considers four different outcomes, which are not shared, but we will call them as scenarios 1, 2, 3 and 4. Negative values indicate loss for Microsoft and positive values indicates possible profits. For the following questions, you will use Excel to identify the best strategy according to various criteria. You only need to perform the necessary calculations to show which one is best. For example, the firs question is for maximax. You need to set up formulas to find the maximum payoff for each strategy and to then find the highest value among them. However, once you have calculated that highest value, you can just type in the corresponding strategy without any further Excel calculations. 1. What would be Microsoft's decision using the maximax criterion? (3pts) 2. What would be Microsoft's decision using the maximin criterion? (3pts) 3. What would be Microsoft's decision using the Laplace criterion? (3pts) 4. What would be Microsoft's decision using the minimgs regret criterion? It is most helpful to construct a regret table for this problem. (6pts) Question Set 2. This question set uses the table of outcomes from Question Set 1 for Microsoft's strategies. Assume that the probabilities for scenarios are: - P( Scenario 1)=0.15 - P( Scenario 2)=0.25 - P( Scenario 3)=0.20 - P( Scenario 4)=0.40