MULTINOMIAL function
 

Can anyone tell me how to go about getting the multinomial function (Office
2000 Pro)? Help tells me to run the Setup program but I can't see how to do
this.

Check the "Analysis Toolpak" (ATP) box
via Tools Add-Ins

Chip Pearson's page has details on the ATP at:
http://www.cpearson.com/excel/ATP.htm

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Andy1973" wrote in message
...
Can anyone tell me how to go about getting the multinomial function
(Office
2000 Pro)? Help tells me to run the Setup program but I can't see how to
do
this.

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Andy1973" wrote in message
...
Many thanks!

"Andy1973" wrote...
Can anyone tell me how to go about getting the multinomial function
(Office 2000 Pro)? Help tells me to run the Setup program but I
can't see how to do this.

It may seem convenient to use the MULTINOMIAL function in the ATP, but it
chokes on moderately large values. For instance, MULTINOMIAL(50,50,50,50)
returns #NUM!. An alternative that uses only built-in functions and accepts
a much broader set of numbers as arguments is

=EXP(GAMMALN(SUM(RangeOrArray)+1)-SUMPRODUCT(GAMMALN(RangeOrArray+1)))

E.g.,

=EXP(GAMMALN(SUM({50,50,50,50})+1)-SUMPRODUCT(GAMMALN({50,50,50,50}+1)))

returns 9.217E+116.