<div class="raw-html-embed"> The BETA.DIST function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to return the beta distribution.

 <h5 class="pt8">Syntax</h5>
 BETA.DIST(x, alpha, beta, cumulative, [A], [B])
 The BETA.DIST function has the following arguments:
 <table style="width: 40%">
 <tbody>
 <tr>
 <th style="background-color: #f4f4f4" width="150ch">Argument</th>
 <th style="background-color: #f4f4f4">Description</th>
 </tr>
 <tr>
 <td>x</td>
 <td>The value between A and B at which the function should be calculated.</td>
 </tr>
 <tr>
 <td>alpha</td>
 <td>The first parameter of the distribution, a numeric value greater than 0.</td>
 </tr>
 <tr>
 <td>beta</td>
 <td>The second parameter of the distribution, a numeric value greater than 0.</td>
 </tr>
 <tr>
 <td>cumulative</td>
 <td>A logical value (TRUE or FALSE) that determines the function form. If it is TRUE, the function returns the cumulative distribution function. If it is FALSE, the function returns the probability density function.</td>
 </tr>
 <tr>
 <td>A</td>
 <td>The lower bound to the interval of x. It is an optional parameter. If it is omitted, the default value of 0 is used.</td>
 </tr>
 <tr>
 <td>B</td>
 <td>The upper bound to the interval of x. It is an optional parameter. If it is omitted, the default value of 1 is used.</td>
 </tr>
 </tbody>
 </table>

 <h5 class="pt8">Notes</h5>
 <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the BETA.DIST function.

 <h5 class="pt8">Examples</h5>
 The figure below displays the result returned by the BETA.DIST function.
 <img alt="BETA.DIST Function" src="https://static-helpcenter.teamlab.info/beta_dist_fb2e0e021e.png"></div>

BETA.DIST Function

Docs

Argument	Description
x	The value between A and B at which the function should be calculated.
*alpha*	The first parameter of the distribution, a numeric value greater than 0.
*beta*	The second parameter of the distribution, a numeric value greater than 0.
*cumulative*	A logical value (TRUE or FALSE) that determines the function form. If it is TRUE, the function returns the cumulative distribution function. If it is FALSE, the function returns the probability density function.
A	The lower bound to the interval of x. It is an optional parameter. If it is omitted, the default value of 0 is used.
B	The upper bound to the interval of x. It is an optional parameter. If it is omitted, the default value of 1 is used.

BETA.DIST Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud