Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ttest across multiple worksheets
Hi there
I'd like to conduct a TTest across multiple worksheets. I have datasets where the values to be compared are in eg: 1!A1, 2!A1, 3!A1 etc (group 1) and 1!B1, 2!B1, 3!B1 etc (group 2) Using the ! function allows me to get mean and standard devations across the multiple worksheets but it doesn't seem to work for the Ttest. Any suggestions? Many thanks, Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple range array with ttest | Excel Worksheet Functions | |||
Degrees of Freedom in TTest | Excel Worksheet Functions | |||
Ttest | Excel Worksheet Functions | |||
AVOVA or TTEST | Excel Discussion (Misc queries) | |||
ttest function | Excel Worksheet Functions |