# Calculations for Probabilities in Excel

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

#### Solution Summary

This solution provides calculations in Excel for determining probability.

$2.19