1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir<helpdocument version="1.0"> 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir<!-- 5*cdf0e10cSrcweir*********************************************************************** 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 12*cdf0e10cSrcweir * 13*cdf0e10cSrcweir * This file is part of OpenOffice.org. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 16*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 17*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 18*cdf0e10cSrcweir * 19*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 20*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 21*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 22*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 23*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 24*cdf0e10cSrcweir * 25*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 26*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 27*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 28*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 29*cdf0e10cSrcweir * 30*cdf0e10cSrcweir ************************************************************************ 31*cdf0e10cSrcweir --> 32*cdf0e10cSrcweir 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir<meta> 35*cdf0e10cSrcweir <topic id="textscalc0104060185xml" indexer="include"> 36*cdf0e10cSrcweir <title xml-lang="en-US" id="tit">Statistical Functions Part Five</title> 37*cdf0e10cSrcweir <filename>/text/scalc/01/04060185.xhp</filename> 38*cdf0e10cSrcweir </topic> 39*cdf0e10cSrcweir </meta> 40*cdf0e10cSrcweir <body> 41*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147072" role="heading" level="1" l10n="U" oldref="1"><variable id="rz"><link href="text/scalc/01/04060185.xhp" name="Statistical Functions Part Five">Statistical Functions Part Five</link> 42*cdf0e10cSrcweir</variable></paragraph> 43*cdf0e10cSrcweir<sort order="asc"> 44*cdf0e10cSrcweir<section id="rank"> 45*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3155071"><bookmark_value>RANK function</bookmark_value> 46*cdf0e10cSrcweir <bookmark_value>numbers;determining ranks</bookmark_value> 47*cdf0e10cSrcweir</bookmark> 48*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANG" id="bm_id3146778" localize="false"/> 49*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155071" role="heading" level="2" l10n="U" oldref="2">RANK</paragraph> 50*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153976" role="paragraph" l10n="U" oldref="3"><ahelp hid="HID_FUNC_RANG">Returns the rank of a number in a sample.</ahelp></paragraph> 51*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3159206" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph> 52*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153250" role="code" l10n="U" oldref="5">RANK(Value; Data; Type)</paragraph> 53*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154543" role="paragraph" l10n="U" oldref="6"> 54*cdf0e10cSrcweir <emph>Value</emph> is the value, whose rank is to be determined.</paragraph> 55*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149130" role="paragraph" l10n="U" oldref="7"> 56*cdf0e10cSrcweir <emph>Data</emph> is the array or range of data in the sample.</paragraph> 57*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150215" role="paragraph" l10n="CHG" oldref="8"> 58*cdf0e10cSrcweir <emph>Type</emph> (optional) is the sequence order.</paragraph> 59*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id9305398" role="paragraph" l10n="NEW">Type = 0 means descending from the last item of the array to the first (this is the default), </paragraph> 60*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id9996948" role="paragraph" l10n="NEW">Type = 1 means ascending from the first item of the range to the last.</paragraph> 61*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3143223" role="heading" level="3" l10n="U" oldref="9">Example</paragraph> 62*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155919" role="paragraph" l10n="U" oldref="10"> 63*cdf0e10cSrcweir <item type="input">=RANK(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type="literal">Value</item> does not exist within the range an error message is displayed.</paragraph> 64*cdf0e10cSrcweir </section> 65*cdf0e10cSrcweir <section id="skew"> 66*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value> 67*cdf0e10cSrcweir</bookmark> 68*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHIEFE" id="bm_id3153801" localize="false"/> 69*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153556" role="heading" level="2" l10n="U" 70*cdf0e10cSrcweir oldref="12">SKEW</paragraph> 71*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153485" role="paragraph" l10n="U" oldref="13"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></paragraph> 72*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154733" role="heading" level="3" l10n="U" 73*cdf0e10cSrcweir oldref="14">Syntax</paragraph> 74*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151191" role="code" l10n="U" oldref="15">SKEW(Number1; Number2; ...Number30)</paragraph> 75*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155757" role="paragraph" l10n="CHG" oldref="16"> 76*cdf0e10cSrcweir <emph>Number1, Number2...Number30</emph> are numerical values or ranges.</paragraph> 77*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153297" role="heading" level="3" l10n="U" 78*cdf0e10cSrcweir oldref="17">Example</paragraph> 79*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="U" oldref="18"> 80*cdf0e10cSrcweir <item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph> 81*cdf0e10cSrcweir </section> 82*cdf0e10cSrcweir <section id="forecast"> 83*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149051"><bookmark_value>regression lines;FORECAST function</bookmark_value> 84*cdf0e10cSrcweir <bookmark_value>extrapolations</bookmark_value> 85*cdf0e10cSrcweir <bookmark_value>FORECAST function</bookmark_value> 86*cdf0e10cSrcweir</bookmark> 87*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHAETZER" id="bm_id3146102" localize="false"/><comment>mw made "regression lines" a two level entry</comment> 88*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149051" role="heading" level="2" l10n="U" 89*cdf0e10cSrcweir oldref="20">FORECAST</paragraph> 90*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153290" role="paragraph" l10n="U" oldref="21"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph> 91*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3151343" role="heading" level="3" l10n="U" 92*cdf0e10cSrcweir oldref="22">Syntax</paragraph> 93*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147404" role="code" l10n="U" oldref="23">FORECAST(Value; DataY; DataX)</paragraph> 94*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148743" role="paragraph" l10n="U" oldref="24"> 95*cdf0e10cSrcweir <emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph> 96*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146325" role="paragraph" l10n="U" oldref="25"> 97*cdf0e10cSrcweir <emph>DataY</emph> is the array or range of known y's.</paragraph> 98*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150536" role="paragraph" l10n="U" oldref="26"> 99*cdf0e10cSrcweir <emph>DataX</emph> is the array or range of known x's.</paragraph> 100*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147416" role="heading" level="3" l10n="U" 101*cdf0e10cSrcweir oldref="27">Example</paragraph> 102*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3157874" role="paragraph" l10n="U" oldref="28"> 103*cdf0e10cSrcweir <item type="input">=FORECAST(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph> 104*cdf0e10cSrcweir </section> 105*cdf0e10cSrcweir <section id="stdev"> 106*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value> 107*cdf0e10cSrcweir <bookmark_value>standard deviations in statistics;based on a sample</bookmark_value> 108*cdf0e10cSrcweir</bookmark> 109*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABW" id="bm_id3153121" localize="false"/> 110*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="2" l10n="U" 111*cdf0e10cSrcweir oldref="30">STDEV</paragraph> 112*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146888" role="paragraph" l10n="U" oldref="31"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph> 113*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3146815" role="heading" level="3" l10n="U" 114*cdf0e10cSrcweir oldref="32">Syntax</paragraph> 115*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149946" role="code" l10n="U" oldref="33">STDEV(Number1; Number2; ...Number30)</paragraph> 116*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3157904" role="paragraph" l10n="CHG" oldref="34"> 117*cdf0e10cSrcweir <emph>Number1, Number2, ... Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> 118*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3150650" role="heading" level="3" l10n="U" 119*cdf0e10cSrcweir oldref="35">Example</paragraph> 120*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149434" role="paragraph" l10n="U" oldref="36"> 121*cdf0e10cSrcweir <item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> 122*cdf0e10cSrcweir </section> 123*cdf0e10cSrcweir <section id="stdeva"> 124*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value> 125*cdf0e10cSrcweir</bookmark> 126*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWA" id="bm_id3154846" localize="false"/> 127*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3144745" role="heading" level="2" l10n="U" 128*cdf0e10cSrcweir oldref="186">STDEVA</paragraph> 129*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151234" role="paragraph" l10n="U" oldref="187"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph> 130*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3148884" role="heading" level="3" l10n="U" 131*cdf0e10cSrcweir oldref="188">Syntax</paragraph> 132*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147422" role="code" l10n="U" oldref="189">STDEVA(Value1;Value2;...Value30)</paragraph> 133*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154547" role="paragraph" l10n="CHG" oldref="190"> 134*cdf0e10cSrcweir <emph>Value1, Value2, ...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> 135*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155829" role="heading" level="3" l10n="U" 136*cdf0e10cSrcweir oldref="191">Example</paragraph> 137*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148581" role="paragraph" l10n="U" oldref="192"> 138*cdf0e10cSrcweir <item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> 139*cdf0e10cSrcweir </section> 140*cdf0e10cSrcweir <section id="stdevp"> 141*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149734"><bookmark_value>STDEVP function</bookmark_value> 142*cdf0e10cSrcweir <bookmark_value>standard deviations in statistics;based on a population</bookmark_value> 143*cdf0e10cSrcweir</bookmark> 144*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWN" id="bm_id3146139" localize="false"/> 145*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149734" role="heading" level="2" l10n="U" 146*cdf0e10cSrcweir oldref="38">STDEVP</paragraph> 147*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149187" role="paragraph" l10n="U" oldref="39"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph> 148*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154387" role="heading" level="3" l10n="U" 149*cdf0e10cSrcweir oldref="40">Syntax</paragraph> 150*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154392" role="code" l10n="U" oldref="41">STDEVP(Number1;Number2;...Number30)</paragraph> 151*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155261" role="paragraph" l10n="CHG" oldref="42"> 152*cdf0e10cSrcweir <emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> 153*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3" l10n="U" 154*cdf0e10cSrcweir oldref="43">Example</paragraph> 155*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153933" role="paragraph" l10n="U" oldref="44"> 156*cdf0e10cSrcweir <item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> 157*cdf0e10cSrcweir </section> 158*cdf0e10cSrcweir <section id="stdevpa"> 159*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value> 160*cdf0e10cSrcweir</bookmark> 161*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWNA" id="bm_id3150902" localize="false"/> 162*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154522" role="heading" level="2" l10n="U" 163*cdf0e10cSrcweir oldref="194">STDEVPA</paragraph> 164*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149549" role="paragraph" l10n="U" oldref="195"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph> 165*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155950" role="heading" level="3" l10n="U" 166*cdf0e10cSrcweir oldref="196">Syntax</paragraph> 167*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146851" role="code" l10n="U" oldref="197">STDEVPA(Value1;Value2;...Value30)</paragraph> 168*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153109" role="paragraph" l10n="CHG" oldref="198"> 169*cdf0e10cSrcweir <emph>Value1,value2,...value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> 170*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154506" role="heading" level="3" l10n="U" 171*cdf0e10cSrcweir oldref="199">Example</paragraph> 172*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145163" role="paragraph" l10n="U" oldref="200"> 173*cdf0e10cSrcweir <item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph> 174*cdf0e10cSrcweir </section> 175*cdf0e10cSrcweir <section id="standardize"> 176*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3155928"><bookmark_value>STANDARDIZE function</bookmark_value> 177*cdf0e10cSrcweir <bookmark_value>converting;random variables, into normalized values</bookmark_value> 178*cdf0e10cSrcweir</bookmark> 179*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDARDISIERUNG" id="bm_id3148764" localize="false"/> 180*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155928" role="heading" level="2" l10n="U" 181*cdf0e10cSrcweir oldref="46">STANDARDIZE</paragraph> 182*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149883" role="paragraph" l10n="U" oldref="47"><ahelp hid="HID_FUNC_STANDARDISIERUNG">Converts a random variable to a normalized value.</ahelp></paragraph> 183*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154330" role="heading" level="3" l10n="U" 184*cdf0e10cSrcweir oldref="48">Syntax</paragraph> 185*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150132" role="code" l10n="U" oldref="49">STANDARDIZE(Number; Mean; StDev)</paragraph> 186*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3159139" role="paragraph" l10n="U" oldref="50"> 187*cdf0e10cSrcweir <emph>Number</emph> is the value to be standardized.</paragraph> 188*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145241" role="paragraph" l10n="U" oldref="51"> 189*cdf0e10cSrcweir <emph>Mean</emph> is the arithmetic mean of the distribution.</paragraph> 190*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148874" role="paragraph" l10n="U" oldref="52"> 191*cdf0e10cSrcweir <emph>StDev</emph> is the standard deviation of the distribution.</paragraph> 192*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3145351" role="heading" level="3" l10n="U" 193*cdf0e10cSrcweir oldref="53">Example</paragraph> 194*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156067" role="paragraph" l10n="U" oldref="54"> 195*cdf0e10cSrcweir <item type="input">=STANDARDIZE(11;10;1)</item> returns 1. The value 11 in a normal distribution with a mean of 10 and a standard deviation of 1 is as much above the mean of 10, as the value 1 is above the mean of the standard normal distribution.</paragraph> 196*cdf0e10cSrcweir </section> 197*cdf0e10cSrcweir <section id="normsinv"> 198*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3157986"><bookmark_value>NORMSINV function</bookmark_value> 199*cdf0e10cSrcweir <bookmark_value>normal distribution;inverse of standard</bookmark_value> 200*cdf0e10cSrcweir</bookmark> 201*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMINV" id="bm_id3148389" localize="false"/> 202*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3157986" role="heading" level="2" l10n="U" 203*cdf0e10cSrcweir oldref="56">NORMSINV</paragraph> 204*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151282" role="paragraph" l10n="U" oldref="57"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph> 205*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153261" role="heading" level="3" l10n="U" 206*cdf0e10cSrcweir oldref="58">Syntax</paragraph> 207*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154195" role="code" l10n="U" oldref="59">NORMINV(Number)</paragraph> 208*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148772" role="paragraph" l10n="U" oldref="60"> 209*cdf0e10cSrcweir <emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph> 210*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3150934" role="heading" level="3" l10n="U" 211*cdf0e10cSrcweir oldref="61">Example</paragraph> 212*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149030" role="paragraph" l10n="U" oldref="62"> 213*cdf0e10cSrcweir <item type="input">=NORMSINV(0.908789)</item> returns 1.3333.</paragraph> 214*cdf0e10cSrcweir </section> 215*cdf0e10cSrcweir <section id="normsdist"> 216*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value> 217*cdf0e10cSrcweir <bookmark_value>normal distribution;statistics</bookmark_value> 218*cdf0e10cSrcweir</bookmark> 219*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMVERT" id="bm_id3145269" localize="false"/> 220*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3147538" role="heading" level="2" l10n="U" 221*cdf0e10cSrcweir oldref="64">NORMSDIST</paragraph> 222*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150474" role="paragraph" l10n="CHG" oldref="65"><ahelp hid="HID_FUNC_STANDNORMVERT">Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one.</ahelp></paragraph> 223*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id8652302" role="paragraph" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> 224*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155083" role="heading" level="3" l10n="U" 225*cdf0e10cSrcweir oldref="66">Syntax</paragraph> 226*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3158411" role="code" l10n="U" oldref="67">NORMSDIST(Number)</paragraph> 227*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154950" role="paragraph" l10n="CHG" oldref="68"> 228*cdf0e10cSrcweir <emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated.</paragraph> 229*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U" 230*cdf0e10cSrcweir oldref="69">Example</paragraph> 231*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155984" role="paragraph" l10n="U" oldref="70"> 232*cdf0e10cSrcweir <item type="input">=NORMSDIST(1)</item> returns 0.84. The area below the standard normal distribution curve to the left of X value 1 is 84% of the total area.</paragraph> 233*cdf0e10cSrcweir </section> 234*cdf0e10cSrcweir <section id="slope"> 235*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value> 236*cdf0e10cSrcweir</bookmark> 237*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STEIGUNG" id="bm_id3153716" localize="false"/> 238*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3152592" role="heading" level="2" l10n="U" 239*cdf0e10cSrcweir oldref="72">SLOPE</paragraph> 240*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150386" role="paragraph" l10n="U" oldref="73"><ahelp hid="HID_FUNC_STEIGUNG">Returns the slope of the linear regression line.</ahelp> The slope is adapted to the data points set in the y and x values.</paragraph> 241*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154315" role="heading" level="3" l10n="U" 242*cdf0e10cSrcweir oldref="74">Syntax</paragraph> 243*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149819" role="code" l10n="U" oldref="75">SLOPE(DataY; DataX)</paragraph> 244*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3083446" role="paragraph" l10n="U" oldref="76"> 245*cdf0e10cSrcweir <emph>DataY</emph> is the array or matrix of Y data.</paragraph> 246*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152375" role="paragraph" l10n="U" oldref="77"> 247*cdf0e10cSrcweir <emph>DataX</emph> is the array or matrix of X data.</paragraph> 248*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3146061" role="heading" level="3" l10n="U" 249*cdf0e10cSrcweir oldref="78">Example</paragraph> 250*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3152480" role="paragraph" l10n="U" oldref="79"> 251*cdf0e10cSrcweir <item type="input">=SLOPE(A1:A50;B1:B50)</item> 252*cdf0e10cSrcweir </paragraph> 253*cdf0e10cSrcweir </section> 254*cdf0e10cSrcweir <section id="steyx"> 255*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3155836"><bookmark_value>STEYX function</bookmark_value> 256*cdf0e10cSrcweir <bookmark_value>standard errors;statistical functions</bookmark_value> 257*cdf0e10cSrcweir</bookmark><comment>mw changed "standard errors"</comment> 258*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STFEHLERYX" id="bm_id3150964" localize="false"/> 259*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155836" role="heading" level="2" l10n="U" 260*cdf0e10cSrcweir oldref="81">STEYX</paragraph> 261*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149446" role="paragraph" l10n="U" oldref="82"><ahelp hid="HID_FUNC_STFEHLERYX">Returns the standard error of the predicted y value for each x in the regression.</ahelp></paragraph> 262*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147562" role="heading" level="3" l10n="U" 263*cdf0e10cSrcweir oldref="83">Syntax</paragraph> 264*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151267" role="code" l10n="U" oldref="84">STEYX(DataY; DataX)</paragraph> 265*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147313" role="paragraph" l10n="U" oldref="85"> 266*cdf0e10cSrcweir <emph>DataY</emph> is the array or matrix of Y data.</paragraph> 267*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156097" role="paragraph" l10n="U" oldref="86"> 268*cdf0e10cSrcweir <emph>DataX</emph> is the array or matrix of X data.</paragraph> 269*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3145204" role="heading" level="3" l10n="U" 270*cdf0e10cSrcweir oldref="87">Example</paragraph> 271*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156131" role="paragraph" l10n="U" oldref="88"> 272*cdf0e10cSrcweir <item type="input">=STEXY(A1:A50;B1:B50)</item> 273*cdf0e10cSrcweir </paragraph> 274*cdf0e10cSrcweir </section> 275*cdf0e10cSrcweir <section id="devsq"> 276*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150873"><bookmark_value>DEVSQ function</bookmark_value> 277*cdf0e10cSrcweir <bookmark_value>sums;of squares of deviations</bookmark_value> 278*cdf0e10cSrcweir</bookmark> 279*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMQUADABW" id="bm_id3156317" localize="false"/> 280*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3150873" role="heading" level="2" l10n="U" 281*cdf0e10cSrcweir oldref="90">DEVSQ</paragraph> 282*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154748" role="paragraph" l10n="U" oldref="91"><ahelp hid="HID_FUNC_SUMQUADABW">Returns the sum of squares of deviations based on a sample mean.</ahelp></paragraph> 283*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3156121" role="heading" level="3" l10n="U" 284*cdf0e10cSrcweir oldref="92">Syntax</paragraph> 285*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146790" role="code" l10n="U" oldref="93">DEVSQ(Number1; Number2; ...Number30)</paragraph> 286*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155995" role="paragraph" l10n="CHG" oldref="94"> 287*cdf0e10cSrcweir <emph>Number1, Number2, ...Number30</emph> numerical values or ranges representing a sample. </paragraph> 288*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3150254" role="heading" level="3" l10n="U" 289*cdf0e10cSrcweir oldref="95">Example</paragraph> 290*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149136" role="paragraph" l10n="U" oldref="96"> 291*cdf0e10cSrcweir <item type="input">=DEVSQ(A1:A50)</item> 292*cdf0e10cSrcweir </paragraph> 293*cdf0e10cSrcweir </section> 294*cdf0e10cSrcweir <section id="tinv"> 295*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149579"><bookmark_value>TINV function</bookmark_value> 296*cdf0e10cSrcweir <bookmark_value>inverse of t-distribution</bookmark_value> 297*cdf0e10cSrcweir</bookmark> 298*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV" id="bm_id3153155" localize="false"/> 299*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149579" role="heading" level="2" l10n="U" 300*cdf0e10cSrcweir oldref="98">TINV</paragraph> 301*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3143232" role="paragraph" l10n="U" oldref="99"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the t-distribution.</ahelp></paragraph> 302*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3155101" role="heading" level="3" l10n="U" 303*cdf0e10cSrcweir oldref="100">Syntax</paragraph> 304*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149289" role="code" l10n="U" oldref="101">TINV(Number; DegreesFreedom)</paragraph> 305*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154070" role="paragraph" l10n="U" oldref="102"> 306*cdf0e10cSrcweir <emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph> 307*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155315" role="paragraph" l10n="U" oldref="103"> 308*cdf0e10cSrcweir <emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> 309*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153885" role="heading" level="3" l10n="U" 310*cdf0e10cSrcweir oldref="104">Example</paragraph> 311*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156010" role="paragraph" l10n="CHG" oldref="105"> 312*cdf0e10cSrcweir <item type="input">=TINV(0.1;6)</item> returns 1.94</paragraph> 313*cdf0e10cSrcweir </section> 314*cdf0e10cSrcweir <section id="ttest"> 315*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value> 316*cdf0e10cSrcweir</bookmark> 317*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST" id="bm_id3153981" localize="false"/> 318*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154129" role="heading" level="2" l10n="U" 319*cdf0e10cSrcweir oldref="107">TTEST</paragraph> 320*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3159184" role="paragraph" l10n="U" oldref="108"><ahelp hid="HID_FUNC_TTEST">Returns the probability associated with a Student's t-Test.</ahelp></paragraph> 321*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147257" role="heading" level="3" l10n="U" 322*cdf0e10cSrcweir oldref="109">Syntax</paragraph> 323*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151175" role="code" l10n="U" oldref="110">TTEST(Data1; Data2; Mode; Type)</paragraph> 324*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U" oldref="111"> 325*cdf0e10cSrcweir <emph>Data1</emph> is the dependent array or range of data for the first record.</paragraph> 326*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3145666" role="paragraph" l10n="U" oldref="112"> 327*cdf0e10cSrcweir <emph>Data2</emph> is the dependent array or range of data for the second record.</paragraph> 328*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153903" role="paragraph" l10n="U" oldref="113"> 329*cdf0e10cSrcweir <emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test.</paragraph> 330*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155327" role="paragraph" l10n="U" oldref="114"> 331*cdf0e10cSrcweir <emph>Type</emph> is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).</paragraph> 332*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3159342" role="heading" level="3" l10n="U" 333*cdf0e10cSrcweir oldref="115">Example</paragraph> 334*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150119" role="paragraph" l10n="U" oldref="116"> 335*cdf0e10cSrcweir <item type="input">=TTEST(A1:A50;B1:B50;2;2)</item> 336*cdf0e10cSrcweir </paragraph> 337*cdf0e10cSrcweir </section> 338*cdf0e10cSrcweir <section id="tdist"> 339*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value> 340*cdf0e10cSrcweir <bookmark_value>t-distribution</bookmark_value> 341*cdf0e10cSrcweir</bookmark> 342*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TVERT" id="bm_id3153095" localize="false"/> 343*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154930" role="heading" level="2" l10n="U" 344*cdf0e10cSrcweir oldref="118">TDIST</paragraph> 345*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153372" role="paragraph" l10n="U" oldref="119"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph> 346*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3149911" role="heading" level="3" l10n="U" 347*cdf0e10cSrcweir oldref="120">Syntax</paragraph> 348*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150521" role="code" l10n="U" oldref="121">TDIST(Number; DegreesFreedom; Mode)</paragraph> 349*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146991" role="paragraph" l10n="U" oldref="122"> 350*cdf0e10cSrcweir <emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph> 351*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148824" role="paragraph" l10n="U" oldref="123"> 352*cdf0e10cSrcweir <emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> 353*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149340" role="paragraph" l10n="U" oldref="124"> 354*cdf0e10cSrcweir <emph>Mode</emph> = 1 returns the one-tailed test, <emph>Mode</emph> = 2 returns the two-tailed test.</paragraph> 355*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3159150" role="heading" level="3" l10n="U" 356*cdf0e10cSrcweir oldref="125">Example</paragraph> 357*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149773" role="paragraph" l10n="U" oldref="126"> 358*cdf0e10cSrcweir <item type="input">=TDIST(12;5;1)</item> 359*cdf0e10cSrcweir </paragraph> 360*cdf0e10cSrcweir </section> 361*cdf0e10cSrcweir <section id="var"> 362*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153828"><bookmark_value>VAR function</bookmark_value> 363*cdf0e10cSrcweir <bookmark_value>variances</bookmark_value> 364*cdf0e10cSrcweir</bookmark> 365*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZ" id="bm_id3154898" localize="false"/> 366*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153828" role="heading" level="2" l10n="U" 367*cdf0e10cSrcweir oldref="128">VAR</paragraph> 368*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3159165" role="paragraph" l10n="U" oldref="129"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph> 369*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154286" role="heading" level="3" l10n="U" 370*cdf0e10cSrcweir oldref="130">Syntax</paragraph> 371*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153054" role="code" l10n="U" oldref="131">VAR(Number1; Number2; ...Number30)</paragraph> 372*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148938" role="paragraph" l10n="CHG" oldref="132"> 373*cdf0e10cSrcweir <emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> 374*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147233" role="heading" level="3" l10n="U" 375*cdf0e10cSrcweir oldref="133">Example</paragraph> 376*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153575" role="paragraph" l10n="U" oldref="134"> 377*cdf0e10cSrcweir <item type="input">=VAR(A1:A50)</item> 378*cdf0e10cSrcweir </paragraph> 379*cdf0e10cSrcweir </section> 380*cdf0e10cSrcweir <section id="vara"> 381*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value> 382*cdf0e10cSrcweir</bookmark> 383*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZA" id="bm_id3148473" localize="false"/> 384*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3151045" role="heading" level="2" l10n="U" 385*cdf0e10cSrcweir oldref="202">VARA</paragraph> 386*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3155122" role="paragraph" l10n="U" oldref="203"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph> 387*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3149176" role="heading" level="3" l10n="U" 388*cdf0e10cSrcweir oldref="204">Syntax</paragraph> 389*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149999" role="code" l10n="U" oldref="205">VARA(Value1; Value2; ...Value30)</paragraph> 390*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3158421" role="paragraph" l10n="CHG" oldref="206"> 391*cdf0e10cSrcweir <emph>Value1, Value2,...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> 392*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3149160" role="heading" level="3" l10n="U" 393*cdf0e10cSrcweir oldref="207">Example</paragraph> 394*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154279" role="paragraph" l10n="U" oldref="208"> 395*cdf0e10cSrcweir <item type="input">=VARA(A1:A50)</item> 396*cdf0e10cSrcweir </paragraph> 397*cdf0e10cSrcweir </section> 398*cdf0e10cSrcweir <section id="varp"> 399*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3166441"><bookmark_value>VARP function</bookmark_value> 400*cdf0e10cSrcweir</bookmark> 401*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZEN" id="bm_id3152359" localize="false"/> 402*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3166441" role="heading" level="2" l10n="U" 403*cdf0e10cSrcweir oldref="136">VARP</paragraph> 404*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3159199" role="paragraph" l10n="U" oldref="137"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph> 405*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3150706" role="heading" level="3" l10n="U" 406*cdf0e10cSrcweir oldref="138">Syntax</paragraph> 407*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147282" role="code" l10n="U" oldref="139">VARP(Number1; Number2; ...Number30)</paragraph> 408*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149793" role="paragraph" l10n="CHG" oldref="140"> 409*cdf0e10cSrcweir <emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph> 410*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3152939" role="heading" level="3" l10n="U" 411*cdf0e10cSrcweir oldref="141">Example</paragraph> 412*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153385" role="paragraph" l10n="U" oldref="142"> 413*cdf0e10cSrcweir <item type="input">=VARP(A1:A50)</item> 414*cdf0e10cSrcweir </paragraph> 415*cdf0e10cSrcweir </section> 416*cdf0e10cSrcweir <section id="varpa"> 417*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value> 418*cdf0e10cSrcweir</bookmark> 419*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZENA" id="bm_id3159276" localize="false"/> 420*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153688" role="heading" level="2" l10n="U" 421*cdf0e10cSrcweir oldref="210">VARPA</paragraph> 422*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149109" role="paragraph" l10n="U" oldref="211"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph> 423*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3152880" role="heading" level="3" l10n="U" 424*cdf0e10cSrcweir oldref="212">Syntax</paragraph> 425*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149967" role="code" l10n="U" oldref="213">VARPA(Value1; Value2; ...Value30)</paragraph> 426*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149920" role="paragraph" l10n="CHG" oldref="214"> 427*cdf0e10cSrcweir <emph>Value1,value2,...Value30</emph> are values or ranges representing an entire population.</paragraph> 428*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3154862" role="heading" level="3" l10n="U" 429*cdf0e10cSrcweir oldref="215">Example</paragraph> 430*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156203" role="paragraph" l10n="U" oldref="216"> 431*cdf0e10cSrcweir <item type="input">=VARPA(A1:A50)</item> 432*cdf0e10cSrcweir </paragraph> 433*cdf0e10cSrcweir </section> 434*cdf0e10cSrcweir <section id="permut"> 435*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154599"><bookmark_value>PERMUT function</bookmark_value> 436*cdf0e10cSrcweir <bookmark_value>number of permutations</bookmark_value> 437*cdf0e10cSrcweir</bookmark> 438*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN" id="bm_id3154610" localize="false"/> 439*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154599" role="heading" level="2" l10n="U" 440*cdf0e10cSrcweir oldref="144">PERMUT</paragraph> 441*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154334" role="paragraph" l10n="U" oldref="145"><ahelp hid="HID_FUNC_VARIATIONEN">Returns the number of permutations for a given number of objects.</ahelp></paragraph> 442*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3149422" role="heading" level="3" l10n="U" 443*cdf0e10cSrcweir oldref="146">Syntax</paragraph> 444*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148466" role="code" l10n="U" oldref="147">PERMUT(Count1; Count2)</paragraph> 445*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3148656" role="paragraph" l10n="U" oldref="148"> 446*cdf0e10cSrcweir <emph>Count1</emph> is the total number of objects.</paragraph> 447*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150826" role="paragraph" l10n="U" oldref="149"> 448*cdf0e10cSrcweir <emph>Count2</emph> is the number of objects in each permutation.</paragraph> 449*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153351" role="heading" level="3" l10n="U" 450*cdf0e10cSrcweir oldref="150">Example</paragraph> 451*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150424" role="paragraph" l10n="U" oldref="151"> 452*cdf0e10cSrcweir <item type="input">=PERMUT(6;3)</item> returns 120. There are 120 different possibilities, to pick a sequence of 3 playing cards out of 6 playing cards.</paragraph> 453*cdf0e10cSrcweir </section> 454*cdf0e10cSrcweir <section id="permutationa"> 455*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3143276"><bookmark_value>PERMUTATIONA function</bookmark_value> 456*cdf0e10cSrcweir</bookmark> 457*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN2" id="bm_id3153531" localize="false"/> 458*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3143276" role="heading" level="2" l10n="U" 459*cdf0e10cSrcweir oldref="153">PERMUTATIONA</paragraph> 460*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3144759" role="paragraph" l10n="U" oldref="154"><ahelp hid="HID_FUNC_VARIATIONEN2">Returns the number of permutations for a given number of objects (repetition allowed).</ahelp></paragraph> 461*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3145598" role="heading" level="3" l10n="U" 462*cdf0e10cSrcweir oldref="155">Syntax</paragraph> 463*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149298" role="code" l10n="U" oldref="156">PERMUTATIONA(Count1; Count2)</paragraph> 464*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156139" role="paragraph" l10n="U" oldref="157"> 465*cdf0e10cSrcweir <emph>Count1</emph> is the total number of objects.</paragraph> 466*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149519" role="paragraph" l10n="U" oldref="158"> 467*cdf0e10cSrcweir <emph>Count2</emph> is the number of objects in each permutation.</paragraph> 468*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3151382" role="heading" level="3" l10n="U" 469*cdf0e10cSrcweir oldref="159">Example</paragraph> 470*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153949" role="paragraph" l10n="U" oldref="160">How often can 2 objects be selected from a total of 11 objects?</paragraph> 471*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3149233" role="paragraph" l10n="U" oldref="161"> 472*cdf0e10cSrcweir <item type="input">=PERMUTATIONA(11;2)</item> returns 121.</paragraph> 473*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3150622" role="paragraph" l10n="U" oldref="162"> 474*cdf0e10cSrcweir <item type="input">=PERMUTATIONA(6;3)</item> returns 216. There are 216 different possibilities to put a sequence of 3 playing cards together out of six playing cards if every card is returned before the next one is drawn.</paragraph> 475*cdf0e10cSrcweir </section> 476*cdf0e10cSrcweir <section id="prob"> 477*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3152952"><bookmark_value>PROB function</bookmark_value> 478*cdf0e10cSrcweir</bookmark> 479*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHRSCHBEREICH" id="bm_id3152963" localize="false"/> 480*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3152952" role="heading" level="2" l10n="U" 481*cdf0e10cSrcweir oldref="164">PROB</paragraph> 482*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154110" role="paragraph" l10n="U" oldref="165"><ahelp hid="HID_FUNC_WAHRSCHBEREICH">Returns the probability that values in a range are between two limits.</ahelp> If there is no <item type="literal">End</item> value, this function calculates the probability based on the principle that the Data values are equal to the value of <item type="literal">Start</item>.</paragraph> 483*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3146810" role="heading" level="3" l10n="U" 484*cdf0e10cSrcweir oldref="166">Syntax</paragraph> 485*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3147330" role="code" l10n="U" oldref="167">PROB(Data; Probability; Start; End)</paragraph> 486*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154573" role="paragraph" l10n="U" oldref="168"> 487*cdf0e10cSrcweir <emph>Data</emph> is the array or range of data in the sample.</paragraph> 488*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3156334" role="paragraph" l10n="U" oldref="169"> 489*cdf0e10cSrcweir <emph>Probability</emph> is the array or range of the corresponding probabilities.</paragraph> 490*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151107" role="paragraph" l10n="U" oldref="170"> 491*cdf0e10cSrcweir <emph>Start</emph> is the start value of the interval whose probabilities are to be summed.</paragraph> 492*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153694" role="paragraph" l10n="U" oldref="171"> 493*cdf0e10cSrcweir <emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start </emph>value is calculated.</paragraph> 494*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3147574" role="heading" level="3" l10n="U" 495*cdf0e10cSrcweir oldref="172">Example</paragraph> 496*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3153666" role="paragraph" l10n="U" oldref="173"> 497*cdf0e10cSrcweir <item type="input">=PROB(A1:A50;B1:B50;50;60)</item> returns the probability with which a value within the range of A1:A50 is also within the limits between 50 and 60. Every value within the range of A1:A50 has a probability within the range of B1:B50.</paragraph> 498*cdf0e10cSrcweir </section> 499*cdf0e10cSrcweir <section id="weibull"> 500*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150941"><bookmark_value>WEIBULL function</bookmark_value> 501*cdf0e10cSrcweir</bookmark> 502*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL" id="bm_id3150405" localize="false"/> 503*cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3150941" role="heading" level="2" l10n="U" 504*cdf0e10cSrcweir oldref="175">WEIBULL</paragraph> 505*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154916" role="paragraph" l10n="U" oldref="176"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph> 506*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph" l10n="NEW">The Weibull distribution is a continuous probability distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale). </paragraph> 507*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph" l10n="NEW">If C is 0, WEIBULL calculates the probability density function.</paragraph> 508*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph" l10n="NEW">If C is 1, WEIBULL calculates the cumulative distribution function.</paragraph> 509*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3" l10n="U" 510*cdf0e10cSrcweir oldref="177">Syntax</paragraph> 511*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154478" role="code" l10n="U" oldref="178">WEIBULL(Number; Alpha; Beta; C)</paragraph> 512*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3151317" role="paragraph" l10n="U" oldref="179"> 513*cdf0e10cSrcweir <emph>Number</emph> is the value at which to calculate the Weibull distribution.</paragraph> 514*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3158436" role="paragraph" l10n="U" oldref="180"> 515*cdf0e10cSrcweir <emph>Alpha </emph>is the shape parameter of the Weibull distribution.</paragraph> 516*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154668" role="paragraph" l10n="U" oldref="181"> 517*cdf0e10cSrcweir <emph>Beta</emph> is the scale parameter of the Weibull distribution.</paragraph> 518*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3154825" role="paragraph" l10n="CHG" oldref="182"> 519*cdf0e10cSrcweir <emph>C</emph> indicates the type of function.</paragraph> 520*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="hd_id3153794" role="heading" level="3" l10n="U" 521*cdf0e10cSrcweir oldref="183">Example</paragraph> 522*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id3146077" role="paragraph" l10n="U" oldref="184"> 523*cdf0e10cSrcweir <item type="input">=WEIBULL(2;1;1;1)</item> returns 0.86.</paragraph> 524*cdf0e10cSrcweir <paragraph xml-lang="en-US" id="par_id0305200911372899" role="paragraph" l10n="NEW">See also the <link href="http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_WEIBULL_function">Wiki page</link>.</paragraph> 525*cdf0e10cSrcweir </section> 526*cdf0e10cSrcweir</sort> 527*cdf0e10cSrcweir<section id="relatedtopics"> 528*cdf0e10cSrcweir <embed href="text/scalc/01/04060100.xhp#drking"/> 529*cdf0e10cSrcweir </section> 530*cdf0e10cSrcweir </body> 531*cdf0e10cSrcweir</helpdocument>