Explore BrainMass

Explore BrainMass

    Calculations for Probabilities in Excel

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

    In computing sample size for estimating population proportions, the formula involves p(1-p) (where we don't know p). We use p = ½ if we don't know anything about it, since that is a "worst case". Find the values of p(1-p) for p=.01, .02, .05, .10, .15, .20, .30, .40., .50, .60, .70,.80, .85, .90, .95, .98, and.99. Be prepared to graph these (this is trivial to do with Excel), and be prepared to talk about the graph.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:47 pm ad1c9bdddf
    https://brainmass.com/statistics/sample-size-determination/calculations-probabilities-excel-152165

    Solution Summary

    This solution provides calculations in Excel for determining probability.

    $2.19

    ADVERTISEMENT