Next: Computing probabilities less than
Up: Using Excel
Previous: Using Excel
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,
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
4. Click `OK'. The result will be printed on the cell where your cursor
was last located.