Question
All information is marked in Bold. Which is used to answer the questions below. Please remember that the pictures are just examples that were provided
All information is marked in Bold. Which is used to answer the questions below.
Please remember that the pictures are just examples that were provided
(The 2nd image is just a zoomed in image of the small clipboard. Which was the image provided to me too)
you will build a coin toss simulator in Excel similar to the dice roll simulator. With this simulation, you will flip 4-fair coins 60 times (for a total of 240 flips). For each 4-coin simulation, you will count how many heads appeared. (The value for the number of heads will be between 0 and 4).
In this simulation, you will use the =RANDBETWEEN(0,1) function. This function will pick a random number between its lower limit and its upper limit. In this particular case, the function will randomly pick a 0 or a 1.
If the function gives us a 0, we will say that corresponds to Tail for that toss. If the function gives us a 1, we will say that corresponds to a Head for that toss.
Label the first row as indicated below, and number column A 1-60 to indicate which coin toss you're recording. Columns B, C, D, and E should be the face values of the coins after they land.(picture 1)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started