Explore BrainMass

Explore BrainMass

    Calculations for Probabilities in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 March 4, 2021, 8:12 pm ad1c9bdddf

    Solution Summary

    This solution provides calculations in Excel for determining probability.