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

learned about alternate numbering systems from Tom Yohe’s singing about Little

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.