Ztest and multiple arrays of data?

Have you tried selecting just those cells and naming the range?

And then referencing the named range instead?

Originally Posted by daffodil11

Have you tried selecting just those cells and naming the range?

And then referencing the named range instead?

Never thought of that, I'll give it a try.

Tried it out, it did not work. Tried creating the name and clicked "Use in Formula" but it did not work....