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

Statistics

TREND

  • May 31, 2023
Definition: The TREND function in Excel is used to calculate the linear trendline for a set of data. Syntax: ==TREND(known_y's, [known_x's], [new_x's], [const]). Situation: This formula is appropriate...
Read More

VAR

  • May 31, 2023
Definition: The VAR function in Excel is used to find the variance of a range of data. Syntax: ==VAR(number1, [number2], ...). Situation: This formula is appropriate in situations...
Read More

VARA

  • May 31, 2023
Definition: The VARA function in Excel is used to find the variance of a range of data that contains text or logical values. Syntax: ==VARA(number1, [number2], ...). Situation:...
Read More

VARP

  • May 31, 2023
Definition: The VARP function in Excel is used to find the variance of a population of data. Syntax: ==VARP(number1, [number2], ...). Situation: This formula is appropriate in situations...
Read More

VARPA

  • May 31, 2023
Definition: The VARPA function in Excel is used to find the variance of a population of data that contains text or logical values. Syntax: ==VARPA(number1, [number2], ...). Situation:...
Read More

WEIBULL

  • May 31, 2023
Definition: The WEIBULL function in Excel is used to find the Weibull distribution of a set of data. Syntax: ==WEIBULL(x, alpha, beta, [cumulative]). Situation: This formula is appropriate...
Read More

TINV

  • May 31, 2023
Definition: The TINV function in Excel is used to find the value of t for a given probability and degrees of freedom for a Student's t-distribution. Syntax: ==TINV(probability,...
Read More

SUMX2MY2

  • May 31, 2023
Definition: The SUMX2MY2 function in Excel is used to find the sum of the difference between squares of two corresponding arrays. Syntax: ==SUMX2MY2(array_x, array_y). Situation: This formula is...
Read More

SUMX2PY2

  • May 31, 2023
Definition: The SUMX2PY2 function in Excel is used to find the sum of the sum of squares of two corresponding arrays. Syntax: ==SUMX2PY2(array_x, array_y). Situation: This formula is...
Read More

SUMXMY2

  • May 31, 2023
Definition: The SUMXMY2 function in Excel is used to find the sum of the square of the difference between corresponding values in two arrays. Syntax: ==SUMXMY2(array_x, array_y). Situation:...
Read More