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

Statistics

GAMMAINV

  • May 31, 2023
Definition: GAMMAINV is a function that returns the inverse of the gamma cumulative distribution for a specified set of parameters. Syntax: =GAMMAINV(probability, alpha, beta) Situation: This formula is...
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

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

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

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

DSTDEV

  • May 31, 2023
Definition: DSTDEV is a function that returns the standard deviation of a population based on a database that meets a specified condition. Syntax: =DSTDEV(database, field, criteria) Situation: This...
Read More

DSTDEVP

  • May 31, 2023
Definition: DSTDEVP is a function that returns the standard deviation of a population based on an entire database. Syntax: =DSTDEVP(database, field) Situation: This formula is suitable when you...
Read More

DVAR

  • May 31, 2023
Definition: DVAR is a function that returns the variance of a population based on a database that meets a specified condition. Syntax: =DVAR(database, field, criteria) Situation: This formula...
Read More

DVARP

  • May 31, 2023
Definition: DVARP is a function that returns the variance of a population based on an entire database. Syntax: =DVARP(database, field) Situation: This formula is suitable when you need...
Read More

EXPONDIST

  • May 31, 2023
Definition: EXPONDIST is a function that returns the exponential distribution for a specified set of parameters. Syntax: =EXPONDIST(x, lambda, [cumulative]) Situation: This formula is suitable when you need...
Read More