M N O P Q R S H D B C D E F G W N - The first game consisted of rolling 4 dice and winning if you get at least one "ace" (the number one).)...
View the step-by-step solution to:

Question

Dice.jpg

Please help me figure this out. Please display the

formula.

Dice.jpg

M
N
O
P
Q
R
S
H
D
B
C
D
E
F
G
W N -
The first game consisted of rolling 4 dice and winning if you get at least one "ace" (the number one).
a.
a.)
a.)
a.)
b.)
Roll #1
Roll #2
Roll #3
Roll #4
# Aces
a.) Enter a RANDBETWEEN function to roll a die giving the numbers 1 - 6 with equal probability. Fill this formula down and across.
REG. . VOVIA WNH
b.) Enter a COUNTIF function that counts how many aces occurred for each trial (4 dice rolls) and fill down.
# 0 Aces
c.) Enter a COUNTIF function which counts the total number of times exactly 0 aces
# At Least 1 Ace
occurred. Count the number of times at least 1 ace occurred using the 3rd law of
P(At Least 1 Ace)
probability. Estimate the probability of getting at least 1 ace by dividing this count by
the total number of trials 35 and format as a percentage to 1 decimal place.
d.)
Simulation
Probability
The obtained values are only one
d.) Perform 10 simulations of this experiment by clicking on the F9 key (PC)
of possible sets of probabilities
and keep track of probabilities you get in the table below. Find the
13
1
2
you can get performing 10
Max and Min from the obtained table. Enter the Max and Min probability as a
14
percentage to 1 decimal place in the table provided
15
w
simulations.
20
4
17
5
18
6
23
19
24
20
25
21
26
22
10
27
23
28
24
29
25
Max
d.)
e.) Recall that we are using this simulation to ESTIMATE the probability of getting at
26
Min
d.)
least 1 ace. Each time you run a simulation the estimate will differ, introducing
30
27
VARIABILITY into our estimate. Compute the value in the middle of the Max and Min.
31
32
28
Middle
e.)
33
29
34
30
35
31
36
32
37
33
38
34
39
35
40

Top Answer

The calculations in each of the parts are shown below: a) In cells B5, C5, D5, E5, the following formula is... View the full answer

1.JPG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question