5. Simulate Rolling Dice and Count the Numbers Rolled
In the previous videos, you calculated the probability of each outcome when rolling two dice.
In this video, you will conduct an experiment that tests your probability calculations and simulate rolling the dice yourself.
To do this, you will use a function that returns a random number between 2 and 12, just like the dice when they are rolled.
Then, you will count the number of times you roll each outcome.
To start, write a function that simulates rolls of the orange die.
In the simulation column, type equals and search for random functions.
Use the Sheets Help menu to find the correct function and read its purpose.
The RANDBETWEEN function provides a random number between two values, including those values.
When rolling the orange die, you can roll any number between one and six.
Complete the function and press enter.
Your function randomly rolled the die!
Copy the function to the rest of the column.
Notice that the result in your first cell may have changed.
Any time the sheet reloads, the function returns a new number.
Repeat the process for the Purple Die simulation column.
This will show the random rolls for the second dice.
Next, stop the random values from resetting by fixing the results.
Copy all the values in the two dice simulation columns.
Pasting the values also pastes the formula, which won’t freeze the values.
Instead, paste the values only in the number rolled columns.
In this example, columns O and P.
Check to see if the function disappeared.
Now the values are fixed and you can use them for additional calculations.
Next, add the Orange and Purple Dice Numbers Rolled columns together in the Sum column to get the simulated outcome.
Use a SUM function to add the orange dice and the purple dice.
Then, copy the formula to the rest of the column.
Check your work.
In this case, a relative cell reference is required, so you don’t need to add the dollar signs you used earlier in the lesson.
Next, use a COUNTIF function to calculate the number of times each outcome is rolled in your simulation.
Use the list of results in the Sum column as the range...
And the first Possible Outcome as the criterion.
Make the cell references absolute...
Then copy the formula to the rest of the column.
Now you can see how many times each possible outcome was rolled in the simulation.
You might also use the RANDBETWEEN function to Assign an order for presenting a group project, Or choose a raffle winner for school spirit day.
Move on to the next video to calculate the actual percentages of your simulated rolls and compare them to the probability percentages you calculated.
Now, it’s your turn: Add the RANDBETWEEN function to two columns to simulate rolling the dice, And use the COUNTIF function to calculate how many times each number was rolled.
- Add the RANDBETWEEN function to two columns to simulate rolling the dice.
- Use the COUNTIF function to calculate how many times each number was rolled.
Shared work attachment
This project will be shared with your teachers
Students can submit their work on this page. View their submitted work on the student progress page of My Classes.