Latest posts by techwriter (see all)
- How to Count the Number of Days with an Incident and Chart with Running Averages in MS Excel - October 19, 2016
- FREE Online Video Course – MS Word Power Shortcuts - October 14, 2016
- INFOGRAPHICS – Which Business Entity is Right for You? - September 28, 2016
By Stephen Nelson
Microsoft Excel supplies two useful statistical functions for making beta probability calculations, BETADIST and BETAINV. Perhaps surprisingly, neither function is difficult to use as long as understand the inputs that supply data to the function.
Understanding the beta probability density function, BETADIST
The BETADIST function returns the cumulative beta probability density function.
Statisticians often use the cumulative beta probability density function to study variation across samples, such as when comparing two groups of people performing the same task to see whether they have the same success rate.
The BETADIST function uses the following syntax:
=BETADIST (x, alpha, beta, A, B)
where x is a value between two optional bounds A and B, and alpha and beta are the two
An Example of the BETADIST Function
For example, if x equals 2, alpha equals 85, beta equals 90, A equals 1, and B equals 3, you would enter the function as follows:
=BETADIST (2, 85, 90, 1, 3)
The formula returns the value 0.647616.
Note that the uniform probability distribution is a special case of the beta probability distribution where alpha=beta=1.
Using the inverse beta probability density function, BETAINV
The BETAINV function returns the inverse of the cumulative beta probability density function. That is, you use the BETADIST function if you know x and want to find the probability, and you use the BETAINV function if you know the probability and want to find x.
The BETAINV function uses the following syntax:
=BETAINV (probability, alpha, beta, A, B)
where probability is a value between two optional bounds A and B, and alpha and beta are the two positive parameters.
An Example of the BETAINV Function
For example, if the probability equals 0.647616., alpha equals 85, beta equals 90, A equals 1, and B equals 3, you would enter the function as follows:
The formula returns the value 2.
About the author: Seattle CPA Stephen L. Nelson wrote the bestselling book, MBA’s Guide to Microsoft Excel, from which this short article is adapted. Nelson also writes and edits the S Corporations Explained and LLCs Explained websites.
Want to read more about MS Excel tips and tutorials? Visit Hot Excel.