
Hi everyone,
I'd appreciate if someone can help me with emulating the MS Excel BINOMDIST Function in Math.NET. MS Excel funcition Syntax is:
BINOMDIST(number_s,trials,probability_s,cumulative)
Number_s is the number of successes in trials.
Trials is the number of independent trials.
Probability_s is the probability of success on each trial.
Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, then BINOMDIST returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE,
it returns the probability mass function, which is the probability that there are number_s successes.
And it seems that I have one 2 of those 4 parameters available in Math.NET:
NumberOfTrials Gets or sets the number of trials parameter.
ProbabilityOfSuccess Gets or sets the success probability parameter.
Does anyone know hoy to map these 2 functions?
Thanks!
José María


Coordinator
Aug 9, 2009 at 4:12 PM

Hi Jose,
First, note that we still have to port the binomial distribution from Math.NET Iridium to Math.NET Numerics. That being said, using Math.Net Iridium, the parameters that specify the number of trials and the success probabilities can be specified in the constructor.
Then, one can call the ProbabilityMass function with the third parameter to get the value when BINOMDIST has the 4th param set to FALSE and one can call the CumulativeDistribution function to map to the BINOMDIST with the 4th param set to TRUE.
Hope that helps.
Cheers, Jurgen


Coordinator
Aug 11, 2009 at 9:06 AM

Btw, the Math.NET Iridium UnitTests come with examples on how to emulate the similar Excel functions TDIST, GAMMADIST and GAMMAINV, so you may want to have a look at them
there.
Thanks,
Chris



Jurgen, Chris,
Thank you so much for the quick and clear answer, it worked perfectly!
Cheers,
José María

