ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculating p-value from Fisher's Exact Test for XYZ parameters (https://www.excelbanter.com/excel-worksheet-functions/83717-calculating-p-value-fishers-exact-test-xyz-parameters.html)

paulinoluciano

Calculating p-value from Fisher's Exact Test for XYZ parameters
 
I have the following 2 sets of data:

X1 Y1 Z1 X2 Y2 Z2
0.23 1235 12 0.10 1564 5
0.32 1325 11 0.12 1658 6
0.32 1525 9 0.08 1785 7

and I want to determine whether the X1,Y1,Z1 and X2,Y2,Z2 sets are
significantly different. I'd
like to use Fisher's Exact Test but I'm not a statistician I'd like
know if would it possible and if not what would it be the best test to
be used.
Can I do this in Excel using VBA codes? If so, how?

Thanks in advance



All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com