Solving problems related to probability distribution in Excel, we have many functions that can support and solve. The following article, Taimienphi.vn will introduce to you the T.DIST function in Excel, please follow the syntax and examples below to know how to use this function.
T.DIST is a calculation function in Excel that produces a Student t-distribution on the left. This function is also one of the functions in the group of statistical functions that are preferred by users today.
T.DIST function in Excel
How to use T.DIST in Excel
1. Description and syntax used
This is the function that returns the Student’s t-distribution on the left. Functions used in testing the hypothesis of small numbers of data sets.
T.DIST (x, deg_freedom, cumulative)
– X: The value used to evaluate the distribution, is a required parameter.
– Deg_freedom: Number of degrees of the distribution, is a required parameter.
– Cumulative: The 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.
– Any argument that is not a number -> function returns an error value #VALUE!
– If Deg_freedom less first then the function returns the error value.
– Minimum value of Deg_freedom must equal first.
2. Examples of specific situations
Suppose you need to 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 the cell to calculate -> you enter the formula: = T.DIST (C3, C4, C5)
Press Enter -> Student’s t-distribution on the left is returned with the cumulative distribution function as:
– The Student’s left t-distribution is returned with a probability density function. In the cell to be calculated -> you enter the formula: =T.DIST (C3, C4, C6)
Press Enter -> Student’s left t-distribution is returned with the probability density function being:
– If the number of degrees of freedom is less than 1 -> the function returns the error value # DIV / 0!:
– If any argument is not a number, then the function is calculated T.DIST will produce an error #VALUE! As the picture below:
Above is the tutorial with some specific examples when you use T.DIST function in Excel. Use this function to help you calculate to return the Student’s t-distribution on the left. Functions used in testing the hypothesis of small data sets. Good luck!
The SUM function is also a basic function that you need to master the syntax and usage, in Excel Sum function has the function of summing a given number of numbers, knowing this function will help a lot for your work. when you use Excel.