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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!