Question

Assume that Xtilde operator bin(n,p). What EXCEL formula is used to calculate P(X=x)?

Assume that Xtilde operator bin(n,p). What EXCEL formula is used to calculate P(X=x)?

Homework Answers

Answer #1

EXCEL formula used to calculate P(X=x) is

BINOMDIST(Number_s, Trials, Probability_s, Cumulative)

Where,

  • Number_s    is the number of successes in trials.

  • Trials    is the number of independent trials.

  • Probability_s     is the probability of success on each trial.

  • Cumulative     is a logical value that determines the form of the function. If cumulative is TRUE, then BINOMDIST returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE, it returns the probability mass function, which is the probability that there are number_s successes.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
If X ~ Bin (n, p) and Y ~ Bin (n, 1 - p). Verify that...
If X ~ Bin (n, p) and Y ~ Bin (n, 1 - p). Verify that for any k = 1, 2,.... P (X = k) = P (Y = n - k)
1) If x- Bin(n=8, p=0.25) a- calculate the value of. b- determine the value of p[x=1]?...
1) If x- Bin(n=8, p=0.25) a- calculate the value of. b- determine the value of p[x=1]? c- what is the probability that X is not more than 3?
p =0.1 n= 10 a) P( X_>5) give Excel formula b) P( X_>6) give Excel formula...
p =0.1 n= 10 a) P( X_>5) give Excel formula b) P( X_>6) give Excel formula c) P( X_>7) give Excel formula d) P( X_>8) give Excel formula
suppose that X ~ Bin(n, p) a. show that E(X^k)=npE((Y+1)^(k-1)) where Y ~ Bin(n-1, p) b....
suppose that X ~ Bin(n, p) a. show that E(X^k)=npE((Y+1)^(k-1)) where Y ~ Bin(n-1, p) b. use part (a) to find E(x^2)
Calculate the mgf for a Bin(n,p) distribution. Use this to find the mean and variance.
Calculate the mgf for a Bin(n,p) distribution. Use this to find the mean and variance.
Using the expected value and variance of a random variable X~Bin(n,p), find an expression for E(X^2)...
Using the expected value and variance of a random variable X~Bin(n,p), find an expression for E(X^2) in terms of n and p.
Show that if two binomial random variables X ∼ Bin(a,p) and Y ∼ Bin(b,p) are independent,...
Show that if two binomial random variables X ∼ Bin(a,p) and Y ∼ Bin(b,p) are independent, then X + Y ∼ Bin(a + b, p), using the technique of moment generating function.
Excel has a formula to calculate Net Present Value. Explain how the formula is used to...
Excel has a formula to calculate Net Present Value. Explain how the formula is used to perform the calculation. Specifically, identify each component of the formula and explain its meaning.
Consider a one-dimensional real-space wave-function ψ(x) and let Pˆ denote the parity operator such that P...
Consider a one-dimensional real-space wave-function ψ(x) and let Pˆ denote the parity operator such that P ψˆ (x) = ψ(−x). a)Starting from the Rodrigues formula for Hermitian polynomials, Hn(y) = (−1)^n*e^y^2*(d^n/dy^n)e^-y^2 with n ∈ N, show that the eigenfunctions ψn(x) of the one-dimensional harmonic oscillator, with mass m and frequency ω, are also eigenfunctions of the parity operator. What are the eigenvalues? b)Define the operator Π = exp [  iπ (( 1 /2α) *pˆ 2 + α xˆ 2/ (h/2π)^2-1/2)] ,...
For a Binomial Random Variable with n = 22 and p = .54, use Excel to...
For a Binomial Random Variable with n = 22 and p = .54, use Excel to calculate: P(X = 8) P(X <=15) P(X > 13) P(X ≥ 10) P(9<=X<=21) For a Normal Random Variable with μ = 22 and σ = 5.4, use Excel to calculate: P(X < 18) P(X > 26) P(X > 10) P(17 < X < 31) You should attach an Excel file showing all of your work, including formulas.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT