View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to find the second standard deviation?

I suspect you may mean 2 standard deviations which is simply standard
deviation * 2. In a normal distribution 95.45% of the data points would be
within 2 standard deviations

Mike

"Eric" wrote:

Does anyone have any suggestions on how to find the second standard deviation?
For the first S.D., which is STDEV(a1:a20).
Does anyone have any suggestions?
Thanks in advance for any suggestions?
Eric