Many thanks!
Ken Silver

"Barb R." wrote:

I've used the function BINOMDIST before. I'm not sure if that's what you
need.

I created a table for the Binomial Distribution with a probability of R or
FEWER occurances with N (A5) trials and R (B5) successes. The probability of
occurrances of each trial is C4 in my spreadsheet.

Probability of R or fewer occurrances.
=BINOMDIST($B5,$A5,C$4,TRUE)

THe equation for Probability R is

=1-BINOMDIST($B5,$A5,C$4,TRUE)

Probability Exactly R

=BINOMDIST($B5,$A5,C$4,FALSE)

Probability R or Greater is

Probability Exactly R + Probability R

"PlugNChug" wrote:

Is there a function in Excel for conducting the Two-Sample Test for Binomial
Proportions (normal theory method)?