next up previous contents index
Next: Computing probabilities less than Up: Using Excel Previous: Using Excel

Computing binomial probabilities

1. On the menu bar, click on `Insert'. Select `Function'. A new window with a list of functions will appear.
2. From the functions list, select `Statistical'. For function name, select `Binomdist'.
3. Enter the following arguments for Binomdist:
`Number_s' is the number of successes (x)
`Trials' is the number of trials (n)
`Probability_s' is the probability of success (p)
`Cumulative' is a logical value. Type `true' if you want a cumulative
probability (P[X <= x]). Type `false' if you want an exact
probability (P[X=x]).
4. Click `OK'. The result will be printed on the cell where your cursor was last located.