the question is too big to fit in one picture so i put two. please show excel formulas

Question 3 An inventor is considering four different opportunities: A, B, C, or D. The payoff for each opportunity will depend on the economic conditions, represented in the payoff table below. Part a) Fill in the regret table (use equations in all cells). Part b) Give the maximax, maximin, and equal likelikood value. What investanent would be made uing these critarion? Note: Excel formulas not required. The maximas, valie The masimin valut This teads to a decivion of This leadi to 2 decision of The mintmax regret deciuion is (A, B, C, or D) (A, B, C or D) (A,B,C, or D) This leads to a decision of (A,B,C, or D) Part c) Given the probabilities in the last row of the payoff table above, compute the expected value for each investment. What investment would be made using the expected value criserion? Note: Excel formula not required for Cell H37. EV(A)=EV(B)=EV(C)=EV(D)= What investment would be made? (A, B, C, or D) Part d) Given the probabilities in the lant row of the payoff table above, compute the expected value uning perfect information, then the expected value of perfect information