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

Excel Formulas

SUMIF

  • May 31, 2023
Definition: The SUMIF function in Excel is used to find the sum of a range of data that meets a specified criteria. Syntax: ==SUMIF(range, criteria, [sum_range]). Situation: This...
Read More

SKEW.P

  • May 31, 2023
Definition: The SKEW.P function in Excel is utilized to calculate the skewness of a population. Syntax: ==SKEW.P(range). Situation: Use this function when you need to find the skewness...
Read More

SUMIFS

  • May 31, 2023
Definition: The SUMIFS function in Excel is used to find the sum of a range of data that meets multiple specified criteria. Syntax: ==SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],...
Read More

SLN

  • May 31, 2023
Definition: The SLN function in Excel calculates the straight-line depreciation of an asset. Syntax: ==SLN(cost, salvage, life). Situation: This function is appropriate when calculating the depreciation of an...
Read More

SLOPE

  • May 31, 2023
Definition: The SLOPE function in Excel calculates the slope of a linear regression line between two sets of data. Syntax: ==SLOPE(known_y's, known_x's). Situation: This function is beneficial when...
Read More

SMALL

  • May 31, 2023
Definition: The SMALL function in Excel is used to find the k-th smallest value in a range of data. Syntax: ==SMALL(array, k). Situation: This formula is appropriate in...
Read More

SQRT

  • May 31, 2023
Definition: The SQRT function in Excel is used to find the square root of a number. Syntax: ==SQRT(number). Situation: This formula is appropriate in situations where you need...
Read More

SQRTPI

  • May 31, 2023
Definition: The SQRTPI function in Excel is used to find the square root of a number multiplied by pi. Syntax: ==SQRTPI(number). Situation: This formula is appropriate in situations...
Read More

STANDARDIZE

  • May 31, 2023
Definition: The STANDARDIZE function in Excel is used to normalize a set of data to a standard distribution. Syntax: ==STANDARDIZE(x, mean, standard_dev). Situation: This formula is appropriate in...
Read More

STDEV

  • May 31, 2023
Definition: The STDEV function in Excel is used to find the standard deviation of a set of data. Syntax: ==STDEV(range). Situation: This formula is appropriate in situations where...
Read More