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

Excel Formulas

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

SUBSTITUTE

  • May 31, 2023
Definition: The SUBSTITUTE function in Excel is used to replace a part of a text string with a different text string. Syntax: ==SUBSTITUTE(text, old_text, new_text, [instance_num]). Situation: This...
Read More

SIN

  • May 31, 2023
Definition: The SIN function in Excel is utilized to calculate the sine of an angle. Syntax: ==SIN(number). Situation: This function is beneficial when you need to compute the...
Read More

SUBTOTAL

  • May 31, 2023
Definition: The SUBTOTAL function in Excel is used to calculate a subtotal for a range of data using a specified function. Syntax: ==SUBTOTAL(function_num, range). Situation: This formula is...
Read More

SINH

  • May 31, 2023
Definition: The SINH function in Excel calculates the hyperbolic sine of a number. Syntax: ==SINH(number). Situation: Use this function when needing to calculate the hyperbolic sine of a...
Read More

SUM

  • May 31, 2023
Definition: The SUM function in Excel is used to find the sum of a range of data. Syntax: ==SUM(number1, [number2], ...). Situation: This formula is appropriate in situations...
Read More

SKEW

  • May 31, 2023
Definition: The SKEW function in Excel calculates the skewness of a distribution. Syntax: ==SKEW(range). Situation: This function is suitable when you need to calculate the skewness of a...
Read More