View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
anand anand is offline
external usenet poster
 
Posts: 37
Default Standard deviation calculation

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