Calculate T (Unrelated)

[XeonTeam]

Hey there, this has little to do with VB, so I will try to make it simple. As part of my A2 psychology coursework, I am to calculate t (unrelated) from my list of values. These being;

Males
-----
70.2
36.9
56.3
65.2
71.1
74.9
77.9
85.6
63.6
43.0

and

Females
------
89.00
82.20
100.20
105.00
111.20
107.30
77.20
77.10
74.90
107.80

However every time I attempt to do this, I always get the value "0.008710993" of which in my opinion is not true. I have been codeing Excel to calculate this so many different ways now that I think it has crashed.. :s

If anyone would be willing to spend the time, just to check the answer, it would be very helpful to me...

Just in case you need it, I have uploaded a copy of my .xls file to show you the basic calculation... (it uses an ADS(#value) to get rid of the +/-).

Thanks.

[opus]

I have no idea what kind of "T" you are calculating.
What is the correct formula for your "T"?
IMHO there must be a mistake, since the need for that ABS-Function should be!
The numbers in your excel "seem" to be correct, but that shouldn't be the point!

Formula for T
Using this formula I get t=4.300229