Plotting a Binomial Distribution in Excel:
Use the function = BINOMDIST(x, n, p, TRUE/FALSE)
You have to use either TRUE or FALSE is the past parameter.
TRUE is used when you want to calculate cumulative probability, and FALSE if you want to calculate probability for a particular trial.
I used FALSE since I wanted to calculate individual probabilities for different values of x. Here is the result of what I plotted:
Plotting a Poisson Distribution in Excel:
Use the function = =POISSON(x, λ, TRUE/FALSE)
Again True is used when we want to calculate cumulative probability. If you want to calculate probability for a particular value of x use FALSE.
I used False to calculate the probabilities for different values of x. Here is the result:
Conclusions you can draw from these plots:
1. For p=0.5 binomial distribution is symmetric.
2. As p increases for fixed n, binomial appears to shift towards the right.
3. Poisson distribution tends to behave like bell curve(Normal Distribution) for large values of λ.
PS1: Excel sheet is attached in case you want to experiment and learn more.
Link:- Probability Distributions Binomial and Poisson
PS2: Corrections/suggestions are welcom.
Use the function = BINOMDIST(x, n, p, TRUE/FALSE)
You have to use either TRUE or FALSE is the past parameter.
TRUE is used when you want to calculate cumulative probability, and FALSE if you want to calculate probability for a particular trial.
I used FALSE since I wanted to calculate individual probabilities for different values of x. Here is the result of what I plotted:
Use the function = =POISSON(x, λ, TRUE/FALSE)
Again True is used when we want to calculate cumulative probability. If you want to calculate probability for a particular value of x use FALSE.
I used False to calculate the probabilities for different values of x. Here is the result:
Conclusions you can draw from these plots:
1. For p=0.5 binomial distribution is symmetric.
2. As p increases for fixed n, binomial appears to shift towards the right.
3. Poisson distribution tends to behave like bell curve(Normal Distribution) for large values of λ.
PS1: Excel sheet is attached in case you want to experiment and learn more.
Link:- Probability Distributions Binomial and Poisson
PS2: Corrections/suggestions are welcom.
No comments:
Post a Comment