View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default Calculate 2 Standard Deviations

Michael -

If cell A1 has the standard deviation, e.g., =STDEV(data_range), then in
some other cell enter =2*A1.

- Mike
www.mikemiddleton.com

"Michael" wrote in message
oups.com...
Is it possible to calculate a figure for two standard deviations for a
series of numbers? I have the output for 1 SD, but need 2 SDs.