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

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***

Expert Solution

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

milcah answered 4 months ago

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

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

Find the probability that: Rolling a fair die 3 times, at least two dice are less...

Find the probability that: Rolling a fair die 3 times, at least two dice are less than 4. Previous answers have suggested 0.875 (189 feasible cases/ 216 total cases). However, from simple trial and error we can see that there are more than 27 cases where this answers fails. For example is the first dice gets a 4 and the 2nd dice gets 4,5,6 and the last dice gets any number, there is already 18 cases here that are not...

a) Three fair dice are tossed 1000 times. Create a simulation of these 1000 tosses, and...

a) Three fair dice are tossed 1000 times. Create a simulation of these 1000 tosses, and compute the probability that the sum of the three dice 7 or less. (Hint: randbtween) b) Mike and Monica arrive randomly at the golf course between 8am and 10am. What is the probability they arrive within 30min of each other? (Hint: 120*rand() ?)

How many times of “3” are expected to get in rolling an unloaded dice 50 times?...

How many times of “3” are expected to get in rolling an unloaded dice 50 times? Select one: a. 25 times b. 8 times c. 16.67 times d. 8.33 times

1. Consider a biased dice, where the probability of rolling a 3 is 4 9 ....

1. Consider a biased dice, where the probability of rolling a 3 is 4 9 . The dice is rolled 7 times. If X denotes the number of 3’s thrown, then find the binomial distribution for x = 0, 1, . . . 7 and complete the following table (reproducing it in your written solutions). Give your answers to three decimal places. x 0 1 2 3 4 5 6 7 Pr(X=x) 2. The Maths Students Society (AUMS) decides to...

Consider rolling two regular, fair, 6-sided dice 10 times. What is the probability that at least...

Consider rolling two regular, fair, 6-sided dice 10 times. What is the probability that at least two of the rolls have a sum that exceeds 6. at least 7 of the rolls have a sum that is even. exactly three rolls have a sum equaling 5.

Rolling a dice 15 times, find the probability of 6 consecutive rolls have 6 distinct numbers....

Rolling a dice 15 times, find the probability of 6 consecutive rolls have 6 distinct numbers. (i.e. 423123456..., 45612335626..., etc.)

Find the probability of rolling a sum of two dice that is a 7 or a...

Find the probability of rolling a sum of two dice that is a 7 or a 12. Round answer to 4 decimal places.

Consider a random experiment of rolling 2 dice. What is probability of rolling a sum larger...

Consider a random experiment of rolling 2 dice. What is probability of rolling a sum larger than 9? Select the best answer. A. 0.5 B. 0.1667 C. 0.2333 D. None of the above

You are rolling a fair dice 100 times. Let N be the number of times out...

You are rolling a fair dice 100 times. Let N be the number of times out of 100, when you roll an odd number. What is the most suitable distribution for N? Type one of the following (Poisson, binomial, normal,geometric) . Determine the probability that the number of times N out of 100, when you roll an odd number is 60 or more P ( N ≥ 60 ) = (use R and round to the third decimal place). Which distribution is...

Question