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

Excel Formulas

GAMMALN.PRECISE

  • May 31, 2023
Definition: GAMMALN.PRECISE is a function that returns the natural logarithm of the gamma function, using a more precise calculation method. Syntax: =GAMMALN.PRECISE(x) Situation: This formula is suitable when...
Read More

GEOMEAN

  • May 31, 2023
Definition: GEOMEAN is a function that returns the geometric mean of a set of numbers. Syntax: =GEOMEAN(number1, [number2], ...) Situation: This formula is suitable when you need to...
Read More

FINFO

  • May 31, 2023
Definition: FINFO is a function that returns information about a file. Syntax: =FINFO(filename, [file_info]) Situation: This formula is suitable when you need to obtain information about a file....
Read More

GROWTH

  • May 31, 2023
Definition: GROWTH is a function that predicts a future value using exponential regression. Syntax: =GROWTH(known_y's, [known_x's], [new_x's], [const]) Situation: This formula is suitable when you need to predict...
Read More

FINV

  • May 31, 2023
Definition: FINV is a function that returns the inverse of the F probability distribution for a specified set of parameters. Syntax: =FINV(probability, degrees_freedom1, degrees_freedom2) Situation: This formula is...
Read More

HARMEAN

  • May 31, 2023
Definition: HARMEAN is a function that returns the harmonic mean of a set of numbers. Syntax: =HARMEAN(number1, [number2], ...) Situation: This formula is suitable when you need to...
Read More

FISHER

  • May 31, 2023
Definition: FISHER is a function that returns the Fisher transformation of a specified value. Syntax: =FISHER(x) Situation: This formula is suitable when you need to find the Fisher...
Read More

HEX2BIN

  • May 31, 2023
Definition: HEX2BIN is a function that converts a hexadecimal number to binary. Syntax: =HEX2BIN(number, [places]) Situation: This formula is suitable when you need to convert a hexadecimal number...
Read More

FISHERINV

  • May 31, 2023
Definition: FISHERINV is a function that returns the inverse of the Fisher transformation of a specified value. Syntax: =FISHERINV(y) Situation: This formula is suitable when you need to...
Read More

HEX2DEC

  • May 31, 2023
Definition: HEX2DEC is a function that converts a hexadecimal number to decimal. Syntax: =HEX2DEC(number) Situation: This formula is suitable when you need to convert a hexadecimal number to...
Read More