Ttest across multiple worksheets

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top