View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ttest_guy ttest_guy is offline
external usenet poster
 
Posts: 1
Default specify non-contiguous cell range as arguments to TTEST()

Hello,

I have data from two groups interleaved in the same column. For the sake of
simplicity, let's imagine group A: rows 1-3,7-9; group B: rows 4-6,10-12. I
want to compare groups A and B with a ttest -witout having to displace values
everywhere-. However, I can not specify ranges, otherwise the ttest gets too
many arguments (the coma for specifying ranges is taken as the coma that
separates the different arguments. I tried using named selections
(shift+click on cells of group A, then name 'groupA' at the left of the
function bar, similar for group B), but it still doesn't work. I still get
ERROR IN VALUE.
Am I missing a simple workaround for that ?