Function TTEst in Excel

Serg · Mar 21, 2006

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 loads.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

Jerry W. Lewis · Mar 21, 2006

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

Function TTEst in Excel

Serg

Jerry W. Lewis