Question: Instructions Model the following problems using MS Excel. Your spreadsheet should display the results for 5,000 simulation runs. Furthermore, a new set of 5,000 simulation

Instructions Model the following problems using MS Excel. Your spreadsheet should display the results for 5,000 simulation runs. Furthermore, a new set of 5,000 simulation runs should be generated when the F9 key is pressed. Upload the following two files to the submission folder on LumiNUS before 1 Mar 2021, 11:59pm: MS Excel file containing your simulation A word document clearly stating: The cell that displays the solution (i.e., probability, expected value, variance) o What each column in your MS Excel file describes' Questions 1. A deck of playing cards (52 cards in total) is divided into 4 equal decks. There are 4 aces (spades, hearts, diamonds, clubs) in total. Estimate the probability that each deck contains exactly one ace? 2. You have a biased coin that will be HEADS with probability 0.6 and TAILS with probability 0.4. The coin is tossed 10 times. Let # denote the number of heads and 7 denote the number of tails observed. Let X denote the absolute difference between the two i.e., X = [H - TI. Estimate: a. Expected value of X b. Variance of X Note: The ABS function can be used to find the absolute value of numbers in MS Excel. See here for details. "If multiple columns describe something similar, you can say "Columns A to Z represent.." instead of having of an individual description for each column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
