# Calculations for Probabilities in Excel

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

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 ad1c9bdddfhttps://brainmass.com/statistics/sample-size-determination/calculations-probabilities-excel-152165

#### Solution Summary

This solution provides calculations in Excel for determining probability.

$2.49