Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard deviation of specific cells in a column
Hi there,
Actually it's a more general question, but in this concrete situation i would like help with the standard deviation function. The situation is as follows; I have two (2) columns, one with some characteristics and one with values. Now I want to use the stdev function, but only on the values that fulfills the criterias. Fx would I like the standard deviation of only the 'a'-marked part of the array (here it would give me 0.10) a 1.5 b 1.4 c 1.4 a 1.6 a 1.4 Hope to hear from someone soon Regards Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Standard deviation of specific cells in a column
Try the following formula, which needs to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER... =STDEV(IF($A$1:$A$5="a",$B$1:$B$5)) Hope this helps! In article , Schwartz wrote: Hi there, Actually it's a more general question, but in this concrete situation i would like help with the standard deviation function. The situation is as follows; I have two (2) columns, one with some characteristics and one with values. Now I want to use the stdev function, but only on the values that fulfills the criterias. Fx would I like the standard deviation of only the 'a'-marked part of the array (here it would give me 0.10) a 1.5 b 1.4 c 1.4 a 1.6 a 1.4 Hope to hear from someone soon Regards Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
standard deviation | Excel Worksheet Functions | |||
Standard Deviation | Excel Worksheet Functions | |||
Standard Deviation | Excel Worksheet Functions | |||
Standard Deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) |