In Google Sheets, the TDIST function is used to calculate the cumulative probability of the t-distribution. It returns the probability associated with a given t-value.

The syntax for the TDIST function in Google Sheets is as follows:

TDIST(x, degrees_freedom, tails)

x: This is the numeric value at which you want to evaluate the cumulative t-distribution.

degrees_freedom: This is the number of degrees of freedom for the t-distribution. It represents the sample size minus one.

tails: This parameter specifies the number of tails for the t-distribution. It can be either 1 or 2.

If tails is 1, the TDIST function returns the one-tailed probability.

If tails is 2, the TDIST function returns the two-tailed probability.

The TDIST function assumes a standard (zero mean and unit variance) t-distribution.

Here's an example of how you can use the TDIST function in Google Sheets:

=TDIST(1.5, 10, 2)

This formula calculates the two-tailed probability for a t-value of 1.5, with 10 degrees of freedom.

Remember to replace the arguments (x, degrees_freedom, tails) in the formula with the actual values or cell references you want to use.