Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
|
|||
|
|||
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
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard deviation | Excel Discussion (Misc queries) | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) | |||
how do you find the SD(standard deviation ) for the multiple reg | Excel Worksheet Functions |