I'm not sure I phrased this title correctly. Please feel welcome to offer suggested edits.
I have data formatted like so:
Token,Location,Quantity
VBD,IN,100
NN,IN,200
FD,OUT,300
VBD,OUT,300
NN,OUT,400
NN,IN,100
Ultimately, I would like to perform t-tests on the Quantity of each Token, comparing IN and OUT. Is there a way to do this without filtering for each, and performing a t-test?
EDIT
The t-test part isn't relevant, per se, I'm just looking to insert a range into a formula. The =TTEST function, for example, takes the following arguments: TTEST(array1,array2,tails,type)
. If I wanted rows 2 and 6 in Array1
(NN,IN), and row 5 in Array2
, is there a formula I use within the TTEST
formula, in lieu of selecting the cells?