Beta Probability Density Calculations with Microsoft Excel

Microsoft Excel stores two utile statistical mathematical functions for making beta chance calculations, BETADIST and BETAINV. Perhaps surprisingly, neither mathematical mathematical mathematical mathematical mathematical mathematical mathematical mathematical mathematical mathematical mathematical function is hard to utilize as long as understand the input signals that supply information to the function.

Understanding the beta chance denseness function, BETADIST

The BETADIST function tax tax tax returns the accumulative beta chance denseness function.

Statisticians often utilize the accumulative beta chance denseness function to analyze fluctuation across samples, such as as when comparing two groupings of people performing the same undertaking to see whether they have got the same success rate.

The BETADIST function utilizes the followers syntax:

=BETADIST (x, alpha, beta, A, B)

where ten is a value between two optional boundary A and B, and alpha and beta are the two
positive parameters.

An Example of the BETADIST Function

For example, if ten bes 2, alpha bes 85, beta bes 90, A bes 1, and Type Type Type B bes 3, you would come in the function as follows:

=BETADIST (2, 85, 90, 1, 3)

The expression returns the value 0.647616.

Note that the uniform chance statistical statistical distribution is a particular lawsuit of the beta chance distribution where alpha=beta=1.

Using the reciprocal beta chance denseness function, BETAINV

The BETAINV function returns the reciprocal of the accumulative beta chance denseness function. That is, you utilize the BETADIST mathematical mathematical mathematical mathematical function if you cognize ten and desire to happen the probability, and you utilize the BETAINV function if you cognize the chance and desire to happen x.

The BETAINV function utilizes the followers syntax:

=BETAINV (probability, alpha, beta, A, B)
where chance is a value between two optional boundary A and B, and alpha and beta are the two positive parameters.

An Example of the BETAINV Function

For example, if the chance bes 0.647616., alpha bes 85, beta bes 90, A bes 1, and Type Type Type B bes 3, you would come in the function as follows:

The expression tax returns the value 2.