What is the Python equivalent of Excel's Beta distribution?

Question

What is the Python equivalent of the Beta distribution in Excel? In Excel, the formula is:

=BETA.DIST(A2,A3,A4,FALSE,A5,A6).

This gives the Beta probability density function for the given parameters, and we get the result as some decimal value.

But the Python SciPy reference does not give the function parameters and its definition in a similar form as Excel.

I am not getting how to do this in SciPy and pass the parameter correctly.

Answer 1

as you can see here, the probability density function of the beta distribution in scipy has exactly the same three parameters as excel (excel docs).

ALPHA is equivalent to a and represents a parameter of the distribution.

BETA is equivalent to b and represents a parameter of the distribution.

X is equivalent to x and value at which the distribution should be evaluated.

Weather or not the Cumulativ parameter in excel is True is represented by calling different functions in scipy. If you want the cumulative distribution (Cumulativ = True) you just call myBeta.cdf(<myParams>), if you want the probability density function (Cumulativ = False) you call myBeta.pdf(<myParams>). That means:

BETA.DIST(X,Alpha,Beta,TRUE) <=>
scipy.stats.beta.cdf(x,a,b)

and

BETA.DIST(X,Alpha,Beta,FALSE) <=>
scipy.stats.beta.pdf(x,a,b)