TTEST and TDIST, critical value lookup

I am calculating a t-statistics using known means, standard deviations and degrees of freedom. Because I am not dealing with the actual population data arrays, I cannot use the TTEST function. So, I am just do the underlying math of the t-test calc plugging in my means, sdevs, dfs and I come up with a nice t-statistic. However. I then need to have a t-stat critical value lookup table in order to compare my calced stat to the critical value at the appropriate dfs. Is there anyway, perhaps using TDIST, that I can eliminate the need for a critical value lookup table?

never mind, the answer is TDIST(ABS(my calced t stat),my calced dfs,2)

returns the right p value, wheee!! Excel is awesome.

Aint that the truth!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"cwinters" <[email protected]> wrote in
message news:[email protected]...
>
> never mind, the answer is TDIST(ABS(my calced t stat),my calced dfs,2)
>
> returns the right p value, wheee!! Excel is awesome.
>
>
> --
> cwinters
> ------------------------------------------------------------------------
> cwinters's Profile:
> http://www.excelforum.com/member.php...o&userid=18386
> View this thread: http://www.excelforum.com/showthread...hreadid=486061
>

And =TINV(0.05,df) is the critical value.

Jerry

cwinters wrote:

> never mind, the answer is TDIST(ABS(my calced t stat),my calced dfs,2)
>
> returns the right p value, wheee!! Excel is awesome.