TDIST Function

The TDIST function is one of the statistical functions. Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.

The TDIST function syntax is:

TDIST(x, deg-freedom, tails)

where

x is the value at which the function should be calculated. A numeric value greater than 0.

deg-freedom is the number of degrees of freedom, an integer greater than or equal to 1.

tails is a numeric value that specifies the number of distribution tails to return. If it is set to 1, the function returns the one-tailed distribution. If it is set to 2, the function returns the two-tailed distribution.

The values can be entered manually or included into the cells you make reference to.

To apply the TDIST function,

1. select the cell where you wish to display the result,
2. click the Insert function
   icon situated at the top toolbar,
   or right-click within a selected cell and select the Insert Function option from the menu,
   or click the
   icon situated at the formula bar,
3. select the Statistical function group from the list,
4. click the TDIST function,
5. enter the required arguments separating them by commas,
6. press the Enter button.

The result will be displayed in the selected cell.

Alla pagina precedente