Hello
I intend to check the difference between two groups.
The formula to find GROUP1 is COUNTIFS(B2:B989,1,C2:C989,">0"), which means to count all the lines with Number 1 in column B and the lines that GT>0 in column C.
The formula to find GROUP2 is COUNTIFS(B2:B989,1,C2:C989,">0",D2:D989,">0") which means to count all the lines with Number 1 in column B and the lines that GT>0 in column C and the lines that GT>0 in column D.
Can I check the ttest between Group 1 and group 2 based on the information here, or maybe I have to calculate it manually?
Thanks a lot!
I intend to check the difference between two groups.
The formula to find GROUP1 is COUNTIFS(B2:B989,1,C2:C989,">0"), which means to count all the lines with Number 1 in column B and the lines that GT>0 in column C.
The formula to find GROUP2 is COUNTIFS(B2:B989,1,C2:C989,">0",D2:D989,">0") which means to count all the lines with Number 1 in column B and the lines that GT>0 in column C and the lines that GT>0 in column D.
Can I check the ttest between Group 1 and group 2 based on the information here, or maybe I have to calculate it manually?
Thanks a lot!