Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. create a simulation layout for rolling 3 dice 627

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

Other questions asked by students

Q

one model for the spread of a rumor is that the rate of spread is proportional to...

Basic Math
Q

A cardboard container is being designed. The container will be a rectangular shape, divided into 12...

Advance Math
Q

1). Consider the quadratic equation x^2+ 100 x + 1 = 0 (i) Compute approximate roots by...

Advance Math
Q

12. There is an interesting problem occurring with (poly(ethylene terephthalate )PET recycling. Some manufacturers are including additives...

Chemistry
Q

The height in feet of a ball thrown in the air from a ledge 112...

Basic Math
Q

A company that makes bicycles has determined that a new employee can assemble M(d), where...

Basic Math
Q

Question 8 About 2 of the population has a particular genetic mutation 100 people are...

Statistics
Q

Brothers Harry and Herman Hausyerday began operations of their machine shop (H \& H lool,...

Accounting
Q

Explain why it is important that the Supreme Court of Canada not be bound by...

Accounting
Q

JHS Corporation is a lessee with a capital lease. The asset is recorded at $1,000,000...

Accounting
Q

Presented below is information related to equipment owned by Sunland Company at December 312025

Accounting
Q

Required information Problem 11-1A (Algo) Short-term notes payable transactions and entries LO P1 Skip to...

Accounting