# hypergeometric, binomial, and poisson graphs using Excel

Using EXCEL, contruct a a graph showing the entire distribution for:

a. Hypergepmetric, where n=4, N=20, and D=5

b. Binomial, where n=15 and p = 0.05

c. Poisson, where np = 1.0

https://brainmass.com/statistics/binomial/hypergeometric-binomial-poisson-graphs-excel-346741

#### Solution Preview

The attached Excel spreadsheet shows the solution. The step-by-step process is as follows, essentially identical to each distribution.

1. Find out the range of values that x can take for each distribution.

For the hypergeometric and binomial distributions, this should range from 0 to n.

For the Poisson, this should range from 0 to infinity (however the probabilities get extremely ...

#### Solution Summary

Hypergeometric, binomial and poisson graphs using Excel are examined.

$2.19