0

I am trying to figure out how to apply a T.Test formula to a subset of data based on their Segment ID. In this example I only want to apply the formula to rows that have a Segment ID of A. Pretty much like how a sumifs function would work except instead of summing I just want to apply the ttest to a subset of data.

This picture should help illustrate what I'm trying to figure out.

enter image description here

FYI this was the formula I have for the T-Test Results.
=TTEST(B2:B10,C2:C10,1,3)

Just needing to know what kind of modifications I need to make to it to make it take Segment into consideration

2
  • Hi and welcome to WebApps. Have you thought of filtering the data, or using a query, and then basing your formula on the modified data?
    – Tedinoz
    Jan 12 at 4:03
  • Using your data and formula, I get a result = 0.03821199127 (compared to your result = 0.38242...). Am I missing something? Also, when I group Segment A, I get 0.0752608813733072. What result do you get for Group by A?
    – Tedinoz
    Jan 12 at 7:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.