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
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.