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

Blog

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

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

SINH

  • May 31, 2023
Definition: The SINH function in Excel calculates the hyperbolic sine of a number. Syntax: ==SINH(number). Situation: Use this function when needing to calculate the hyperbolic sine of a...
Read More

SIN

  • May 31, 2023
Definition: The SIN function in Excel is utilized to calculate the sine of an angle. Syntax: ==SIN(number). Situation: This function is beneficial when you need to compute the...
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

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

PDURATION

  • May 31, 2023
Definition: PDURATION is a function that calculates the duration of an investment with a constant periodic payment and a constant interest rate. Syntax: =PDURATION(rate, payment, present_value, [future_value], [type])...
Read More

OFFSET

  • May 31, 2023
Definition: OFFSET is a function that returns a reference to a range that is offset from a starting cell reference. Syntax: =OFFSET(reference, rows, cols, [height], [width]) Situation: This...
Read More

ODD

  • May 31, 2023
Definition: ODD is a function that rounds a number up to the nearest odd integer. Syntax: =ODD(number) Situation: This formula is appropriate when you need to round a...
Read More

OCT2HEX

  • May 31, 2023
Definition: OCT2HEX is a function that converts an octal number to a hexadecimal number. Syntax: =OCT2HEX(number, [places]) Situation: This formula is appropriate when you need to convert an...
Read More