Files
web-apps/apps/spreadsheeteditor/main/resources/help/en/Functions/binom-dist-range.htm
Maxim Kadushkin 035166509d Merge pull request #2755 from ONLYOFFICE/feature/update-lunr-without-kor
Feature/update lunr without kor
2023-12-21 16:25:39 +03:00

53 lines
2.9 KiB
HTML

<!DOCTYPE html>
<html>
<head>
<title>BINOM.DIST.RANGE Function</title>
<meta charset="utf-8" />
<meta name="description" content="" />
<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
<script type="text/javascript" src="../callback.js"></script>
<script type="text/javascript" src="../../../../../../common/main/resources/help/search/js/page-search.js"></script>
</head>
<body>
<div class="mainpart">
<div class="search-field">
<input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
</div>
<h1>BINOM.DIST.RANGE Function</h1>
<p>The <b>BINOM.DIST.RANGE</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to return the probability of a trial result using a binomial distribution.</p>
<h3>Syntax</h3>
<p><b><em>BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])</em></b></p>
<p>The <b>BINOM.DIST.RANGE</b> function has the following arguments:</p>
<table style="width: 40%">
<tr>
<th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
<th style="background-color: #f4f4f4"><b>Description</b></th>
</tr>
<tr>
<td><b><em>trials</em></b></td>
<td>The number of trials, a numeric value greater than or equal to <b><em>number_s</em></b>.</td>
</tr>
<tr>
<td><b><em>probability</em></b></td>
<td>The success probability of each trial, a numeric value greater than or equal to 0 but less than or equal to 1.</td>
</tr>
<tr>
<td><b><em>number_s</em></b></td>
<td>The minimum number of successes in the trials you want to calculate probability for, a numeric value greater than or equal to 0.</td>
</tr>
<tr>
<td><b><em>number_s2</em></b></td>
<td>An optional argument. The maximum number of successes in the trials you want to calculate probability for, a numeric value greater than <b><em>number_s</em></b> and less than or equal to <b><em>trials</em></b>.</td>
</tr>
</table>
<h3>Notes</h3>
<p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>BINOM.DIST.RANGE</b> function.</p>
<h3>Examples</h3>
<p>The figure below displays the result returned by the <b>BINOM.DIST.RANGE</b> function.</p>
<p><img alt="BINOM.DIST.RANGE Function" src="../images/binom-dist-range.png" /></p>
</div>
</body>
</html>