Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
FTEST(array1,array2) [Category: Statistical]]
Returns the result of an F-test. An F-test returns the one-tailed probability that
the variances in array1 and array2 are not signiﬁ cantly different. Use this function
to determine whether two samples have different variances. For example, given
test scores from public and private schools, you can test whether these schools
have different levels of diversity.
FV(rate,nper,pmt,pv,type) [Category: Financial]
Returns the future value of an investment based on periodic, constant payments
and a constant interest rate.
FVSCHEDULE(principal,schedule) [Category: Financial]*
Returns the future value of an initial principal after applying a series of compound
interest rates. Use FVSCHEDULE to calculate future value of an investment
with a variable or adjustable rate.
GAMMADIST(x,alpha,beta,cumulative) [Category: Statistical]]
Returns the gamma distribution. You can use this function to study variables
that may have a skewed distribution. The gamma distribution is commonly used
in queuing analysis.
GAMMAINV(probability,alpha,beta) [Category: Statistical]]
Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...),
then GAMMAINV(p,...) = x.
GAMMALN(x) [Category: Statistical]]
Returns the natural logarithm of the gamma function, Γ(x).
GCD(number1,number2, ...) [Category: Math]*
Returns the greatest common divisor of two or more integers. The greatest
common divisor is the largest integer that divides both number1 and number2
without a remainder. Guru Tip: With all due respect to Nick Irwin, my 7th grade
math teacher, Excel just made the need for one month of your math class
GEOMEAN(number1,number2, ...) [Category: Statistical]]
Returns the geometric mean of an array or range of positive data. For example,
you can use GEOMEAN to calculate average growth rate given compound
interest with variable rates.
GESTEP(number,step) [Category: Engineering]*
Returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to
ﬁ lter a set of values. For example, by summing several GESTEP functions, you
calculate the count of values that exceed a threshold.