TTEST and TDIST, critical value lookup

[cwinters]

I am calculating a t-statistics using known means, standard deviation
and degrees of freedom. Because I am not dealing with the actua
population data arrays, I cannot use the TTEST function. So, I am jus
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 t
have a t-stat critical value lookup table in order to compare my calce
stat to the critical value at the appropriate dfs. Is there anyway
perhaps using TDIST, that I can eliminate the need for a critical valu
lookup table

 

[cwinters]

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

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

 

[Bernard Liengme]

Aint that the truth!

 

[Jerry W. Lewis]

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

Jerry