| 04060184.xhp (514ce53b) | 04060184.xhp (cf1bdece) |
|---|---|
| 1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> | 1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> |
| 3 | 3 4 |
| 4<!--*********************************************************** | 5<!--*********************************************************** |
| 5 * | 6 * |
| 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at | 7 * Licensed to the Apache Software Foundation (ASF) under one 8 * or more contributor license agreements. See the NOTICE file 9 * distributed with this work for additional information 10 * regarding copyright ownership. The ASF licenses this file 11 * to you under the Apache License, Version 2.0 (the 12 * "License"); you may not use this file except in compliance 13 * with the License. You may obtain a copy of the License at |
| 13 * | 14 * |
| 14 * http://www.apache.org/licenses/LICENSE-2.0 | 15 * http://www.apache.org/licenses/LICENSE-2.0 |
| 15 * | 16 * |
| 16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License. | 17 * Unless required by applicable law or agreed to in writing, 18 * software distributed under the License is distributed on an 19 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20 * KIND, either express or implied. See the License for the 21 * specific language governing permissions and limitations 22 * under the License. |
| 22 * | 23 * |
| 23 ***********************************************************--> 24 25 26 | 24 ***********************************************************--> 25 26 27 |
| 27 | |
| 28<meta> 29<topic id="textscalc0104060184xml" indexer="include"> 30<title xml-lang="en-US" id="tit">Statistical Functions Part Four</title> 31<filename>/text/scalc/01/04060184.xhp</filename> 32</topic> 33</meta> 34<body> 35<paragraph xml-lang="en-US" id="hd_id3153415" role="heading" level="1" l10n="U" oldref="1"><variable id="mq"><link href="text/scalc/01/04060184.xhp" name="Statistical Functions Part Four">Statistical Functions Part Four</link> --- 93 unchanged lines hidden (view full) --- 129<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/> 130<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2" l10n="U" oldref="27">AVEDEV</paragraph> 131<paragraph role="paragraph" id="par_id3150373" xml-lang="en-US" l10n="U" oldref="28"><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> 132<paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3" l10n="U" oldref="29">Syntax</paragraph> 133<paragraph role="code" id="par_id3145636" xml-lang="en-US" l10n="U" oldref="30">AVEDEV(Number1; Number2; ...Number30)</paragraph> 134<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US" l10n="U" oldref="31"><emph>Number1, Number2,...Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph> 135<paragraph role="heading" id="hd_id3149725" xml-lang="en-US" level="3" l10n="U" oldref="32">Example</paragraph> 136<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US" l10n="U" oldref="33"> | 28<meta> 29<topic id="textscalc0104060184xml" indexer="include"> 30<title xml-lang="en-US" id="tit">Statistical Functions Part Four</title> 31<filename>/text/scalc/01/04060184.xhp</filename> 32</topic> 33</meta> 34<body> 35<paragraph xml-lang="en-US" id="hd_id3153415" role="heading" level="1" l10n="U" oldref="1"><variable id="mq"><link href="text/scalc/01/04060184.xhp" name="Statistical Functions Part Four">Statistical Functions Part Four</link> --- 93 unchanged lines hidden (view full) --- 129<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/> 130<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2" l10n="U" oldref="27">AVEDEV</paragraph> 131<paragraph role="paragraph" id="par_id3150373" xml-lang="en-US" l10n="U" oldref="28"><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> 132<paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3" l10n="U" oldref="29">Syntax</paragraph> 133<paragraph role="code" id="par_id3145636" xml-lang="en-US" l10n="U" oldref="30">AVEDEV(Number1; Number2; ...Number30)</paragraph> 134<paragraph role="paragraph" id="par_id3157871" xml-lang="en-US" l10n="U" oldref="31"><emph>Number1, Number2,...Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference.</paragraph> 135<paragraph role="heading" id="hd_id3149725" xml-lang="en-US" level="3" l10n="U" oldref="32">Example</paragraph> 136<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US" l10n="U" oldref="33"> |
| 137 <item type="input">=AVEDEV(A1:A50)</item> 138 </paragraph> | 137<item type="input">=AVEDEV(A1:A50)</item> 138</paragraph> |
| 139</section> 140<section id="average"> 141<bookmark xml-lang="en-US" branch="index" id="bm_id3145824"><bookmark_value>AVERAGE function</bookmark_value> 142</bookmark> 143<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/> 144<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2" l10n="U" 145oldref="35">AVERAGE</paragraph> 146<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph" l10n="U" oldref="36"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph> --- 24 unchanged lines hidden (view full) --- 171<item type="input">=AVERAGEA(A1:A50)</item> 172</paragraph> 173</section> 174<section id="averageif"> 175<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K1"><bookmark_value>AVERAGEIF function</bookmark_value> 176</bookmark> 177<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTB" id="bm_id3149690K1" localize="false"/> 178<paragraph xml-lang="en-US" id="hd_id3148754K1" role="heading" level="2" l10n="U" | 139</section> 140<section id="average"> 141<bookmark xml-lang="en-US" branch="index" id="bm_id3145824"><bookmark_value>AVERAGE function</bookmark_value> 142</bookmark> 143<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/> 144<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2" l10n="U" 145oldref="35">AVERAGE</paragraph> 146<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph" l10n="U" oldref="36"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph> --- 24 unchanged lines hidden (view full) --- 171<item type="input">=AVERAGEA(A1:A50)</item> 172</paragraph> 173</section> 174<section id="averageif"> 175<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K1"><bookmark_value>AVERAGEIF function</bookmark_value> 176</bookmark> 177<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTB" id="bm_id3149690K1" localize="false"/> 178<paragraph xml-lang="en-US" id="hd_id3148754K1" role="heading" level="2" l10n="U" |
| 179 oldref="157">AVERAGEIF</paragraph><comment>kschenk added this entry </comment> | 179oldref="157">AVERAGEIF</paragraph><comment>kschenk added this entry </comment> |
| 180<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> 181<paragraph xml-lang="en-US" id="hd_id3153326K1" role="heading" level="3" l10n="U" 182oldref="159">Syntax</paragraph> 183<paragraph xml-lang="en-US" id="par_id3149734K1" role="code" l10n="U" >AVERAGEIF( Reference R ; Criterion C [ ; Reference A ] )</paragraph> | 180<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> 181<paragraph xml-lang="en-US" id="hd_id3153326K1" role="heading" level="3" l10n="U" 182oldref="159">Syntax</paragraph> 183<paragraph xml-lang="en-US" id="par_id3149734K1" role="code" l10n="U" >AVERAGEIF( Reference R ; Criterion C [ ; Reference A ] )</paragraph> |
| 184<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> | 184<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> |
| 185<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> 186<paragraph xml-lang="en-US" id="hd_id3149504K1" role="heading" level="3" l10n="U" 187oldref="162">Examples</paragraph> 188<paragraph xml-lang="en-US" id="par_id3150864K1" role="paragraph" l10n="U"> | 185<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> 186<paragraph xml-lang="en-US" id="hd_id3149504K1" role="heading" level="3" l10n="U" 187oldref="162">Examples</paragraph> 188<paragraph xml-lang="en-US" id="par_id3150864K1" role="paragraph" l10n="U"> |
| 189<item type="input">=AVERAGEIF(A1:A50;">"0)</item> 190will return the average of A1:A50 of all positive values in the range. | 189<item type="input">=AVERAGEIF(A1:A50;">"0)</item> will return the average of A1:A50 of all positive values in the range. |
| 191</paragraph> 192</section> 193<section id="averageifs"> 194<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K2"><bookmark_value>AVERAGEIFS function</bookmark_value> 195</bookmark> 196<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTC" id="bm_id3149690K2" localize="false"/> 197<paragraph xml-lang="en-US" id="hd_id3148754K2" role="heading" level="2" l10n="U" | 190</paragraph> 191</section> 192<section id="averageifs"> 193<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K2"><bookmark_value>AVERAGEIFS function</bookmark_value> 194</bookmark> 195<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTC" id="bm_id3149690K2" localize="false"/> 196<paragraph xml-lang="en-US" id="hd_id3148754K2" role="heading" level="2" l10n="U" |
| 198 oldref="157">AVERAGEIFS</paragraph><comment>kschenk added this entry </comment> | 197oldref="157">AVERAGEIFS</paragraph><comment>kschenk added this entry </comment> |
| 199<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> 200<paragraph xml-lang="en-US" id="hd_id3153326K2" role="heading" level="3" l10n="U" 201oldref="159">Syntax</paragraph> 202<paragraph xml-lang="en-US" id="par_id3149734K2" role="code" l10n="U" >AVERAGEIFS( Reference A ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 203<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> 204<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> 205<paragraph xml-lang="en-US" id="hd_id3149504K2" role="heading" level="3" l10n="U" 206oldref="162">Example</paragraph> 207<paragraph xml-lang="en-US" id="par_id3150864K2" role="paragraph" l10n="U"> | 198<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> 199<paragraph xml-lang="en-US" id="hd_id3153326K2" role="heading" level="3" l10n="U" 200oldref="159">Syntax</paragraph> 201<paragraph xml-lang="en-US" id="par_id3149734K2" role="code" l10n="U" >AVERAGEIFS( Reference A ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 202<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> 203<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> 204<paragraph xml-lang="en-US" id="hd_id3149504K2" role="heading" level="3" l10n="U" 205oldref="162">Example</paragraph> 206<paragraph xml-lang="en-US" id="par_id3150864K2" role="paragraph" l10n="U"> |
| 208<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. | 207<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. |
| 209</paragraph> 210</section> 211<section id="mode"> 212<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>MODE function</bookmark_value> 213<bookmark_value>most common value</bookmark_value> 214</bookmark><comment>mw added one entry</comment> 215<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/> 216<paragraph xml-lang="en-US" id="hd_id3153933" role="heading" level="2" l10n="U" --- 40 unchanged lines hidden (view full) --- 257oldref="63">Syntax</paragraph> 258<paragraph xml-lang="en-US" id="par_id3147534" role="code" l10n="U" oldref="64">NORMINV(Number; Mean; StDev)</paragraph> 259<paragraph xml-lang="en-US" id="par_id3154950" role="paragraph" l10n="U" oldref="65"><emph>Number</emph> represents the probability value used to determine the inverse normal distribution.</paragraph> 260<paragraph xml-lang="en-US" id="par_id3150690" role="paragraph" l10n="U" oldref="66"><emph>Mean</emph> represents the mean value in the normal distribution.</paragraph> 261<paragraph xml-lang="en-US" id="par_id3148594" role="paragraph" l10n="U" oldref="67"><emph>StDev</emph> represents the standard deviation of the normal distribution.</paragraph> 262<paragraph xml-lang="en-US" id="hd_id3155822" role="heading" level="3" l10n="U" 263oldref="68">Example</paragraph> 264<paragraph xml-lang="en-US" id="par_id3153921" role="paragraph" l10n="CHG" oldref="69"> | 208</paragraph> 209</section> 210<section id="mode"> 211<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>MODE function</bookmark_value> 212<bookmark_value>most common value</bookmark_value> 213</bookmark><comment>mw added one entry</comment> 214<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/> 215<paragraph xml-lang="en-US" id="hd_id3153933" role="heading" level="2" l10n="U" --- 40 unchanged lines hidden (view full) --- 256oldref="63">Syntax</paragraph> 257<paragraph xml-lang="en-US" id="par_id3147534" role="code" l10n="U" oldref="64">NORMINV(Number; Mean; StDev)</paragraph> 258<paragraph xml-lang="en-US" id="par_id3154950" role="paragraph" l10n="U" oldref="65"><emph>Number</emph> represents the probability value used to determine the inverse normal distribution.</paragraph> 259<paragraph xml-lang="en-US" id="par_id3150690" role="paragraph" l10n="U" oldref="66"><emph>Mean</emph> represents the mean value in the normal distribution.</paragraph> 260<paragraph xml-lang="en-US" id="par_id3148594" role="paragraph" l10n="U" oldref="67"><emph>StDev</emph> represents the standard deviation of the normal distribution.</paragraph> 261<paragraph xml-lang="en-US" id="hd_id3155822" role="heading" level="3" l10n="U" 262oldref="68">Example</paragraph> 263<paragraph xml-lang="en-US" id="par_id3153921" role="paragraph" l10n="CHG" oldref="69"> |
| 265<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.41g grams.</paragraph> | 264<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> |
| 266</section> 267<section id="normdist"> 268<bookmark xml-lang="en-US" branch="index" id="bm_id3153722"><bookmark_value>NORMDIST function</bookmark_value> 269<bookmark_value>density function</bookmark_value> 270</bookmark><comment>mw added one entry</comment> 271<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMVERT" id="bm_id3147484" localize="false"/> 272<paragraph xml-lang="en-US" id="hd_id3153722" role="heading" level="2" l10n="U" 273oldref="71">NORMDIST</paragraph> --- 126 unchanged lines hidden --- | 265</section> 266<section id="normdist"> 267<bookmark xml-lang="en-US" branch="index" id="bm_id3153722"><bookmark_value>NORMDIST function</bookmark_value> 268<bookmark_value>density function</bookmark_value> 269</bookmark><comment>mw added one entry</comment> 270<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMVERT" id="bm_id3147484" localize="false"/> 271<paragraph xml-lang="en-US" id="hd_id3153722" role="heading" level="2" l10n="U" 272oldref="71">NORMDIST</paragraph> --- 126 unchanged lines hidden --- |