Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
specify non-contiguous cell range as arguments to TTEST()
hi, !
assuming the test groups in ranges: "A" = [B2:B4,B7:B9] and "B" = [C2:C4,C7:C9] =ttest(subtotal(9,offset(b2,{0;1;2;5;6;7},)),subto tal(9,offset(c2,{0;1;2;5;6;7},)),1,2) (same result as using contiguous ranges) hth, hector. __ OP __ 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 ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
specify non-contiguous cell range as arguments to TTEST()
let's imagine group A: rows 1-3,7-9; group B: rows 4-6,10-12
Other methods... 1) With data in column B, maybe try with Ctrl+Shift+Enter {CSE}: =TTEST(IF({1,0},B1:B3,B7:B9),IF({1,0},B4:B6,B10:B1 2),1,2) This relies on data being regularly spread and could be extended by using CHOOSE({1,2,3,...},...) instead of IF({1,0},...). 2) More generally insert a group column in column A which contains "A" in rows 1-3,7-9 and "B" in rows 4-6,10-12, then try {CSE}: =TTEST(IF(A1:A12="A",B1:B12),IF(A1:A12="B",B1:B12) ,1,2) "ttest_guy" wrote in message ... 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
multiple range array with ttest | Excel Worksheet Functions | |||
non-contiguous cells as arguments to XIRR | Excel Discussion (Misc queries) | |||
pasting non-contiguous range of cells to new row, same cell locati | New Users to Excel | |||
TTest with values in non-contiguous ranges | Excel Worksheet Functions |