MULTINOMIAL function

A

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.
 
H

Harlan Grove

Andy1973 said:
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.
Click to expand...

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.
 
Top