> \p AnonymousFlohr Ba==``LY4,8X@"15Arial15Arial15Arial15Arial15Arial15Arial15Arial15Arial15Arial1
5Arial1
5Arial"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- + ) , * (
`
Sheet1
Sheet2Sheet3="
Number of positives+Total number examined (including positives)alpha for CLF for lcl (DO NOT EDIT)F for ucl (DO NOT EDIT)*To calculate binomial confidence limits: S1. put the number of positives in cell B6 and the total number examined in cell b7!Proportion positive (DO NOT EDIT)-3. results appear in cells b10, b11, and b12]2. If you want something other than 95% confidence limits, change the alpha level in cell B8GNote that if the number of positives is zero, the formula will not estimate a lower confidence limit, so I have added an if-then clause to make it come up as zero. This is the correct lower bound in these cases, anyway. The F value will then say UNDEFINED.zRoss Alford, School of Marine and Tropical Biology, James Cook University, Townsville, Qld 4811 Australia. 26 April 2007.sNote also that all the cells except B6 through B8 are protected, to make it difficult to change them by accident. @cc
dMbP?_*+%MKhp psc 1200 seriespsc 1200 ser!@m߀ dvertBe4d DArial8MBeںںhp psc 1200 seriespsc 1200 series,LocalOnly,DrvConvert" d??cU}%}
@
8@
~
~
R@
~
@
! DDD
d .Lower Dd% CL (DO NOT EDIT)Lower 95% CL (DO NOT EDIT)U
?D
'DDDDD
BC
-Upper Dd% CL (DO NOT EDITUpper 95% CL (DO NOT EDITFK\E? 0DDDDDD
ej
OD
.DDDDA UNDEFINEDB UNDEFINED
BG@ ,DDDDA
&@3
T>@7ggD
dMbP?_*+%"??U>@7
dMbP?_*+%"??U>@7
Oh+'0@H\p
Ross AlfordRoss AlfordMicrosoft Excel@_S@2՜.+,0 PXdlt|
JCUSheet1Sheet2Sheet3Worksheets
Root Entry F`>IJWorkbookSummaryInformation(DocumentSummaryInformation8