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?


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=486061

TTEST and TDIST, critical value lookup
 

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

TTEST and TDIST, critical value lookup
 

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

"cwinters" wrote in
message ...

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

TTEST and TDIST, critical value lookup
 

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.