Create a simulation layout for rolling 3 dice 627 times. Calculate the probability of the 3...

Free

50.1K

Verified Solution

Question

Basic Math

Create a simulation layout for rolling 3 dice 627 times.Calculate the probability of the 3 adding to 11.
Use Excel and show formulas used

Answer & Explanation Solved by verified expert

3.6 Ratings (344 Votes)

Here we need use excel function \"=RANDBETWEEN(1,6)\" for outcome of dice1, dice2 and dice3. The sum column shows the sum of outcome of dice1, dice2 and dice3. Following table shows the screen shot:

dice 1	dice 2	dice 3	Sum
1	4	1	6
5	4	3	12
2	5	5	12
3	5	3	11
2	1	2	5
5	6	2	13
2	3	2	7
4	2	5	11
5	3	4	12
4	2	2	8
2	3	6	11
1	5	1	7
5	3	2	10
5	1	5	11
1	1	4	6
5	3	3	11
3	2	4	9
1	3	2	6
4	4	3	11
4	2	3	9
1	6	5	12
5	6	5	16
2	5	3	10
2	1	1	4
1	4	4	9
5	6	2	13
6	5	2	13
6	6	6	18
1	6	4	11
3	3	4	10
3	6	2	11
4	1	6	11
1	4	1	6
1	1	3	5
2	3	1	6
2	2	6	10
4	1	2	7
2	3	6	11
3	5	4	12
2	1	5	8
3	5	1	9
3	1	6	10
4	1	4	9
4	2	5	11
6	2	5	13
1	2	3	6
3	2	6	11
4	5	2	11
1	2	6	9
4	1	4	9
4	1	1	6
6	6	4	16
6	2	2	10
2	4	5	11
6	3	5	14
5	3	2	10
1	1	6	8
2	4	6	12
6	3	1	10
3	3	6	12
2	2	5	9
1	1	1	3
2	5	2	9
4	4	3	11
3	5	3	11
4	6	1	11
1	6	1	8
4	4	1	9
5	4	4	13
6	2	6	14
4	4	2	10
3	5	4	12
2	1	6	9
2	5	6	13
3	3	6	12
3	6	3	12
1	5	3	9
6	2	5	13
3	2	1	6
5	1	1	7
1	1	3	5
4	3	3	10
1	6	6	13
2	1	1	4
6	1	4	11
3	3	5	11
1	4	2	7
2	5	1	8
4	3	5	12
1	1	6	8
5	5	5	15
1	4	4	9
1	1	6	8
5	5	1	11
4	2	3	9
5	4	4	13
2	6	6	14
1	4	6	11
6	4	3	13
4	4	5	13
3	4	4	11
3	4	6	13
4	1	3	8
3	6	3	12
5	3	5	13
6	4	2	12
1	2	5	8
1	5	4	10
4	4	6	14
3	3	6	12
3	2	4	9
6	6	1	13
3	3	5	11
1	6	5	12
5	6	1	12
1	1	1	3
4	6	4	14
5	2	2	9
3	1	1	5
1	1	1	3
3	2	2	7
5	6	4	15
6	4	4	14
1	2	3	6
2	5	3	10
1	5	4	10
4	2	2	8
1	6	2	9
3	5	2	10
5	4	4	13
4	3	5	12
3	5	4	12
4	1	2	7
3	1	5	9
6	3	5	14
6	4	2	12
2	3	4	9
4	4	5	13
4	3	6	13
5	1	4	10
5	5	1	11
3	6	5	14
4	4	3	11
4	6	1	11
5	2	2	9
5	5	5	15
1	6	4	11
2	4	6	12
5	1	4	10
4	5	5	14
4	5	4	13
1	6	3	10
3	6	1	10
3	1	2	6
1	5	5	11
3	1	1	5
2	3	6	11
4	1	5	10
5	5	5	15
1	5	6	12
3	1	4	8
1	3	2	6
1	5	1	7
2	4	2	8
6	6	4	16
4	4	5	13
3	6	3	12
3	4	1	8
2	4	3	9
4	4	3	11
6	2	2	10
6	6	5	17
5	6	3	14
5	4	1	10
5	1	2	8
4	2	1	7
6	1	3	10
4	3	5	12
6	3	6	15
6	4	1	11
6	5	5	16
5	2	4	11
1	5	2	8
2	4	5	11
3	2	5	10
6	4	3	13
4	5	5	14
3	2	4	9
1	1	3	5
2	4	1	7
2	5	2	9
1	3	4	8
3	6	6	15
5	1	5	11
3	4	5	12
5	4	6	15
1	2	6	9
1	3	3	7
4	1	1	6
4	4	5	13
2	2	1	5
4	4	5	13
1	5	4	10
5	6	1	12
3	6	5	14
5	3	5	13
5	6	3	14
4	1	3	8
2	2	1	5
1	5	4	10
3	1	1	5
6	5	4	15
4	2	6	12
4	3	4	11
4	2	1	7
3	6	6	15
6	2	5	13
3	4	3	10
4	3	2	9
6	5	2	13
2	6	4	12
2	5	1	8
6	4	1	11
2	2	5	9
2	5	2	9
2	4	3	9
4	6	4	14
5	6	4	15
4	5	6	15
6	6	5	17
2	5	1	8
1	3	6	10
6	4	3	13
6	6	2	14
5	3	4	12
4	3	6	13
6	3	3	12
2	1	6	9
6	3	1	10
6	4	1	11
6	6	4	16
3	4	5	12
1	4	5	10
2	2	6	10
4	3	5	12
2	3	4	9
1	2	2	5
4	6	5	15
4	6	4	14
2	5	5	12
6	1	5	12
6	4	1	11
4	6	5	15
5	6	4	15
4	1	2	7
2	1	3	6
5	5	2	12
1	3	1	5
4	3	3	10
1	6	4	11
1	2	4	7
6	4	6	16
3	2	1	6
4	1	4	9
2	4	1	7
3	2	1	6
5	1	6	12
2	3	6	11
2	1	4	7
6	1	6	13
2	1	1	4
2	5	2	9
2	2	3	7
3	1	2	6
4	4	3	11
5	6	2	13
2	2	1	5
3	6	6	15
6	5	4	15
6	3	1	10
4	4	2	10
2	4	4	10
1	5	4	10
1	2	4	7
2	2	4	8
3	1	6	10
1	6	6	13
4	4	6	14
4	2	6	12
2	2	2	6
5	1	4	10
3	1	1	5
6	2	2	10
2	3	2	7
3	2	4	9
3	4	6	13
2	3	3	8
1	4	6	11
2	4	2	8
5	5	3	13
2	4	2	8
2	5	5	12
5	3	1	9
6	1	1	8
2	4	2	8
3	4	5	12
3	3	1	7
2	5	3	10
2	3	6	11
3	2	3	8
6	3	3	12
4	1	1	6
1	1	1	3
1	6	6	13
6	5	3	14
5	6	1	12
5	5	3	13
3	6	6	15
2	6	3	11
3	2	6	11
5	4	3	12
2	1	3	6
6	5	3	14
1	5	4	10
3	5	4	12
5	5	1	11
6	1	6	13
4	5	6	15
3	1	4	8
2	5	2	9
5	4	3	12
1	6	2	9
4	1	3	8
6	1	3	10
5	4	2	11
3	6	4	13
5	5	6	16
2	2	4	8
5	2	2	9
4	6	1	11
2	1	2	5
2	2	1	5
3	3	6	12
4	5	3	12
4	4	3	11
3	4	4	11
5	5	5	15
1	4	5	10
3	5	4	12
1	6	2	9
6	5	5	16
2	2	6	10
5	5	1	11
3	4	5	12
5	2	6	13
4	5	6	15
2	1	1	4
6	4	6	16
5	1	1	7
4	3	5	12
5	3	3	11
2	6	6	14
2	5	3	10
2	2	5	9
4	2	6	12
1	2	2	5
6	2	3	11
2	2	4	8
1	5	6	12
6	1	2	9
5	5	3	13
2	2	6	10
4	4	4	12
6	4	3	13
1	6	2	9
6	1	3	10
2	3	4	9
5	4	2	11
5	2	5	12
2	5	6	13
6	2	6	14
1	6	5	12
1	5	4	10
6	6	4	16
1	5	3	9
6	5	6	17
5	2	2	9
6	2	3	11
4	5	3	12
2	6	4	12
4	5	6	15
5	6	4	15
3	2	6	11
1	4	5	10
3	5	3	11
3	5	2	10
5	4	1	10
1	3	3	7
4	5	3	12
2	4	2	8
3	6	4	13
1	2	1	4
2	4	6	12
5	3	3	11
1	6	6	13
3	6	1	10
4	4	3	11
6	5	2	13
1	6	2	9
3	2	6	11
2	2	5	9
1	3	5	9
4	2	3	9
4	4	2	10
1	3	6	10
2	6	4	12
4	5	3	12
1	5	1	7
6	5	3	14
6	6	4	16
1	6	5	12
2	6	1	9
4	4	5	13
4	1	3	8
3	5	4	12
3	4	4	11
1	5	3	9
1	4	5	10
1	3	1	5
3	6	4	13
3	5	6	14
4	2	4	10
1	4	2	7
3	3	6	12
6	2	2	10
4	3	2	9
3	3	1	7
3	1	6	10
6	4	4	14
2	6	1	9
3	5	6	14
1	3	2	6
4	4	3	11
4	4	1	9
4	2	4	10
5	1	2	8
5	6	5	16
3	5	6	14
6	4	1	11
1	4	1	6
6	4	4	14
3	5	1	9
5	6	4	15
3	3	4	10
5	3	6	14
1	4	3	8
4	2	3	9
3	2	6	11
3	4	2	9
1	4	6	11
4	6	4	14
6	1	5	12
2	5	4	11
2	5	6	13
1	3	6	10
3	4	5	12
2	6	1	9
4	6	6	16
6	4	3	13
6	2	3	11
1	5	4	10
2	6	3	11
1	1	5	7
1	2	4	7
1	3	2	6
3	6	5	14
3	5	3	11
2	3	2	7
5	2	1	8
2	2	1	5
6	1	2	9
5	4	3	12
5	3	1	9
5	4	4	13
1	3	6	10
3	2	4	9
6	5	2	13
6	3	6	15
6	6	4	16
4	1	5	10
3	5	6	14
3	3	3	9
1	3	1	5
4	6	6	16
1	3	4	8
6	2	5	13
3	3	4	10
1	1	3	5
5	2	2	9
2	5	4	11
4	5	1	10
3	1	5	9
2	4	1	7
2	5	1	8
4	1	2	7
2	1	5	8
5	2	3	10
2	2	3	7
6	3	4	13
2	5	2	9
4	6	2	12
5	2	5	12
2	2	5	9
4	6	4	14
6	4	3	13
6	1	1	8
1	1	6	8
4	3	5	12
6	5	6	17
6	2	2	10
4	2	1	7
2	4	3	9
2	3	2	7
1	1	5	7
3	2	2	7
6	2	4	12
3	2	2	7
3	4	5	12
3	4	4	11
3	3	5	11
6	1	4	11
6	1	6	13
3	5	4	12
1	2	1	4
1	6	6	13
3	6	6	15
4	6	3	13
4	6	6	16
5	4	4	13
5	3	2	10
1	5	4	10
4	6	1	11
3	1	4	8
2	3	6	11
1	1	2	4
1	3	2	6
3	2	6	11
1	6	6	13
6	3	6	15
6	6	2	14
4	2	1	7
5	6	5	16
5	1	2	8
6	5	4	15
2	4	3	9
3	4	3	10
4	4	1	9
1	5	1	7
6	6	6	18
5	6	1	12
4	5	6	15
4	4	3	11
2	4	5	11
3	6	3	12
1	4	5	10
2	6	1	9
6	2	1	9
1	1	4	6
3	6	4	13
6	2	2	10
4	3	5	12
1	6	4	11
5	2	5	12
3	4	5	12
1	1	5	7
3	1	4	8
3	6	6	15
1	4	1	6
6	6	3	15
5	6	2	13
4	6	5	15
2	6	5	13
4	3	1	8
3	5	5	13
5	5	3	13
3	6	5	14
1	1	5	7
1	6	1	8
1	4	5	10
5	2	6	13
3	3	5	11
5	1	6	12
6	5	6	17
4	1	4	9
6	4	4	14
1	6	1	8
2	4	6	12
1	6	5	12
1	2	6	9
2	1	2	5
4	3	2	9
4	6	2	12
2	4	1	7
3	6	3	12
6	2	6	14
4	4	2	10
2	4	4	10
2	2	5	9
1	5	5	11
4	5	6	15
4	6	2	12
4	2	1	7
1	1	6	8
5	4	6	15
4	5	5	14
1	3	4	8
5	3	6	14
6	1	5	12
5	5	1	11
6	4	3	13
6	2	2	10
2	2	6	10
4	4	4	12
3	2	1	6
6	6	4	16
6	1	4	11
4	3	3	10

Out of 627 dice, 83 outcomes shows 11 so required probability is:

P(sum 11) = 83 /627 = 0.1324

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member