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 fi 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 identifi ed in holidays. Use
NETWORKDAYS to calculate employee benefi ts that accrue based on the
number of days worked during a specifi 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 specifi 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 specifi 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.
 
Search JabSto ::




Custom Search