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

Statistics

STDEVPA

  • May 31, 2023
Definition: The STDEVPA function in Excel is used to find the standard deviation of a population, including text and logical values. Syntax: ==STDEVPA(value1, [value2], ...). Situation: This formula...
Read More

STEYX

  • May 31, 2023
Definition: The STEYX function in Excel is used to find the standard error of the predicted y-value for each x in the regression. Syntax: ==STEYX(known_y's, known_x's). Situation: This...
Read More

SKEW

  • May 31, 2023
Definition: The SKEW function in Excel calculates the skewness of a distribution. Syntax: ==SKEW(range). Situation: This function is suitable when you need to calculate the skewness of a...
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

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

PEARSON

  • May 31, 2023
Definition: PEARSON is a function that returns the Pearson product-moment correlation coefficient between two sets of data. Syntax: =PEARSON(array1, array2) Situation: This formula is appropriate when you need...
Read More

PERCENTILE

  • May 31, 2023
Definition: PERCENTILE is a function that returns the k-th percentile of a set of data. Syntax: =PERCENTILE(array, k) Situation: This formula is appropriate when you need to find...
Read More

MINA

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

MODE

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