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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Andy1973" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

[Andy1973]

Many thanks!

[Max]

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Andy1973" <[email protected]> wrote in message
news:[email protected]...
> Many thanks!
>
>

[Harlan Grove]

"Andy1973" <[email protected]> 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.