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

Statistics

FDIST

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

DCOUNT

  • May 31, 2023
Definition: DCOUNT is a function that counts the number of cells in a database that meet a specified condition. Syntax: =DCOUNT(database, field, criteria) Situation: This formula is suitable...
Read More

DCOUNTA

  • May 31, 2023
Definition: DCOUNTA is a function that counts the number of non-blank cells in a database that meet a specified condition. Syntax: =DCOUNTA(database, field, criteria) Situation: This formula is...
Read More

DEVSQ

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

DMAX

  • May 31, 2023
Definition: DMAX is a function that returns the maximum value in a database that meets a specified condition. Syntax: =DMAX(database, field, criteria) Situation: This formula is suitable when...
Read More

DMIN

  • May 31, 2023
Definition: DMIN is a function that returns the minimum value in a database that meets a specified condition. Syntax: =DMIN(database, field, criteria) Situation: This formula is suitable when...
Read More

COUNTIF

  • May 31, 2023
Definition: COUNTIF is a function that counts the number of cells in a range that meet a specified condition. Syntax: =COUNTIF(range, criteria) Situation: This formula is suitable when...
Read More

COUNTIFS

  • May 31, 2023
Definition: COUNTIFS is a function that counts the number of cells in a range that meet multiple specified conditions. Syntax: =COUNTIFS(range1, criteria1, [range2], [criteria2], ...) Situation: This formula...
Read More

COVAR

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

CRITBINOM

  • May 31, 2023
Definition: CRITBINOM is a function that returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. Syntax: =CRITBINOM(trials, probability_s,...
Read More