Standar Desviation with Conditions

[Liolaemus]

Hello, i a new member of the forum.

I just learned, self-taught, such as calculating the average of a set of data arranged in a column in differential form using as criterion the value of another column through AVERAGEIF function.

My problem is this. I need to calculate for each of these separate data sets the standard deviation, so as to finally obtain the mean and standard deviation of each of the subgroups defined by two criteria mentioned above.

I leave here a sketch of what I need:

A B C
1 2 45
2 1 43
1 1 56
2 1 58
2 1 43
1 2 39
2 2 50
1 1 33

I need know the Standar Deviation of the values of the Column C whose value respective in the column A is 1 and in the Column B is 2.
I hope has i was clear in the explication...

Thanks!

 

[Marcelo Branco]

Hi,

Welcome to the forum!

Try this array-formula assuming your data sample in A1:C8

=STDEV(IF(A1:A8=1,IF(B1:B8=2,C1:C8)))

You need to confirm with Ctrl+Shift+Enter
(hold down both Ctrl and Shift keys and hit Enter)

I got 4.242641 with your sample

HTH

M.

 

[Liolaemus]

OOOhh..
Thanks for you help, works very good, i spend whole afternoon on this problem..

 

[Marcelo Branco]

OOOhh..
Thanks for you help, works very good, i spend whole afternoon on this problem..

You are welcome and tks for the feedback

M.

 

[Jenny_Genesis]

Hey,
Is that the formula for excel av and Std..