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

Excel Formulas

STDEVA

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

STDEVP

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

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

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

NOW

  • May 31, 2023
Definition: NOW is a function that returns the current date and time. Syntax: =NOW() Situation: This formula is appropriate when you need to get the current date and...
Read More

NPER

  • May 31, 2023
Definition: NPER is a function that calculates the number of payment periods for a loan or investment. Syntax: =NPER(rate, payment, present_value, [future_value], [type]) Situation: This formula is appropriate...
Read More

NPV

  • May 31, 2023
Definition: NPV is a function that calculates the net present value of a series of cash flows. Syntax: =NPV(rate, value1, [value2], ...) Situation: This formula is appropriate when...
Read More

OCT2BIN

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

OCT2DEC

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