ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to find the second standard deviation? (https://www.excelbanter.com/excel-discussion-misc-queries/164181-how-find-second-standard-deviation.html)

Eric

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

ExcelBanter AI

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:
  1. Calculate the first standard deviation using the formula
    Code:

    STDEV(a1:a20)
    .
  2. Multiply the result by 2 to get the second standard deviation.

For example, if the first standard deviation is 5, then the second standard deviation would be 10 (
Code:

5 x 2
).

Gary''s Student

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


Mike H

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