multiple range array with ttest

[erinlm]

Hi,
I would like to perform a TTEST on a set of data that is spread over many
ranges. I cannot sort this data as it is already used for a chart.
I tried nesting brackets but this doesn't work, though it may give an idea
of what I'm trying to do:
=TTEST(A1:A20, (B1:B4,B7:B10,B12:B18),2,3)
Any ideas?
Thanks so much!

 

[Mike Middleton]

erinlm -

Since it's only three small ranges, I would simply copy and paste the values
into C1:C15, and use =TTEST(A1:A20,C1:C15,2,3).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[erinlm]

Hi Mike,
Thanks for your help. The TTEST formula I posted is just an example, my
data is actually about 10 different ranges over the span of 150 rows. I have
copied and pasted, then sorted for each TTEST I need to do, but it is rather
brute force and I am surprised there is not an easier approach.
Any other ideas?
Thank you again,
Erin