T
Tim Sutton
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
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