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

Statistics

CORREL

  • May 31, 2023
Definition: CORREL is a function that returns the correlation coefficient between two sets of data. Syntax: =CORREL(array1, array2) Situation: This formula is suitable when you need to find...
Read More

COUNTBLANK

  • May 31, 2023
Definition: COUNTBLANK is a function that counts the number of blank cells in a range. Syntax: =COUNTBLANK(range) Situation: This formula is suitable when you need to count the...
Read More

BETADIST

  • May 31, 2023
Definition: BETADIST is a function that returns the cumulative beta probability density function. Syntax: =BETADIST(x, alpha, beta, [lower], [upper]) Situation: This formula is suitable when you need to...
Read More

BETAINV

  • May 31, 2023
Definition: BETAINV is a function that returns the inverse of the cumulative beta probability density function. Syntax: =BETAINV(probability, alpha, beta, [lower], [upper]) Situation: This formula is suitable when...
Read More

BINOMDIST

  • May 31, 2023
Definition: BINOMDIST is a function that returns the individual term binomial distribution probability. Syntax: =BINOMDIST(number_s, trials, probability_s, [cumulative]) Situation: This formula is suitable when you need to find...
Read More

CHIDIST

  • May 31, 2023
Definition: CHIDIST is a function that returns the one-tailed probability of the chi-squared distribution. Syntax: =CHIDIST(x, degrees_freedom) Situation: This formula is suitable when you need to find the...
Read More

CHIINV

  • May 31, 2023
Definition: CHIINV is a function that returns the inverse of the one-tailed probability of the chi-squared distribution. Syntax: =CHIINV(probability, degrees_freedom) Situation: This formula is suitable when you need...
Read More

CHITEST

  • May 31, 2023
Definition: CHITEST is a function that tests the independence of two sets of data. Syntax: =CHITEST(actual_range, expected_range) Situation: This formula is suitable when you need to test whether...
Read More

CONFIDENCE

  • May 31, 2023
Definition: CONFIDENCE is a function that returns the confidence interval for a population mean. Syntax: =CONFIDENCE(alpha, standard_dev, size) Situation: This formula is suitable when you need to calculate...
Read More

AVEDEV

  • May 31, 2023
Definition: AVEDEV is a function that returns the average of the absolute deviations of data points from their mean. Syntax: =AVEDEV(number1, [number2], ...) Situation: This formula is suitable...
Read More