[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
    - BETADIST
    - BETAINV
    - BINOMDIST
    - CHIDIST
    - CHIINV
    - CHITEST
    - CONFIDENCE
    - COVAR
    - CRITBINOM
    - EXPONDIST
    - FDIST
    - FLOOR
    - FTEST
    - GAMMADIST
    - GAMMAINV
    - HYPGEOMDIST
    - LOGINV
    - LOGNORMDIST
    - MODE
    - NEGBINOMDIST
    - NORM.INV
    - NORMDIST
    - NORMSDIST
    - NORMSINV
    - PERCENTILE
    - PERCENTRANK
    - POISSON
    - QUARTILE
    - RANK
    - STDEV
    - STDEVP
    - TDIST
    - TINV
    - TTEST
    - VAR
    - VARP
    - WEIBULL
    - ZTEST
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

TDIST

This function returns the probability for the t-distribution.

Syntax

TDIST( x, deg, tails )

Arguments

This function has these arguments:

Argument	Description
x	Probability of the two-tailed student’s t-distribution
deg	Number of degrees of freedom to characterize the distribution; if not an integer, the number is truncated
tails	Number of tails to return; if not an integer, the number is truncated; for 1, returns one‑tailed distribution; for 2, returns two‑tailed distribution

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

TDIST(A1,B45,2)

TDIST(0.245,2,1) gives the result 0.414651