TDIST

legacy form of T.DIST.RT / T.DIST.2T · from excel · excel: not yet compared · sheets: not yet compared

signature

TDIST(x, deg_freedom, tails)

returns: number

argumentrequired
x required
deg_freedom required
tails required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

fx =TDIST(2, 10, 1) 0.03669401738537015

errors

error values observed from the engine — each with a call that produces it.

errorproduced by
#NUM! =TDIST(2, 0.5, 2)

related

  • AVEDEV average of absolute deviations from the mean
  • AVERAGE.WEIGHTED average of values weighted by a second range
  • AVERAGEA averages values including text and logicals
  • AVERAGEIF averages cells that match a condition
  • AVERAGEIFS averages cells matching multiple conditions
  • BETA.DIST beta distribution