Use @RISK to draw a binomial distribution that results from 50 trials with probability of success 0.3 on each trial, and use it to answer the following questions. a. What are the mean and standard deviation of this distribution? b. You have to be more careful in interpreting @RISK probabilities with a discrete distribution such as this binomial. For example, if you move the left slider to 11, you find a probability of 0.139 to the left of it. But is this the probability of “less than 11” or “less than or equal to 11”? One way to check is to use Excel’s BINOM.DIST function. Use this function to interpret the 0.139 value from @RISK. c. Using part b to guide you, use @RISK to find the probability that a random number from this distribution will be greater than 17. Check your answer by using the BINOM.DIST function appropriately in Excel.
Use @RISK to draw a binomial distribution that results from 50 trials with
a. What are the
b. You have to be more careful in interpreting @RISK probabilities with a discrete distribution such as this binomial. For example, if you move the left slider to 11, you find a probability of 0.139
to the left of it. But is this the probability of “less than 11” or “less than or equal to 11”? One way to check is to use Excel’s BINOM.DIST
@RISK.
c. Using part b to guide you, use @RISK to find the probability that a random number from this distribution will be greater than 17. Check your answer by using the BINOM.DIST function
appropriately in Excel.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 14 images
