Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
of something across samples, such as the fraction of the day people spend
watching television.
BETAINV(probability,alpha,beta,A,B) [Category: Statistical]]
Returns the inverse of the cumulative beta probability density function. That is, if
probability = BETADIST(x,...), then BETAINV(probability,...) = x. The cumulative
beta distribution can be used in project planning to model probable completion
times given an expected completion time and variability.
BIN2DEC(number) [Category: Engineering]*
Converts a binary number to decimal. Guru Tip: Frustratingly, this function only
works with numbers up through 511. Otherwise, using BIN2DEC and DEC2BIN
might be a great way to code and decode ﬁ nancial statements with bad ﬁ nancial
news. See ROMAN.
BIN2HEX(number,places) [Category: Engineering]*
Converts a binary number to hexadecimal.
BIN2OCT(number,places) [Category: Engineering]*
Converts a binary number to octal. Guru Tip: If you are of the age where you
TwelveToes on Saturday mornings, then imagine a planet where everyone only
has eight ﬁ ngers and you’ve got the concept behind this numbering system.
Both Octal and Hexadecimal were popular in the early days of computing.
BINOMDIST(number_s,trials,probability_s,cumulative) [Category:
Statistical]]
Returns the individual term binomial distribution probability. Use BINOMDIST in
problems with a ﬁ xed number of tests or trials, when the outcomes of any trial are
only success or failure, when trials are independent, and when the probability of
success is constant throughout the experiment. For example, BINOMDIST can
calculate the probability that two of the next three babies born are male.
CALL(register_id,argument1,...)
Calls a procedure in a dynamic link library or code resource. Use this syntax
only with a previously registered code resource, which uses arguments from the
REGISTER function.
CALL(ﬁ le_text,resource,type_text,argument1,...)
Calls a procedure in a dynamic link library or code resource. Use this syntax to
simultaneously register and call a code resource for the Macintosh.
CALL(module_text,procedure,type_text,argument1,...)
Calls a procedure in a dynamic link library or code resource. Use this syntax to
simultaneously register and call a code resource for Windows machines.

Search JabSto ::

Custom Search