- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
DAX Statistical - BETA.INV function
Description
Returns the inverse of the beta cumulative probability density function (BETA.DIST).
If BETA.DIST (x ...) = probability, then BETA.INV (probability ...) = x.
DAX BETA.INV function is new in Excel 2016.
Syntax
BETA.INV (probability, alpha, beta, [A, [B]])
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
probability A probability associated with the beta distribution. |
| 2 |
alpha A parameter of the distribution. |
| 3 |
beta A parameter of the distribution. |
| 4 |
A Optional. A lower bound to the interval of x. |
| 5 |
B Optional. An upper bound to the interval of x. |
Return Value
Returns the inverse of the beta cumulative probability density function (BETA.DIST).
A real number, x, where A <= x <= B.
Remarks
If any argument is nonnumeric, BETA.INV returns the #VALUE! error value.
If alpha ≤ 0 or beta ≤ 0, BETA.INV returns the #NUM! error value.
If probability ≤ 0 or probability > 1, BETA.INV returns the #NUM! error value.
If you omit values for A and B, BETA.INV uses the standard cumulative beta distribution, so that A = 0 and B = 1.
Example
= BETA.INV (0.59,9,10,0,1) returns 0.5.