I have the results of a meta-analysis of 10 studies that reports a combined random effects odds ratio (computed using Woolf's method) and 95% confidence interval of an event happening in one group relative to another:
$OR = 7.1\ (95\%\ CI\ 4.4-11.7)$
I'm now building a model that needs to sample around this odds ratio (for the purposes of a probabilistic sensitivity analysis). Given that it's an odds ratio, I'm assuming that it's log-normally distributed and that 7.1 is the mean, but what's the best way to convert the confidence interval to a standard deviation so I can sample the distribution using Excel's LOGNORMDIST
function?
(I've found similar questions for the normal and gamma distributions (From confidence interval to standard deviation - what am I missing? and How to calculate mean and standard deviation in R given confidence interval and a normal or gamma distribution?) and also questions calculating the confidence interval for a log-normal distribution (How do I calculate a confidence interval for the mean of a log-normal data set?), but I can't seem to find how to go the other way round.)