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

Statistics

NEGBINOMDIST

  • May 31, 2023
Definition: NEGBINOMDIST is a function that returns the negative binomial distribution of a given set of data. Syntax: =NEGBINOMDIST(number_f, number_s, probability_s) Situation: This formula is appropriate when you...
Read More

NORMDIST

  • May 31, 2023
Definition: NORMDIST is a function that returns the normal distribution for a specified mean and standard deviation. Syntax: =NORMDIST(x, mean, standard_dev, cumulative) Situation: This formula is appropriate when...
Read More

NORMINV

  • May 31, 2023
Definition: NORMINV is a function that returns the inverse of the normal distribution for a specified mean and standard deviation. Syntax: =NORMINV(probability, mean, standard_dev) Situation: This formula is...
Read More

NORMSDIST

  • May 31, 2023
Definition: NORMSDIST is a function that returns the standard normal cumulative distribution for a specified value. Syntax: =NORMSDIST(z) Situation: This formula is appropriate when you need to calculate...
Read More

NORMSINV

  • May 31, 2023
Definition: NORMSINV is a function that returns the inverse of the standard normal cumulative distribution for a specified probability. Syntax: =NORMSINV(probability) Situation: This formula is appropriate when you...
Read More

LOGNORMDIST

  • May 31, 2023
Definition: LOGNORMDIST is a function that returns the cumulative distribution function for a specified log-normal distribution. Syntax: =LOGNORMDIST(x, mean, standard_dev, cumulative) Situation: This formula is appropriate when you...
Read More

MAXA

  • May 31, 2023
Definition: MAXA is a function that returns the maximum value in a range of cells, and treats text and logical values as numbers. Syntax: =MAXA(number1, [number2], ...) Situation:...
Read More

MEDIAN

  • May 31, 2023
Definition: MEDIAN is a function that returns the median value in a range of cells. Syntax: =MEDIAN(number1, [number2], ...) Situation: This formula is appropriate when you need to...
Read More

KURT

  • May 31, 2023
Definition: KURT is a function that returns the kurtosis of a data set, which is a measure of the peakedness and tails of the distribution. Syntax: =KURT(number1, [number2],...
Read More

LARGE

  • May 31, 2023
Definition: LARGE is a function that returns the nth largest value in a data set. Syntax: =LARGE(array, k) Situation: This formula is appropriate when you need to find...
Read More