Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 150
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
standard deviation ckatz Excel Worksheet Functions 1 October 25th 06 08:31 PM
Standard Deviation Stan Banner Excel Worksheet Functions 1 March 12th 06 01:54 AM
Standard Deviation Stan Banner Excel Worksheet Functions 1 March 11th 06 10:11 PM
Standard Deviation Carlos Excel Worksheet Functions 10 January 2nd 06 10:17 AM
standard deviation Chris Excel Discussion (Misc queries) 1 October 13th 05 04:52 AM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"