Explore BrainMass

Explore BrainMass

    hypergeometric, binomial, and poisson graphs using Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 1, 2020, 9:16 pm ad1c9bdddf

    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.