Question

In: Statistics and Probability

Use Excel to generate the probability distribution for a binomial random variable for which there are...

Use Excel to generate the probability distribution for a binomial random variable for which there are 20 trials (n = 20) and the probability of success is 0.5 (p = 0.5), and show the graph.

Solutions

Expert Solution

Using Excel and the command  .

For different values 0, 1, 2, ..., 20. trials is 20, probability is 0.5, and cumulative is choosen as False.

Then gives . The following output is obtained for different values


Related Solutions

a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability...
a/Use Excel to find the discrete probability and cumulative probability of the Binomial distribution with probability of success p = 0.75 and n = 80. Find its mean and variance. b/Based upon Excel chart, what can you conclude about the binomial convergence? Hint: Use binom.dist function on Excel and sketch the curve.
If x is a binomial random​ variable, use the binomial probability table to find the probabilities...
If x is a binomial random​ variable, use the binomial probability table to find the probabilities below. a. P(x<6) for n = 15, p=0.2 b. P(x>=14) for n=20, p=0.8 c. P(x=23) for n=25, p=0.1
If x is a binomial random​ variable, use the binomial probability table to find the probabilities...
If x is a binomial random​ variable, use the binomial probability table to find the probabilities below. a. P(x=3) for n=10, p=0.5 b. P(x≤4) for n=15, p=0.3 c. P(x>1) for n=5, p=0.2 d. P(x<6) for n=15, p=0.8 e. P(x≥14) for n=25, p=0.8 f. P(x=3) for n=20, p=0.1
Assume the random variable X has a binomial distribution with the given probability of obtaining a...
Assume the random variable X has a binomial distribution with the given probability of obtaining a success. Find the following probability, given the number of trials and the probability of obtaining a success. Round your answer to four decimal places. P(X=6), n=10 , p=0.5
Assume the random variable X has a binomial distribution with the given probability of obtaining a...
Assume the random variable X has a binomial distribution with the given probability of obtaining a success. Find the following probability, given the number of trials and the probability of obtaining a success. Round your answer to four decimal places. P(X≤4), n=7, p=0.6
Assume the random variable X has a binomial distribution with the given probability of obtaining a...
Assume the random variable X has a binomial distribution with the given probability of obtaining a success. Find the following probability, given the number of trials and the probability of obtaining a success. Round your answer to four decimal places. P(X=14), n=15, p=0.7
To use Excel INV functions, such as XXXX.INV(probability,....) to generate random variates, replace probability by: the...
To use Excel INV functions, such as XXXX.INV(probability,....) to generate random variates, replace probability by: the mean of the distribution 0.05, the level of significance the uniform distribution formula RAND()
Which of the following situations describes a random variable that has a binomial distribution? a)A fair...
Which of the following situations describes a random variable that has a binomial distribution? a)A fair coin is tossed 10 times. The variable X is the number of heads resulting from these 10 tosses. b)A couple will keep having children until they have three girls or five children. The variable X is the number of children in the family. c)The variable X is the number of clients in the bank between 10:00 a.m. and 11:00 a.m. d)Fifteen cards are taken...
7) Use Excel to generate a series of 100 random values from the exponential distribution with...
7) Use Excel to generate a series of 100 random values from the exponential distribution with a mean of 25? USING EXCEL SHOW ALL WORK
Prove that the variance of a random variable with negative binomial distribution (with parameters ? and...
Prove that the variance of a random variable with negative binomial distribution (with parameters ? and ?) is ?(1 − ?)/?^2. Prove that the variance of a random variable with hypergeometric ?−? ? ? distribution (with parameters ?, ?, ?) is (M-n)/(N-1) ?(M/N) (1 − (M/N)) . 3. Prove that the variance of a random variable with uniform distribution (with parameters ? and ?) is ((a-b)^2)/12 .
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT