For contingency tables of other sizes, only the p-value of the two-tailed test can be returned.įor Example 1, FISHERTEST(B6:C7,1) =. When R1 contains a 2 × 2 contingency table, there is an optional second argument, tails = 1 (one-tailed test) or 2 (two-tailed test, default). Real Statistics Excel Function: The Real Statistics Resource Pack provides the following worksheet function.įISHERTEST(R1, tails) = the p-value calculated by the Fisher Exact Test for a 2 × 2, 2 × 3, 2 × 4, 2 × 5, 2 × 6, 2 × 7, 2 × 8, 2 × 9, 3 × 3, 3 × 4 or 3 × 5 contingency table contained in R1. Equivalently, we can use the formula (for versions of Excel starting with Excel 2010) ![]() ![]() When the conditions for Pearson’s chi-square test are not met, especially when one or more of the cells have exp i.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |