#### Latest posts by techwriter (see all)

- 3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents - September 19, 2016
- How to Delete All Hyperlinks in a MS #Word Document through VBA Macro - September 1, 2016
- How to View a List of All Open MS Word Documents through VBA Macro - August 31, 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

positive parameters.

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

BETADIST return the cumulative distribution not the density function.