Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Statistics

T.DIST

  • May 31, 2023
Definition: The T.DIST function in Excel is used to calculate the left-tailed probability of the Student's t-distribution. Syntax: ==T.DIST(x, degrees_freedom, cumulative). Situation: This formula is appropriate in situations...
Read More

T.DIST.2T

  • May 31, 2023
Definition: The T.DIST.2T function in Excel is used to calculate the two-tailed probability of the Student's t-distribution. Syntax: ==T.DIST.2T(x, degrees_freedom). Situation: This formula is appropriate in situations where...
Read More

T.DIST.RT

  • May 31, 2023
Definition: The T.DIST.RT function in Excel is used to calculate the right-tailed probability of the Student's t-distribution. Syntax: ==T.DIST.RT(x, degrees_freedom). Situation: This formula is appropriate in situations where...
Read More

T.INV

  • May 31, 2023
Definition: The T.INV function in Excel is used to find the inverse of the left-tailed probability of the Student's t-distribution. Syntax: ==T.INV(probability, degrees_freedom). Situation: This formula is appropriate...
Read More

T.INV.2T

  • May 31, 2023
Definition: The T.INV.2T function in Excel is used to find the inverse of the two-tailed probability of the Student's t-distribution. Syntax: ==T.INV.2T(probability, degrees_freedom). Situation: This formula is appropriate...
Read More

TDIST

  • May 31, 2023
Definition: The TDIST function in Excel is used to calculate the two-tailed probability of the Student's t-distribution. Syntax: ==TDIST(x, degrees_freedom, tails). Situation: This formula is appropriate in situations...
Read More

STANDARDIZE

  • May 31, 2023
Definition: The STANDARDIZE function in Excel is used to normalize a set of data to a standard distribution. Syntax: ==STANDARDIZE(x, mean, standard_dev). Situation: This formula is appropriate in...
Read More

STDEV

  • May 31, 2023
Definition: The STDEV function in Excel is used to find the standard deviation of a set of data. Syntax: ==STDEV(range). Situation: This formula is appropriate in situations where...
Read More

STDEVA

  • May 31, 2023
Definition: The STDEVA function in Excel is used to find the standard deviation of a set of data, including text and logical values. Syntax: ==STDEVA(value1, [value2], ...). Situation:...
Read More

STDEVP

  • May 31, 2023
Definition: The STDEVP function in Excel is used to find the standard deviation of a population. Syntax: ==STDEVP(range). Situation: This formula is appropriate in situations where you need...
Read More