Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Binomial Proportions: Two-Sample Test
Is there a function in Excel for conducting the Two-Sample Test for Binomial
Proportions (normal theory method)? |
#2
|
|||
|
|||
On Tue, 7 Jun 2005 13:29:01 -0700, PlugNChug
wrote: Is there a function in Excel for conducting the Two-Sample Test for Binomial Proportions (normal theory method)? I couldn't find one directly. However, you can compute the z statistic and then use it to run a ZTEST. (Usual caveats about Excel's normal calculations apply.) Assume P1 and P2 contain the proportion of "yes" responses in each sample and N1 and N2 contain the size of each sample. Then compute the pooled sample proportion in P3 as ( P1*N1 + P2*N2 ) / ( N1 + N2 ) and the z statistic (for a null hypothesis that the two population proportions are equal) is (P1-P2) / SQRT( P3 * (1-P3) * (1/N1 + 1/N2) ) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "I feel a wave of morning sickness coming on, and I want to be standing on your mother's grave when it hits." |
#3
|
|||
|
|||
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)? |
#4
|
|||
|
|||
Many thanks!
Ken Silver "Stan Brown" wrote: On Tue, 7 Jun 2005 13:29:01 -0700, PlugNChug wrote: Is there a function in Excel for conducting the Two-Sample Test for Binomial Proportions (normal theory method)? I couldn't find one directly. However, you can compute the z statistic and then use it to run a ZTEST. (Usual caveats about Excel's normal calculations apply.) Assume P1 and P2 contain the proportion of "yes" responses in each sample and N1 and N2 contain the size of each sample. Then compute the pooled sample proportion in P3 as ( P1*N1 + P2*N2 ) / ( N1 + N2 ) and the z statistic (for a null hypothesis that the two population proportions are equal) is (P1-P2) / SQRT( P3 * (1-P3) * (1/N1 + 1/N2) ) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "I feel a wave of morning sickness coming on, and I want to be standing on your mother's grave when it hits." |
#5
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistic: Problem with two one sided t-test | Excel Discussion (Misc queries) | |||
Copying data within worksheets with lookups | Excel Discussion (Misc queries) | |||
Excel competency test | Excel Discussion (Misc queries) | |||
=IF logical test to search only part of a cell | Excel Worksheet Functions | |||
test..where are my messages..test | New Users to Excel |