please include the step by step solution on excel

ofer 2. A debate recently erupted about the optimal strategy for playing a game on the TV show called "Let's Make a Deal." In one of the games on this show, the contestant would be given the choice of prizes behind three closed doors. A valuable prize was behind one door and worthless prizes were behind the other two doors. After the contestant selected a door, the host would open one of the two remaining doors to reveal one of the worthless prizes. Then, before opening the selected door, the host would give the contestant the opportunity to switch his or her selection to the other door that had not been opened. The question is, should the contestant switch? [Hint: Use PSIMEANO function to find the average number of wins for each option] A. Suppose a contestant is allowed to play this game 400 times, always picks door number 1, and never switches when given the option. If the valuable prize is equally likely to be behind each door at the beginning of each play, how many times would the contestant win the valuable prize? Use simulation to answer this question. B. Now suppose the contestant is allowed to play this game another 400 times. This time the player always selects door number 1 initially and switches when given the option. Using simulation, how many times would the contestant win the valuable prize? C. If you were a contestant on this show, what would you do if given the option of switching doors? Hint: Probability of getting prize behind one of the doors is equally probable and integer. So, you use uniform probability distribution