2006-12-27 05:35:15 · 4 answers · asked by PM 1 in Science & Mathematics ➔ Mathematics
I am not aware of a particular function that calculates the odds ratio. However, if you have a contingency table that looks like this
___| AO | AO' | Total
RF |_ a _|_ b _| a+b
RF'|_ c _|_ d _| c+d
Total_____________
___|a+c| b+d | a+b+c+d
(Sorry about the spacing; it's the best I can do on Y!A.)
Then the odds ratio of the AO given RF versus AO given RF' can be calculated as ad/cb. You can use Excel to find the value from those particular cells.
2006-12-27 06:05:41 · answer #1 · answered by blahb31 6 · 0⤊ 0⤋
Calculate Ratio In Excel
2016-11-15 03:50:22 · answer #2 · answered by ? 4 · 0⤊ 0⤋
I thought.... and I think that I know/knew excel but I have NO idea as to HOW or even if Excel can be used to calculate odds ratio(s)
2006-12-27 05:39:11 · answer #3 · answered by Anonymous · 0⤊ 0⤋
I don't know much about odds ratios, but from the Wikipedia article on the subject it would be fairly easy to set up an Excel table.
2006-12-27 14:34:58 · answer #4 · answered by Eclectic_N 4 · 0⤊ 0⤋
use the sum tool for numerator, then divide by element
=(sum(a2:a8)/a2)... odds for a2
2006-12-27 05:47:24 · answer #5 · answered by Brian D 5 · 0⤊ 0⤋