Question

I need to solve this using Excel. Calculate the probability of between 45 and 55 successes...

I need to solve this using Excel.

Calculate the probability of between 45 and 55 successes for a binomial random variable of 90 trials with a 40% probability of success.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Solution:

Probability of success = p = 40% = 0.4

Number of trials = n = 90

X follows Binomial(90 , 0.4)

P(45 and 55 successes)

= P[45 X 55]

= P[X 55] - P[X < 45]

= P[X 55] - P[X 44]

Use excel. BINOM.DIST(number , n , p, cumulative)

= BINOM.DIST(50,90,0.4,TRUE) - BINOM.DIST(44,90,0.4,TRUE)

= 0.033629817

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A random variable has a 0.02 probability of success in each independent trial, where the total...
A random variable has a 0.02 probability of success in each independent trial, where the total number of trials is n= 90.         a.     What is the expected number of successes in 90 trials?         b.     What is the standard deviation of successes in 90 trials?         c.     Use the binomial distribution to find the probability of 90 trials.         d.     Use the Poisson distribution to approximation find the probability of   in                90 trials.
Assume that a procedure yields a binomial distribution with nequals=55 trials and a probability of success...
Assume that a procedure yields a binomial distribution with nequals=55 trials and a probability of success of pequals=0.50 Use a binomial probability table to find the probability that the number of successes x is exactly 22.
For one binomial experiment, n1 = 75 binomial trials produced r1 = 45 successes. For a...
For one binomial experiment, n1 = 75 binomial trials produced r1 = 45 successes. For a second independent binomial experiment, n2 = 100 binomial trials produced r2 = 65 successes. At the 5% level of significance, test the claim that the probabilities of success for the two binomial experiments differ. (a) Compute the pooled probability of success for the two experiments. (Round your answer to three decimal places.) (b) Compute p̂1 - p̂2. p̂1 - p̂2 = (c) Compute the...
The binomial random variable x consists of n = 60 trials and has the probability of...
The binomial random variable x consists of n = 60 trials and has the probability of failure q = .4. Using the normal approximation, compute the probability of 45 successes.
Number of Successes Frequency Relative Frequency 0 10 0.13889 1 29 0.40278 2 26 0.36111 3...
Number of Successes Frequency Relative Frequency 0 10 0.13889 1 29 0.40278 2 26 0.36111 3 4 0.05556 4 3 0.04167 Total 72 1.00 Mean of Successes 1.458 Using Excel, construct the Binomial Probability Distribution for four trials, n, and probability of success, p, as the tractor sales success average.
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 ≥ 5 ), n = 6, p = 0.3 How do I determine if the answer should be Probability result or Cumulative result? Can you show me how to create a formula in excel to solve this problem?...
We will illustrate Chebyshev’s theorem using the binomial distribution. Suppose you are modeling successes on “cold...
We will illustrate Chebyshev’s theorem using the binomial distribution. Suppose you are modeling successes on “cold call sales” and that the probability of your success on such a call is 0.25 (you are very persuasive!) You will make 20 such calls. Define X≡number of successes on 20 calls (you may assume independence). What is the mean and the standard deviation of this random variable? What is the interval μ-2 σ≤X≤μ+2 σ ? c) Calculate P μ-2 σ≤X≤μ+2 σ
For one binomial experiment, n1 = 75 binomial trials produced r1 = 45 successes. For a...
For one binomial experiment, n1 = 75 binomial trials produced r1 = 45 successes. For a second independent binomial experiment, n2 = 100 binomial trials produced r2 = 65 successes. At the 5% level of significance, test the claim that the probabilities of success for the two binomial experiments differ. (a) Compute the pooled probability of success for the two experiments. (Round your answer to three decimal places.) (b) Check Requirements: What distribution does the sample test statistic follow? Explain....
For one binomial experiment, n1 = 75 binomial trials produced r1 = 45 successes. For a...
For one binomial experiment, n1 = 75 binomial trials produced r1 = 45 successes. For a second independent binomial experiment, n2 = 100 binomial trials produced r2 = 65 successes. At the 5% level of significance, test the claim that the probabilities of success for the two binomial experiments differ.(a) Compute the pooled probability of success for the two experiments. (Round your answer to three decimal places.) (b) Check Requirements: What distribution does the sample test statistic follow? Explain. The...
Suppose we have a binomial distribution with n trials and probability of success p. The random...
Suppose we have a binomial distribution with n trials and probability of success p. The random variable r is the number of successes in the n trials, and the random variable representing the proportion of successes is p̂ = r/n. (a) n = 44; p = 0.53; Compute P(0.30 ≤ p̂ ≤ 0.45). (Round your answer to four decimal places.) (b) n = 36; p = 0.29; Compute the probability that p̂ will exceed 0.35. (Round your answer to four...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT