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

Statistics

LINEST

  • May 31, 2023
Definition: LINEST is a function that calculates the parameters of a linear regression line for a given set of data. Syntax: =LINEST(known_y's, [known_x's], [const], [stats]) Situation: This formula...
Read More

LOGEST

  • May 31, 2023
Definition: LOGEST is a function that calculates an exponential curve that fits a set of data points using the least squares method. Syntax: =LOGEST(known_y's, [known_x's], [const], [stats]) Situation:...
Read More

HYPGEOMDIST

  • May 31, 2023
Definition: HYPGEOMDIST is a function that returns the hypergeometric distribution for a specified set of parameters. Syntax: =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop, [cumulative]) Situation: This formula is suitable when...
Read More

INTERCEPT

  • May 31, 2023
Definition: INTERCEPT is a function that returns the y-intercept of a linear regression line. Syntax: =INTERCEPT(known_y's, known_x's) Situation: This formula is suitable when you need to find the...
Read More

FISHER

  • May 31, 2023
Definition: FISHER is a function that returns the Fisher transformation of a specified value. Syntax: =FISHER(x) Situation: This formula is suitable when you need to find the Fisher...
Read More

FISHERINV

  • May 31, 2023
Definition: FISHERINV is a function that returns the inverse of the Fisher transformation of a specified value. Syntax: =FISHERINV(y) Situation: This formula is suitable when you need to...
Read More

FORECAST

  • May 31, 2023
Definition: FORECAST is a function that predicts a future value using linear regression. Syntax: =FORECAST(x, known_y's, known_x's) Situation: This formula is suitable when you need to predict a...
Read More

FREQUENCY

  • May 31, 2023
Definition: FREQUENCY is a function that returns a frequency distribution for a set of values. Syntax: =FREQUENCY(data_array, bins_array) Situation: This formula is suitable when you need to find...
Read More

FTEST

  • May 31, 2023
Definition: FTEST is a function that returns the result of an F-test, which compares the variances of two sets of data. Syntax: =FTEST(array1, array2) Situation: This formula is...
Read More

GAMMADIST

  • May 31, 2023
Definition: GAMMADIST is a function that returns the gamma distribution for a specified set of parameters. Syntax: =GAMMADIST(x, alpha, beta, [cumulative]) Situation: This formula is suitable when you...
Read More