answersLogoWhite

0

If you just want to roll a die and not learn how to do it, you can type "roll a die" into Google, and it will have a six-sided die for you to roll right on that page. Other sizes of dice rollers will be available in the search results as well. If you want to learn how to do it in Excel though, that is below:

If you want to simulate the outcome of throwing a pair of dice (two die), it is easy and I will explain how to do this with Excel.

A single die has a discrete uniform distribution, with values from 1 to 6. Some programs have a built in function for computing random values. Excel does not, but it does have a built in continuous random number generator rand() from 0 to 1. Rand() will generate numbers above 0 and below 1, so if I multiply the numbers by 6, I will have numbers above 0 and below 6. I will take this number and use the int function to round down the number to the next lowest whole number, so now I have discrete numbers from 0 to 5. I can add one to these numbers and now I have random numbers 1 to 6.

So, in Excel you can use int(rand()*6)+1 to obtain the random numbers. I can put this equation in a second cell, and add them together. You can copy this equation many times and obtain many simulated throws of dice. In Excel, you can hit the F9 key and execute this program, obtaining different random numbers.

User Avatar

Wiki User

10y ago

Still curious? Ask our experts.

Chat with our AI personalities

RafaRafa
There's no fun in playing it safe. Why not try something a little unhinged?
Chat with Rafa
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin

Add your answer:

Earn +20 pts
Q: What's one of the random number generators of a pair of dice?
Write your answer...
Submit
Still have questions?
magnify glass
imp