Edit

Share via

beta_cdf()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns the standard cumulative beta distribution function.

If probability = beta_cdf(x,...), then beta_inv(probability,...) = x.

The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.

Syntax

beta_cdf(x, alpha, beta)

Learn more about syntax conventions.

Parameters

Name Type Required Description
x int, long, or real ✔️ A value at which to evaluate the function.
alpha int, long, or real ✔️ A parameter of the distribution.
beta int, long, or real ✔️ A parameter of the distribution.

Returns

The cumulative beta distribution function.

Note

  • If any argument is nonnumeric, the function returns null.
  • If x < 0 or x > 1, the function returns NaN.
  • If alpha ≤ 0 or alpha > 10000, the function returns NaN.
  • If beta ≤ 0 or beta > 10000, the function returns NaN.

Examples

Run the query

datatable(x:double, alpha:double, beta:double, comment:string)
[
    0.9, 10.0, 20.0, "Valid input",
    1.5, 10.0, 20.0, "x > 1, yields NaN",
    double(-10), 10.0, 20.0, "x < 0, yields NaN",
    0.1, double(-1.0), 20.0, "alpha is < 0, yields NaN"
]
| extend b = beta_cdf(x, alpha, beta)

Output

x alpha beta comment b
0.9 10 20 Valid input 0.999999999999959
1.5 10 20 x > 1, yields NaN NaN
-10 10 20 x < 0, yields NaN NaN
0.1 -1 20 alpha is < 0, yields NaN NaN

Related content

  • For computing the inverse of the beta cumulative probability density function, see beta-inv().
  • For computing probability density function, see beta-pdf().