Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

similar to the binomial distribution, except that the number of successes is ﬁ xed,

and the number of trials is variable. Like the binomial, trials are assumed to be

independent.

NETWORKDAYS(start_date,end_date,holidays) [Category: Date & Time]*

Returns the number of whole working days between start_date and end_date.

Working days exclude weekends and any dates identiﬁ ed in holidays. Use

NETWORKDAYS to calculate employee beneﬁ ts that accrue based on the

number of days worked during a speciﬁ c term. Guru Tip: This function assumes

that you work Monday through Friday. For other work weeks, see page 4. You

can optionally specify a range of company holidays as the third argument in the

function. See page 4

NOMINAL(effect_rate,npery) [Category: Financial]*

Returns the nominal annual interest rate, given the effective rate and the number

of compounding periods per year.

NORMDIST(x,mean,standard_dev,cumulative) [Category: Statistical]]

Returns the normal cumulative distribution for the speciﬁ ed mean and standard

deviation. This function has a very wide range of applications in statistics,

including hypothesis testing.

NORMINV(probability,mean,standard_dev) [Category: Statistical]]

Returns the inverse of the normal cumulative distribution for the speciﬁ ed mean

and standard deviation.

NORMSDIST(z) [Category: Statistical]]

Returns the standard normal cumulative distribution function. The distribution

has a mean of 0 (zero) and a standard deviation of one. Use this function in

place of a table of standard normal curve areas.

NORMSINV(probability) [Category: Statistical]]

Returns the inverse of the standard normal cumulative distribution. The

distribution has a mean of zero and a standard deviation of one.