T.DIST.RT

Formulas / T.DIST.RT
Calculate the right-tailed student's t-distribution.
T.DIST.RT(x,deg_freedom)
  • x - numeric value to evaluate the distribution on
  • deg_freedom - [REQUIRED] integer indicating the number of degrees of freedom in a data set

Examples

  • =T.DIST.RT(A2,A3)

    The T.DIST.RT function can be used to calculate the two-tailed distribution for a given data set. For example, the formula would calculate the two-tailed distribution for the data in A2 and A3.

  • =T.DIST.RT(12,15)

    If you were to calculate the two-tailed distribution for a data set consisting of two sets of numbers, such as 12 and 15, you would enter the preceding formula into a cell. This would return the two-tailed distribution for the data set.

    • Using the T.DIST.RT function can be helpful when you need to compare two different sets of data. For example, if you wanted to compare the average heights of two different groups, you could use the T.DIST.RT function to determine the two-tailed distribution between the two sets of data.

Summary

The T.DIST.RT function is a statistical function used in Sourcetable to calculate the right-tailed student's t-distribution. It is used to test hypotheses on small sample data sets, as well as to model asset returns and reduce the impact of heavy tails.

  • The T.DIST.RT function is a statistical function used in portfolio risk analysis to model asset returns with fatter tails.
  • The T.DIST.RT function calculates the right-tailed student's t-distribution, which is a continuous probability distribution.
  • The T.DIST.RT function can be used in place of a table of critical values for the T Distribution.


Frequently Asked Questions

What is the T.DIST.RT function?
The T.DIST.RT function returns the right-tailed Student's t-distribution. It is used to test hypotheses in small sample data sets.
What is the purpose of the t-distribution?
The t-distribution is used to test hypotheses in small sample data sets. It is used to compare a sample mean to the population mean to determine if there is a statistically significant difference.
What is the difference between right-tailed and left-tailed t-distributions?
The right-tailed t-distribution is used when you are looking to see if the sample mean is greater than the population mean. The left-tailed t-distribution is used when you are looking to see if the sample mean is less than the population mean.
When should I use the T.DIST.RT function?
The T.DIST.RT function should be used when you are looking to see if the sample mean is greater than the population mean. It can be used when testing hypotheses in small sample data sets.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV