conditional t.test (t.testif)

[Avit]

Hi all,

I am really just trying to do a ttest when a condition is met. So just like averageif, but with a ttest.
I was able to stdevif with an array, and I am pretty sure this will be an array too, but I can't quite get the formula

Example:
column b has male of female, column c has data i want to ttest with column d, but only for male.

Thanks a lot!

 

[Andrew Poulsom]

Example:

Excel 2010
	B	C	D	E
1	Gender	Value1	Value2
2	M	39	94	0.4043831
3	M	99	43
4	F	3	84
5	M	68	64
6	M	39	5
7	F	57	12
8	F	28	100
9	M	35	51
10	M	59	70
11	M	58	96
Sheet1

Cell Formulas
Range	Formula
E2	{=TTEST(IF(B2:B11="M",C2:C11),IF(B2:B11="M",D2:D11),1,1)}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Avit]

It worked, thank you very very much!

I am working on some statistical analysis for an NGO, so I am not sure what else I am going to need, but in case I want to ttest given two conditions (column b=male, column c = age (below 20, above 20 for example) - and ttest for columns d and e.
How would that be done?

Thanks again

 

[Andrew Poulsom]

Like this?

=TTEST(IF((B2:B11="M")*(C2:C11<20),D2:D11),IF((B2:B11="M")*(C2:C11<20),E2:E11),1,1)

Don't forget to confirm with Ctrl+Shift+Enter.

 

[Avit]

Thanks again,

I actually haven't checked it yet, but thank you anyway for all your help