V EA Project.pdf S O Y Yandex x + v file:///C:/Users/asus/Desktop/zyein.Odosyalar%20snavar/e383/Midterm%20assignment/VBA%20Project.pdf Yandex.Bilet - + Sayfaya sigdir Sayla gornano A Sesi oku Not ekle A B Question4: (30 pts) There are 3 investment alternatives and 3 states of nature: The demand in the market can decrease, increase or stay unchanged. An example of the payoff matrix is as below. 45% 20% Decrease Increase 1 Probability 2 Demand 3 Alternative 1 4 Alternative 2 5 Alternative 3 35% Stay unchanged 120 140 50 310 -30 330 400 Write a VBA code which calculates the value of perfect information about the market (an information which tells you, how the demand will change (decrease, increase or stay unchanged) with 100% accuracy) for a given matrix including the probabilities and payoffs in the same format. I will fill the yellow boxes with different data sets and test your code. You can show your answer in Cell A7 Aramak iin buraya yazn A . TUR 15.2020 V EA Project.pdf S O Y Yandex x + v file:///C:/Users/asus/Desktop/zyein.Odosyalar%20snavar/e383/Midterm%20assignment/VBA%20Project.pdf Yandex.Bilet - + Sayfaya sigdir Sayla gornano A Sesi oku Not ekle A B Question4: (30 pts) There are 3 investment alternatives and 3 states of nature: The demand in the market can decrease, increase or stay unchanged. An example of the payoff matrix is as below. 45% 20% Decrease Increase 1 Probability 2 Demand 3 Alternative 1 4 Alternative 2 5 Alternative 3 35% Stay unchanged 120 140 50 310 -30 330 400 Write a VBA code which calculates the value of perfect information about the market (an information which tells you, how the demand will change (decrease, increase or stay unchanged) with 100% accuracy) for a given matrix including the probabilities and payoffs in the same format. I will fill the yellow boxes with different data sets and test your code. You can show your answer in Cell A7 Aramak iin buraya yazn A . TUR 15.2020