Function TTEst in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Serg - 21 Mar 2006 12:25 GMT

I need write function TTEst in my own program, which return value same TTEst
in MSExcel.
I try use code from:
http://www.public.iastate.edu/~jessie/PPB/Stats/Testing%20loads.htm

I found algorithm for T-value only. How can I find T probability using
T-value?
How work TTEst in MSExcel?

Best regard,
Serg

Reply to this Message

Jerry W. Lewis - 21 Mar 2006 13:51 GMT

If your program is written in Excel's VBA, simply use Worksheetfunction.TTest
or Worksheetfunction.TDist.

Otherwise, you could use
http://www.math.sfu.ca/~cbm/aands/page_948.htm
or
http://www.library.cornell.edu/nr/bookcpdf/c6-4.pdf
AFAIK, the best double precision implementation in existence is in Ian
Smith's VBA code
http://members.aol.com/iandjmsmith/examples.xls

Jerry

> I need write function TTEst in my own program, which return value same TTEst
> in MSExcel.
[quoted text clipped - 7 lines]
> Best regard,
> Serg

Reply to this Message