Sigma Squared

Excel Formulas

ATAN2

  • May 31, 2023
Definition: ATAN2 is a function that returns the arctangent of the quotient of two numbers. Syntax: =ATAN2(x_num, y_num) Situation: This formula is suitable when you need to find...

ATANH

  • May 31, 2023
Definition: ATANH is a function that returns the inverse hyperbolic tangent of a number. The inverse hyperbolic tangent of a number is the value whose hyperbolic tangent is...

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...

AVERAGE

  • May 31, 2023
Definition: AVERAGE is a function that returns the arithmetic mean of a list of numbers. Syntax: =AVERAGE(number1, [number2], ...) Situation: This formula is suitable when you need to...

AVERAGEA

  • May 31, 2023
Definition: AVERAGEA is a function that returns the arithmetic mean of a list of values, including text and logical values. Syntax: =AVERAGEA(value1, [value2], ...) Situation: This formula is...