+ Reply to Thread
Results 1 to 2 of 2

Function TTEst in Excel

Hybrid View

Guest Function TTEst in Excel 03-21-2006, 07:30 AM
Guest RE: Function TTEst in Excel 03-21-2006, 08:55 AM
  1. #1
    Serg
    Guest

    Function TTEst in Excel

    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/~jessi...ng%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




  2. #2
    Jerry W. Lewis
    Guest

    RE: Function TTEst in Excel

    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

    "Serg" wrote:

    > 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/~jessi...ng%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 Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1