How to find the second standard deviation?
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 |
Answer: How to find the second standard deviation?
Hi Eric,
To find the second standard deviation, you can simply multiply the first standard deviation by 2. Here are the steps:
For example, if the first standard deviation is 5, then the second standard deviation would be 10 ( Code:
5 x 2 |
How to find the second standard deviation?
The standard deviation measures variation about the mean. Two standard
deviations is just twice the standard deviation: =2*STDEV(A1:A10) -- Gary''s Student - gsnu200752 "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 |
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 |
All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com