mirror of
https://github.com/ONLYOFFICE/web-apps.git
synced 2026-07-24 21:58:09 +08:00
41 lines
2.2 KiB
HTML
41 lines
2.2 KiB
HTML
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<title>VAR.P 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>VAR.P Function</h1>
|
|
<p>The <b>VAR.P</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to calculate variance based on the entire population (ignores logical values and text in the population).</p>
|
|
<h3>Syntax</h3>
|
|
<p><b><em>VAR.P(number1, [number2], ...)</em></b></p>
|
|
<p>The <b>VAR.P</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>number1/2/n</em></b></td>
|
|
<td>Up to 255 numeric values for which you want to calculate the variance.</td>
|
|
</tr>
|
|
</table>
|
|
<h3>Notes</h3>
|
|
<p>Empty cells, logical values, text, or error values supplied as part of an array are ignored. If they are supplied directly to the function, text representations of numbers and logical values are interpreted as numbers.</p>
|
|
<p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>VAR.P</b> function.</p>
|
|
|
|
<h3>Examples</h3>
|
|
<p>The figure below displays the result returned by the <b>VAR.P</b> function.</p>
|
|
<p><img alt="VAR.P Function" src="../images/var-p.png" /></p>
|
|
</div>
|
|
</body>
|
|
</html> |