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

disappear.

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.