MULTINOMIAL function

[Andy1973]

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.

 

[Max]

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

 

[Andy1973]

Many thanks!

 

[Max]

You're welcome !

 

[Harlan Grove]

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.