T.DIST - The function returns the Student t-distribution on the left in Excel
The following article introduces you to the T.DIST function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the Student's t-distribution on the left. Functions used in testing the hypothesis of small numbers of data sets. Support functions from Excel 2010 onwards.
Syntax: T.DIST (x, deg_freedom, cumulative)
Inside:
- x: Value used to evaluate the distribution, is a required parameter.
- deg_freedom: Number of degrees of freedom of the distribution, is a required parameter.
- cumulative: A logical value that determines the form of the function, which is a required parameter, including:
+ cumulative = True -> returns the cumulative distribution function.
+ cumulative = False -> returns the probability density function.
Attention:
- Any argument that is not a number -> the function returns the #VALUE! Error value
- If deg_freedom <1 -> the function returns an error value.
- The minimum value of deg_freedom must be equal to 1.
For example:
Calculate the Student's t-distribution on the left as described in the following data table:
- Calculates the Student's t-distribution on the left is returned with the cumulative distribution function. In a cell to calculate, enter the formula : = T.DIST (D6, D7, D8)
- Press Enter -> Student's left t-distribution is returned with the cumulative distribution function is:
- Calculate the Student's t-distribution on the left is returned with probability density function. In a cell to calculate, enter the formula : = T.DIST (D6, D7, D9)
- Press Enter -> Student's left t-distribution is returned with the probability density function is:
- If the number of degrees of freedom is less than 1 -> the function returns the error value:
Above are instructions and some specific examples when using T.DIST function in Excel.
Good luck!
You should read it
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excel
- T.DIST.2T - The function returns the two-tailed Student distribution in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel
- F.DIST - The function returns the probability distribution F in Excel
- LOGNORM.DIST - Function returns the logarithmic distribution of x in Excel
- CHISQ.DIST - Function returns the distribution when squared in Excel
- NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
- F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
- The EXPON.DIST function - The function returns the exponential distribution in Excel
Maybe you are interested
How to turn a photo into a painting using the Generative Fill function in Photoshop
How to use the TREND function in Excel
Google Sheets Functions to Simplify Your Budget Spreadsheets
Instructions for using the TRIMRANGE function to clean up Excel tables
How to master numerical data in Google Sheets with the AVERAGE function
Don't buy headphones if they lack this important function!