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

Month: May 2023

GAMMALN.PRECISE

  • May 31, 2023
Definition: GAMMALN.PRECISE is a function that returns the natural logarithm of the gamma function, using a more precise calculation method. Syntax: =GAMMALN.PRECISE(x) Situation: This formula is suitable when...
Read More

GAMMALN

  • May 31, 2023
Definition: GAMMALN is a function that returns the natural logarithm of the gamma function. Syntax: =GAMMALN(x) Situation: This formula is suitable when you need to find the natural...
Read More

GAMMAINV

  • May 31, 2023
Definition: GAMMAINV is a function that returns the inverse of the gamma cumulative distribution for a specified set of parameters. Syntax: =GAMMAINV(probability, alpha, beta) 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

FVSCHEDULE

  • May 31, 2023
Definition: FVSCHEDULE is a function that returns the future value of an initial principal after applying a series of compound interest rates. Syntax: =FVSCHEDULE(principal, schedule) Situation: This formula...
Read More

FV

  • May 31, 2023
Definition: FV is a function that returns the future value of an investment. Syntax: =FV(rate, nper, pmt, [pv], [type]) Situation: This formula is suitable when you need to...
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

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

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

FLOOR

  • May 31, 2023
Definition: FLOOR is a function that rounds a number down to the nearest specified multiple. Syntax: =FLOOR(number, significance) Situation: This formula is suitable when you need to round...
Read More