Re: TDist Formula and Explanation

I am trying to derive the formula that MS Excel uses
as part of the
tdist function to come up with the p-value. Can
anyone help me create
this formula so that I can calculate the p-value for
one sample of
data?



Excel's tdist is not the cdf of t, but rather one minus the cdf of the absolute value of t. So if the argument t is negative, you would get an error message. If the argument is positive, you get the right-hand tail.

Suippose t is negative and you want the probability that T < t. This probability can be calculated by tdist(-t,m,1).

I find this annoying and can't understand why they haven't fixed this flaw.

Jack
.

Relevant Pages

  • Re: TDist Formula and Explanation
    ... tdist function to come up with the p-value. ... Excel's tdist is not the cdf of t, ... Suippose t is negative and you want the probability ...
    (sci.stat.math)
  • Re: TDist Formula and Explanation
    ... tdist function to come up with the p-value. ... Excel's tdist is not the cdf of t, but rather one minus the cdf of the absolute value of t. ... Suippose t is negative and you want the probability that T < t. ...
    (sci.stat.math)
  • Re: TDist Formula and Explanation
    ... tdist function to come up with the p-value. ... minus the cdf of the absolute value of t. ...
    (sci.stat.math)
  • Re: Comparing fractions (or proportions)
    ... THE exact method provides a p-value which is BY ... result as least as extreme as that obtained by chance ... value i.e. the probability to get a data (x, n1, y, ...
    (sci.stat.math)
  • Re: Two nit-picks re definition of p-value (Was: goodness of fit ?)
    ... That's a nit pick on YOUR nit! ... If Ha is "greater than or equal", the more extreme in p-value is ... As I recall, in Fisher's Exact Test, the probability of the observed ...
    (sci.stat.math)