Hello!

I am trying to graph my calculated payoff for each alternative over the entire range of the index of optimism for my homework and can't figure out how to graph it in Excel.

i. Calculate which alternative would be best using the Hurwicz rule, for an index of optimism of 0.75. Also, graph the calculated payoff for each alternative over the entire range of the index of optimism: A2 is the best alternative as it has the highest payoff. =a(maximum)+(1-a)(minimum) A1: (0.75)(3)+(0.25)-1)= 2 A2: (0.75)(6)+(0.25)-4)= 3.5 A3: (0.75)(5)+(0.25)(-2)=3.25 A4: (0.75)(2)+(0.25)-2)=1 A5: (0.75)(5)+(0.25)-4)= 2.75