A
Anand
If I have the mean and a 95% probability value for a distribution, is there a
function that will calculate the standard deviation?
I currently use norminv with a guess for the standard deviation and then
goal seek to get the implied standard deviation. I was wondering if there is
a more straightforward way to calculate the implied standard deviation if I
know the mean and the 95% probability value.
Thanks,
Anand
function that will calculate the standard deviation?
I currently use norminv with a guess for the standard deviation and then
goal seek to get the implied standard deviation. I was wondering if there is
a more straightforward way to calculate the implied standard deviation if I
know the mean and the 95% probability value.
Thanks,
Anand