1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2a2950092Smseidel 302dbb15cSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 502dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 602dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 702dbb15cSAndrew Rist * distributed with this work for additional information 802dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 902dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 1002dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 1102dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 1502dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 1602dbb15cSAndrew Rist * software distributed under the License is distributed on an 1702dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1802dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 1902dbb15cSAndrew Rist * specific language governing permissions and limitations 2002dbb15cSAndrew Rist * under the License. 21cdf0e10cSrcweir * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 24f773ab65Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0104060184xml" indexer="include"> 27cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Statistical Functions Part Four</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/04060184.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3153415" role="heading" level="1" l10n="U"><variable id="mq"><link href="text/scalc/01/04060184.xhp" name="Statistical Functions Part Four">Statistical Functions Part Four</link> 33cdf0e10cSrcweir</variable></paragraph> 34cdf0e10cSrcweir<sort order="asc"> 35cdf0e10cSrcweir<section id="max"> 3688cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154511"> 3788cae784Smseidel<bookmark_value>MAX function</bookmark_value> 38cdf0e10cSrcweir</bookmark> 39cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAX" id="bm_id3146972" localize="false"/> 40a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3154511" role="heading" level="2" l10n="U">MAX</paragraph> 41a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3153709" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph> 42cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id9282509" role="paragraph" l10n="NEW">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph> 43a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3154256" role="heading" level="3" l10n="U">Syntax</paragraph> 44a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3147340" role="code" l10n="U">MAX(Number1; Number2; ...Number30)</paragraph> 45a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph" l10n="CHG"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph> 46a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="3" l10n="U">Example</paragraph> 47a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3147343" role="paragraph" l10n="U"><item type="input">=MAX(A1;A2;A3;50;100;200)</item> returns the largest value from the list.</paragraph> 48a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3148485" role="paragraph" l10n="U"><item type="input">=MAX(A1:B100)</item> returns the largest value from the list.</paragraph> 49cdf0e10cSrcweir</section> 50cdf0e10cSrcweir<section id="maxa"> 5188cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3166426"> 5288cae784Smseidel<bookmark_value>MAXA function</bookmark_value> 53cdf0e10cSrcweir</bookmark> 54cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAXA" id="bm_id3150304" localize="false"/> 55a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3166426" role="heading" level="2" l10n="U">MAXA</paragraph> 56a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3150363" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MAXA">Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.</ahelp></paragraph> 57cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id7689443" role="paragraph" l10n="NEW">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph> 58a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3150516" role="heading" level="3" l10n="U">Syntax</paragraph> 59a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3166431" role="code" l10n="U">MAXA(Value1; Value2; ... Value30)</paragraph> 60a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3150202" role="paragraph" l10n="CHG"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph> 61a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3156290" role="heading" level="3" l10n="U">Example</paragraph> 62a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3156446" role="paragraph" l10n="CHG"><item type="input">=MAXA(A1;A2;A3;50;100;200;"Text")</item> returns the largest value from the list.</paragraph> 63a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3149404" role="paragraph" l10n="U"><item type="input">=MAXA(A1:B100)</item> returns the largest value from the list.</paragraph> 64cdf0e10cSrcweir</section> 65cdf0e10cSrcweir<section id="median"> 6688cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153820"> 6788cae784Smseidel<bookmark_value>MEDIAN function</bookmark_value> 68cdf0e10cSrcweir</bookmark> 69cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MEDIAN" id="bm_id3153069" localize="false"/> 70a2be20c6Smseidel<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2" l10n="U">MEDIAN</paragraph> 71a2be20c6Smseidel<paragraph xml-lang="en-US" id="par_id3151241" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MEDIAN">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp></paragraph> 72*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3148871" role="heading" level="3" l10n="U">Syntax</paragraph> 73*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3155264" role="code" l10n="U">MEDIAN(Number1; Number2; ...Number30)</paragraph> 74*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150109" role="paragraph" l10n="CHG"><emph>Number1; Number2;...Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference.</paragraph> 75*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3144506" role="heading" level="3" l10n="U">Example</paragraph> 76*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3145078" role="paragraph" l10n="U">for an odd number: <item type="input">=MEDIAN(1;5;9;20;21)</item> returns 9 as the median value.</paragraph> 77*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149126" role="paragraph" l10n="U">for an even number: <item type="input">=MEDIAN(1;5;9;20)</item> returns the average of the two middle values 5 and 9, thus 7.</paragraph> 78cdf0e10cSrcweir</section> 79cdf0e10cSrcweir<section id="min"> 8088cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154541"> 8188cae784Smseidel<bookmark_value>MIN function</bookmark_value> 82cdf0e10cSrcweir</bookmark> 83cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIN" id="bm_id3159226" localize="false"/> 84*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3154541" role="heading" level="2" l10n="U">MIN</paragraph> 85*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3143222" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph> 86cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id2301400" role="paragraph" l10n="NEW">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph> 87*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3154651" role="heading" level="3" l10n="U">Syntax</paragraph> 88*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3146964" role="code" l10n="U">MIN(Number1; Number2; ...Number30)</paragraph> 89*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153486" role="paragraph" l10n="CHG"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph> 90*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3155523" role="heading" level="3" l10n="U">Example</paragraph> 91*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154734" role="paragraph" l10n="U"><item type="input">=MIN(A1:B100)</item> returns the smallest value in the list.</paragraph> 92cdf0e10cSrcweir</section> 93cdf0e10cSrcweir<section id="mina"> 9488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3147504"> 9588cae784Smseidel<bookmark_value>MINA function</bookmark_value> 96cdf0e10cSrcweir</bookmark> 97cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINA" id="bm_id3155752" localize="false"/> 98*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3147504" role="heading" level="2" l10n="U">MINA</paragraph> 99*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3147249" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MINA">Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.</ahelp></paragraph> 100cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id4294564" role="paragraph" l10n="NEW">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph> 101*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3150435" role="heading" level="3" l10n="U">Syntax</paragraph> 102*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153336" role="code" l10n="U">MINA(Value1; Value2; ... Value30)</paragraph> 103*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3146098" role="paragraph" l10n="CHG"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph> 104*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3148743" role="heading" level="3" l10n="U">Example</paragraph> 105*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3147401" role="paragraph" l10n="CHG"><item type="input">=MINA(1;"Text";20)</item> returns 0.</paragraph> 106*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3147295" role="paragraph" l10n="U"><item type="input">=MINA(A1:B100)</item> returns the smallest value in the list.</paragraph> 107cdf0e10cSrcweir</section> 108cdf0e10cSrcweir<section id="avedev"> 10988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3166465"> 11088cae784Smseidel<bookmark_value>AVEDEV function</bookmark_value> 111cdf0e10cSrcweir<bookmark_value>averages;statistical functions</bookmark_value> 112cdf0e10cSrcweir</bookmark><comment>mw added "averages;"</comment> 113cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/> 114*b36d6b5dSmseidel<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2" l10n="U">AVEDEV</paragraph> 115*b36d6b5dSmseidel<paragraph role="paragraph" id="par_id3150373" xml-lang="en-US" l10n="U"><ahelp hid="HID_FUNC_MITTELABW">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set.</paragraph> 116*b36d6b5dSmseidel<paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3" l10n="U">Syntax</paragraph> 117*b36d6b5dSmseidel<paragraph role="code" id="par_id3145636" xml-lang="en-US" l10n="U">AVEDEV(Number1; Number2; ...Number30)</paragraph> 118*b36d6b5dSmseidel<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US" l10n="U"><emph>Number1, Number2,...Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph> 119*b36d6b5dSmseidel<paragraph role="heading" id="hd_id3149725" xml-lang="en-US" level="3" l10n="U">Example</paragraph> 120*b36d6b5dSmseidel<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US" l10n="U"><item type="input">=AVEDEV(A1:A50)</item> 121cdf0e10cSrcweir</paragraph> 122cdf0e10cSrcweir</section> 123cdf0e10cSrcweir<section id="average"> 12488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3145824"> 12588cae784Smseidel<bookmark_value>AVERAGE function</bookmark_value> 126cdf0e10cSrcweir</bookmark> 127cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/> 128*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2" l10n="U">AVERAGE</paragraph> 129*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph> 130*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3146943" role="heading" level="3" l10n="U">Syntax</paragraph> 131*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154679" role="code" l10n="U">AVERAGE(Number1; Number2; ...Number30)</paragraph> 132*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150741" role="paragraph" l10n="CHG"><emph>Number1; Number2;...Number 0</emph> are numerical values or ranges.</paragraph> 133*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153039" role="heading" level="3" l10n="U">Example</paragraph> 134*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3151232" role="paragraph" l10n="U"><item type="input">=AVERAGE(A1:A50)</item> 135cdf0e10cSrcweir</paragraph> 136cdf0e10cSrcweir</section> 137cdf0e10cSrcweir<section id="averagea"> 13888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148754"> 13988cae784Smseidel<bookmark_value>AVERAGEA function</bookmark_value> 140cdf0e10cSrcweir</bookmark> 141cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTA" id="bm_id3149690" localize="false"/> 142*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2" l10n="U">AVERAGEA</paragraph> 143*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3145138" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph> 144*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3" l10n="U">Syntax</paragraph> 145*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149734" role="code" l10n="U">AVERAGEA(Value1; Value2; ... Value30)</paragraph> 146*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph" l10n="CHG"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph> 147*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3149504" role="heading" level="3" l10n="U">Example</paragraph> 148*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150864" role="paragraph" l10n="U"><item type="input">=AVERAGEA(A1:A50)</item> 149cdf0e10cSrcweir</paragraph> 150cdf0e10cSrcweir</section> 151514ce53bSKay Schenk<section id="averageif"> 15288cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K1"> 15388cae784Smseidel<bookmark_value>AVERAGEIF function</bookmark_value> 154514ce53bSKay Schenk</bookmark> 155514ce53bSKay Schenk<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTB" id="bm_id3149690K1" localize="false"/> 156*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3148754K1" role="heading" level="2" l10n="U">AVERAGEIF</paragraph><comment>kschenk added this entry </comment> 157514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3145138K1" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MITTELWERTB">Average the values of cells in a range that meet a criteria.</ahelp></paragraph> 158*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153326K1" role="heading" level="3" l10n="U">Syntax</paragraph> 159514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3149734K1" role="code" l10n="U">AVERAGEIF( Reference R ; Criterion C [ ; Reference A ] )</paragraph> 160514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3155260K1" role="paragraph" l10n="CHG"> If reference A is omitted, averages the values of cells in the reference range R that meet the Criterion C. If reference A is given, averages the values of cells of a range that is constructed using the top left cell of reference A and applying the dimensions, shape and size, of reference R. Does not accept constant values as reference parameters.</paragraph> 161514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3145139K1" role="paragraph" l10n="U">If no cell in range R matches the Criterion C, an Error is returned. If no Numbers are in the range to be averaged, an Error is returned.</paragraph> 162*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3149504K1" role="heading" level="3" l10n="U">Examples</paragraph> 163*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150864K1" role="paragraph" l10n="U"><item type="input">=AVERAGEIF(A1:A50;">"0)</item> will return the average of A1:A50 of all positive values in the range. 164514ce53bSKay Schenk</paragraph> 165514ce53bSKay Schenk</section> 166514ce53bSKay Schenk<section id="averageifs"> 16788cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K2"> 16888cae784Smseidel<bookmark_value>AVERAGEIFS function</bookmark_value> 169514ce53bSKay Schenk</bookmark> 170514ce53bSKay Schenk<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTC" id="bm_id3149690K2" localize="false"/> 171*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3148754K2" role="heading" level="2" l10n="U">AVERAGEIFS</paragraph><comment>kschenk added this entry </comment> 172514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3145138K2" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MITTELWERTC">Average the values of cells that meet multiple criteria in multiple ranges.</ahelp></paragraph> 173*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153326K2" role="heading" level="3" l10n="U">Syntax</paragraph> 174514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3149734K2" role="code" l10n="U">AVERAGEIFS( Reference A ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 175514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3155260K2" role="paragraph" l10n="CHG">Averages the values of cells in the reference range A that meet the Criterion C1 in the reference range R1 and the Criterion C2 in the reference range R2, and so on.</paragraph> 176514ce53bSKay Schenk<paragraph xml-lang="en-US" id="par_id3145139K2" role="paragraph" l10n="U">All reference ranges shall have the same dimension and size, else an Error is returned. A logical AND is applied between each array result of each selection; a cell of reference range A is evaluated only if the same position in each array is the result of a Criterion match. If no numbers are in the result set to be averaged, an Error is returned.</paragraph> 177*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3149504K2" role="heading" level="3" l10n="U">Example</paragraph> 178*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150864K2" role="paragraph" l10n="U"><item type="input">=AVERAGEIFS(A1:A50;B1:B25;">"0)</item> will return the average of A1:A50 if all cells in the range B1 to B25 are greater than 0. 179514ce53bSKay Schenk</paragraph> 180514ce53bSKay Schenk</section> 181cdf0e10cSrcweir<section id="mode"> 18288cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"> 18388cae784Smseidel<bookmark_value>MODE function</bookmark_value> 184cdf0e10cSrcweir<bookmark_value>most common value</bookmark_value> 185cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 186cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/> 187*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153933" role="heading" level="2" l10n="U">MODE</paragraph> 188*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153085" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MODALWERT">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph> 189*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153003" role="heading" level="3" l10n="U">Syntax</paragraph> 190*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3155950" role="code" l10n="U">MODE(Number1; Number2; ...Number30)</paragraph> 191*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150337" role="paragraph" l10n="CHG"><emph>Number1; Number2;...Number30</emph> are numerical values or ranges.</paragraph> 192*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153571" role="heading" level="3" l10n="U">Example</paragraph> 193*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153733" role="paragraph" l10n="U"><item type="input">=MODE(A1:A50)</item> 194cdf0e10cSrcweir</paragraph> 195cdf0e10cSrcweir</section> 196cdf0e10cSrcweir<section id="negbinomdist"> 19788cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149879"> 19888cae784Smseidel<bookmark_value>NEGBINOMDIST function</bookmark_value> 199cdf0e10cSrcweir<bookmark_value>negative binomial distribution</bookmark_value> 200cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 201cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMVERT" id="bm_id3159135" localize="false"/> 202*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3149879" role="heading" level="2" l10n="U">NEGBINOMDIST</paragraph> 203*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3155437" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_NEGBINOMVERT">Returns the negative binomial distribution.</ahelp></paragraph> 204*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3145351" role="heading" level="3" l10n="U">Syntax</paragraph> 205*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150935" role="code" l10n="U">NEGBINOMDIST(X; R; SP)</paragraph> 206*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153044" role="paragraph" l10n="U"><emph>X</emph> represents the value returned for unsuccessful tests.</paragraph> 207*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3151018" role="paragraph" l10n="U"><emph>R</emph> represents the value returned for successful tests.</paragraph> 208*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3148878" role="paragraph" l10n="U"><emph>SP</emph> is the probability of the success of an attempt.</paragraph> 209*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3149539" role="heading" level="3" l10n="U">Example</paragraph> 210*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3148770" role="paragraph" l10n="U"><item type="input">=NEGBINOMDIST(1;1;0.5)</item> returns 0.25.</paragraph> 211cdf0e10cSrcweir</section> 212cdf0e10cSrcweir<section id="norminv"> 21388cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155516"> 21488cae784Smseidel<bookmark_value>NORMINV function</bookmark_value> 215cdf0e10cSrcweir<bookmark_value>normal distribution;inverse of</bookmark_value> 216cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 217cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV" id="bm_id3149396" localize="false"/> 218*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3155516" role="heading" level="2" l10n="U">NORMINV</paragraph> 219*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154634" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_NORMINV">Returns the inverse of the normal cumulative distribution.</ahelp></paragraph> 220*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153227" role="heading" level="3" l10n="U">Syntax</paragraph> 221*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3147534" role="code" l10n="U">NORMINV(Number; Mean; StDev)</paragraph> 222*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154950" role="paragraph" l10n="U"><emph>Number</emph> represents the probability value used to determine the inverse normal distribution.</paragraph> 223*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150690" role="paragraph" l10n="U"><emph>Mean</emph> represents the mean value in the normal distribution.</paragraph> 224*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3148594" role="paragraph" l10n="U"><emph>StDev</emph> represents the standard deviation of the normal distribution.</paragraph> 225*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3155822" role="heading" level="3" l10n="U">Example</paragraph> 226*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153921" role="paragraph" l10n="CHG"><item type="input">=NORMINV(0.9;63;5)</item> returns 69.41. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41 grams.</paragraph> 227cdf0e10cSrcweir</section> 228cdf0e10cSrcweir<section id="normdist"> 22988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153722"> 23088cae784Smseidel<bookmark_value>NORMDIST function</bookmark_value> 231cdf0e10cSrcweir<bookmark_value>density function</bookmark_value> 232cdf0e10cSrcweir</bookmark><comment>mw added one entry</comment> 233cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMVERT" id="bm_id3147484" localize="false"/> 234*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153722" role="heading" level="2" l10n="U">NORMDIST</paragraph> 235*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150386" role="paragraph" l10n="CHG"><ahelp hid="HID_FUNC_NORMVERT">Returns the density function or the normal cumulative distribution.</ahelp></paragraph> 236*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3083282" role="heading" level="3" l10n="U">Syntax</paragraph> 237*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150613" role="code" l10n="U">NORMDIST(Number; Mean; StDev; C)</paragraph> 238*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149820" role="paragraph" l10n="U"><emph>Number</emph> is the value of the distribution based on which the normal distribution is to be calculated.</paragraph> 239*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3146063" role="paragraph" l10n="U"><emph>Mean</emph> is the mean value of the distribution.</paragraph> 240*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3156295" role="paragraph" l10n="U"><emph>StDev</emph> is the standard deviation of the distribution.</paragraph> 241*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3145080" role="paragraph" l10n="U"><emph>C</emph> is optional. <emph>C</emph> = 0 calculates the density function, <emph>C</emph> = 1 calculates the distribution.</paragraph> 242*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3152972" role="heading" level="3" l10n="U">Example</paragraph> 243*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149283" role="paragraph" l10n="CHG"><item type="input">=NORMDIST(70;63;5;0)</item> returns 0.03.</paragraph> 244*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149448" role="paragraph" l10n="CHG"><item type="input">=NORMDIST(70;63;5;1)</item> returns 0.92.</paragraph> 245cdf0e10cSrcweir</section> 246cdf0e10cSrcweir<section id="pearson"> 24788cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3152934"> 24888cae784Smseidel<bookmark_value>PEARSON function</bookmark_value> 249cdf0e10cSrcweir</bookmark> 250cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PEARSON" id="bm_id3156103" localize="false"/> 251*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3152934" role="heading" level="2" l10n="U">PEARSON</paragraph> 252*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153216" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_PEARSON">Returns the Pearson product moment correlation coefficient r.</ahelp></paragraph> 253*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3147081" role="heading" level="3" l10n="U">Syntax</paragraph> 254*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3156133" role="code" l10n="U">PEARSON(Data1; Data2)</paragraph> 255*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3151272" role="paragraph" l10n="U"><emph>Data1</emph> represents the array of the first data set.</paragraph> 256*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153279" role="paragraph" l10n="U"><emph>Data2</emph> represents the array of the second data set.</paragraph> 257*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3147567" role="heading" level="3" l10n="U">Example</paragraph> 258*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3151187" role="paragraph" l10n="U"><item type="input">=PEARSON(A1:A30;B1:B30)</item> returns the Pearson correlation coefficient of both data sets.</paragraph> 259cdf0e10cSrcweir</section> 260cdf0e10cSrcweir<section id="phi"> 26188cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3152806"> 26288cae784Smseidel<bookmark_value>PHI function</bookmark_value> 263cdf0e10cSrcweir</bookmark> 264cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PHI" id="bm_id3153757" localize="false"/> 265*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3152806" role="heading" level="2" l10n="U">PHI</paragraph> 266*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150254" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_PHI">Returns the values of the distribution function for a standard normal distribution.</ahelp></paragraph> 267*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3154748" role="heading" level="3" l10n="U">Syntax</paragraph> 268*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149976" role="code" l10n="U">PHI(Number)</paragraph> 269*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3156108" role="paragraph" l10n="U"><emph>Number</emph> represents the value based on which the standard normal distribution is calculated.</paragraph> 270*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153621" role="heading" level="3" l10n="U">Example</paragraph> 271*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3155849" role="paragraph" l10n="CHG"><item type="input">=PHI(2.25) </item>= 0.03</paragraph> 272*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3143236" role="paragraph" l10n="CHG"><item type="input">=PHI(-2.25)</item> = 0.03</paragraph> 273*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149286" role="paragraph" l10n="CHG"><item type="input">=PHI(0)</item> = 0.4</paragraph> 274cdf0e10cSrcweir</section> 275cdf0e10cSrcweir<section id="poisson"> 27688cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153985"> 27788cae784Smseidel<bookmark_value>POISSON function</bookmark_value> 278cdf0e10cSrcweir</bookmark> 279cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON" id="bm_id3156011" localize="false"/> 280*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153985" role="heading" level="2">POISSON</paragraph> 281*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154298" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_POISSON">Returns the Poisson distribution.</ahelp></paragraph> 282*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3159183" role="heading" level="3" l10n="U">Syntax</paragraph> 283*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3146093" role="code" l10n="U">POISSON(Number; Mean; C)</paragraph> 284*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3147253" role="paragraph" l10n="U"><emph>Number</emph> represents the value based on which the Poisson distribution is calculated.</paragraph> 285*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3151177" role="paragraph" l10n="U"><emph>Mean</emph> represents the middle value of the Poisson distribution.</paragraph> 286*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149200" role="paragraph" l10n="CHG"><emph>C</emph> (optional) = 0 or False calculates the density function; <emph>C</emph> = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME.</paragraph> 287*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3159347" role="heading" level="3" l10n="U">Example</paragraph> 288*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3150113" role="paragraph" l10n="U"><item type="input">=POISSON(60;50;1)</item> returns 0.93.</paragraph> 289cdf0e10cSrcweir</section> 290cdf0e10cSrcweir<section id="percentile"> 29188cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153100"> 29288cae784Smseidel<bookmark_value>PERCENTILE function</bookmark_value> 293cdf0e10cSrcweir</bookmark> 294cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUANTIL" id="bm_id3155394" localize="false"/> 295*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3153100" role="heading" level="2" l10n="U">PERCENTILE</paragraph> 296*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154940" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_QUANTIL">Returns the alpha-percentile of data values in an array.</ahelp> A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For <item type="literal">Alpha</item> = 25%, the percentile means the first quartile; <item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph> 297*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3150531" role="heading" level="3" l10n="U">Syntax</paragraph> 298*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3148813" role="code" l10n="U">PERCENTILE(Data; Alpha)</paragraph> 299*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153054" role="paragraph" l10n="U"><emph>Data</emph> represents the array of data.</paragraph> 300*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154212" role="paragraph" l10n="U"><emph>Alpha</emph> represents the percentage of the scale between 0 and 1.</paragraph> 301*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3154290" role="heading" level="3" l10n="U">Example</paragraph> 302*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3159147" role="paragraph" l10n="CHG"><item type="input">=PERCENTILE(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50.</paragraph> 303cdf0e10cSrcweir</section> 304cdf0e10cSrcweir<section id="percentrank"> 30588cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3148807"> 30688cae784Smseidel<bookmark_value>PERCENTRANK function</bookmark_value> 307cdf0e10cSrcweir</bookmark> 308cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUANTILSRANG" id="bm_id3154902" localize="false"/> 309*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3148807" role="heading" level="2" l10n="U">PERCENTRANK</paragraph> 310*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153573" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_QUANTILSRANG">Returns the percentage rank of a value in a sample.</ahelp></paragraph> 311*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3147512" role="heading" level="3" l10n="U">Syntax</paragraph> 312*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3147238" role="code" l10n="U">PERCENTRANK(Data; Value)</paragraph> 313*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3154266" role="paragraph" l10n="U"><emph>Data</emph> represents the array of data in the sample.</paragraph> 314*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3148475" role="paragraph" l10n="U"><emph>Value</emph> represents the value whose percentile rank must be determined.</paragraph> 315*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3155364" role="heading" level="3" l10n="U">Example</paragraph> 316*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3149163" role="paragraph" l10n="U"><item type="input">=PERCENTRANK(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear.</paragraph> 317cdf0e10cSrcweir</section> 318cdf0e10cSrcweir<section id="quartile"> 31988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3166442"> 32088cae784Smseidel<bookmark_value>QUARTILE function</bookmark_value> 321cdf0e10cSrcweir</bookmark> 322cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUARTILE" id="bm_id3150709" localize="false"/> 323*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3166442" role="heading" level="2" l10n="U">QUARTILE</paragraph> 324*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3146958" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_QUARTILE">Returns the quartile of a data set.</ahelp></paragraph> 325*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3152942" role="heading" level="3" l10n="U">Syntax</paragraph> 326*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153684" role="code" l10n="U">QUARTILE(Data; Type)</paragraph> 327*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3153387" role="paragraph" l10n="U"><emph>Data</emph> represents the array of data in the sample.</paragraph> 328*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3155589" role="paragraph" l10n="U"><emph>Type</emph> represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)</paragraph> 329*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="hd_id3149103" role="heading" level="3" l10n="U">Example</paragraph> 330*b36d6b5dSmseidel<paragraph xml-lang="en-US" id="par_id3159276" role="paragraph" l10n="CHG"><item type="input">=QUARTILE(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.</paragraph> 331cdf0e10cSrcweir</section> 332cdf0e10cSrcweir</sort> 333cdf0e10cSrcweir<section id="relatedtopics"> 334cdf0e10cSrcweir<embed href="text/scalc/01/04060100.xhp#drking"/> 335cdf0e10cSrcweir</section> 336cdf0e10cSrcweir</body> 337cdf0e10cSrcweir</helpdocument> 338