1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 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 24d1c38b03Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0104060185xml" indexer="include"> 27cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Statistical Functions Part Five</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/04060185.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147072" role="heading" level="1" l10n="U"><variable id="rz"><link href="text/scalc/01/04060185.xhp" name="Statistical Functions Part Five">Statistical Functions Part Five</link> 33cdf0e10cSrcweir</variable></paragraph> 34cdf0e10cSrcweir<sort order="asc"> 35cdf0e10cSrcweir<section id="rank"> 36d1c38b03Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155071"> 37d1c38b03Smseidel<bookmark_value>RANK function</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>numbers;determining ranks</bookmark_value> 39cdf0e10cSrcweir</bookmark> 40cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RANG" id="bm_id3146778" localize="false"/> 41*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155071" role="heading" level="2" l10n="U">RANK</paragraph> 42*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153976" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_RANG">Returns the rank of a number in a sample.</ahelp></paragraph> 43*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3159206" role="heading" level="3" l10n="U">Syntax</paragraph> 44*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153250" role="code" l10n="U">RANK(Value; Data; Type)</paragraph> 45*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154543" role="paragraph" l10n="U"><emph>Value</emph> is the value, whose rank is to be determined.</paragraph> 46*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149130" role="paragraph" l10n="U"><emph>Data</emph> is the array or range of data in the sample.</paragraph> 47*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150215" role="paragraph" l10n="CHG"><emph>Type</emph> (optional) is the sequence order.</paragraph> 48cdf0e10cSrcweir<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> 49cdf0e10cSrcweir<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> 50*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3143223" role="heading" level="3" l10n="U">Example</paragraph> 51*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155919" role="paragraph" l10n="U"><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> 52cdf0e10cSrcweir</section> 53cdf0e10cSrcweir<section id="skew"> 5488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153556"> 5588cae784Smseidel<bookmark_value>SKEW function</bookmark_value> 56cdf0e10cSrcweir</bookmark> 57cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHIEFE" id="bm_id3153801" localize="false"/> 58*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153556" role="heading" level="2" l10n="U">SKEW</paragraph> 59*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153485" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_SCHIEFE">Returns the skewness of a distribution.</ahelp></paragraph> 60*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154733" role="heading" level="3" l10n="U">Syntax</paragraph> 61*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151191" role="code" l10n="U">SKEW(Number1; Number2; ...Number30)</paragraph> 62*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155757" role="paragraph" l10n="CHG"><emph>Number1, Number2...Number30</emph> are numerical values or ranges.</paragraph> 63*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153297" role="heading" level="3" l10n="U">Example</paragraph> 64*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="U"><item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph> 65cdf0e10cSrcweir</section> 66cdf0e10cSrcweir<section id="forecast"> 6788cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149051"> 6888cae784Smseidel<bookmark_value>regression lines;FORECAST function</bookmark_value> 69cdf0e10cSrcweir<bookmark_value>extrapolations</bookmark_value> 70cdf0e10cSrcweir<bookmark_value>FORECAST function</bookmark_value> 71cdf0e10cSrcweir</bookmark> 72cdf0e10cSrcweir<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> 73*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149051" role="heading" level="2" l10n="U">FORECAST</paragraph> 74*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153290" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph> 75*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3151343" role="heading" level="3" l10n="U">Syntax</paragraph> 76*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3147404" role="code" l10n="U">FORECAST(Value; DataY; DataX)</paragraph> 77*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148743" role="paragraph" l10n="U"><emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph> 78*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3146325" role="paragraph" l10n="U"><emph>DataY</emph> is the array or range of known y's.</paragraph> 79*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150536" role="paragraph" l10n="U"><emph>DataX</emph> is the array or range of known x's.</paragraph> 80*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147416" role="heading" level="3" l10n="U">Example</paragraph> 81*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3157874" role="paragraph" l10n="U"><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> 82cdf0e10cSrcweir</section> 83cdf0e10cSrcweir<section id="stdev"> 8488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149143"> 8588cae784Smseidel<bookmark_value>STDEV function</bookmark_value> 86cdf0e10cSrcweir<bookmark_value>standard deviations in statistics;based on a sample</bookmark_value> 87cdf0e10cSrcweir</bookmark> 88cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABW" id="bm_id3153121" localize="false"/> 89*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="2" l10n="U">STDEV</paragraph> 90*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3146888" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation based on a sample.</ahelp></paragraph> 91*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3146815" role="heading" level="3" l10n="U">Syntax</paragraph> 92*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149946" role="code" l10n="U">STDEV(Number1;Number2;...Number30)</paragraph> 93*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3157904" role="paragraph" l10n="CHG"><emph>Number1, Number2, ... Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> 94*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3150650" role="heading" level="3" l10n="U">Example</paragraph> 95*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149434" role="paragraph" l10n="U"><item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> 96cdf0e10cSrcweir</section> 97cdf0e10cSrcweir<section id="stdeva"> 9888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3144745"> 9988cae784Smseidel<bookmark_value>STDEVA function</bookmark_value> 100cdf0e10cSrcweir</bookmark> 101cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWA" id="bm_id3154846" localize="false"/> 102*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3144745" role="heading" level="2" l10n="U">STDEVA</paragraph> 103*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151234" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation of an estimation based on a sample.</ahelp></paragraph> 104*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3148884" role="heading" level="3" l10n="U">Syntax</paragraph> 105*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3147422" role="code" l10n="U">STDEVA(Value1;Value2;...Value30)</paragraph> 106*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154547" role="paragraph" l10n="CHG"><emph>Value1, Value2, ...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> 107*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155829" role="heading" level="3" l10n="U">Example</paragraph> 108*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148581" role="paragraph" l10n="U"><item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph> 109cdf0e10cSrcweir</section> 110cdf0e10cSrcweir<section id="stdevp"> 11188cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149734"> 11288cae784Smseidel<bookmark_value>STDEVP function</bookmark_value> 113cdf0e10cSrcweir<bookmark_value>standard deviations in statistics;based on a population</bookmark_value> 114cdf0e10cSrcweir</bookmark> 115cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWN" id="bm_id3146139" localize="false"/> 116*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149734" role="heading" level="2" l10n="U">STDEVP</paragraph> 117*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149187" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation based on the entire population.</ahelp></paragraph> 118*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154387" role="heading" level="3" l10n="U">Syntax</paragraph> 119*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154392" role="code" l10n="U">STDEVP(Number1;Number2;...Number30)</paragraph> 120*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155261" role="paragraph" l10n="CHG"><emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> 121*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3" l10n="U">Example</paragraph> 122*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153933" role="paragraph" l10n="U"><item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph> 123cdf0e10cSrcweir</section> 124cdf0e10cSrcweir<section id="stdevpa"> 12588cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154522"> 12688cae784Smseidel<bookmark_value>STDEVPA function</bookmark_value> 127cdf0e10cSrcweir</bookmark> 128cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWNA" id="bm_id3150902" localize="false"/> 129*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154522" role="heading" level="2" l10n="U">STDEVPA</paragraph> 130*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149549" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard deviation based on the entire population.</ahelp></paragraph> 131*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155950" role="heading" level="3" l10n="U">Syntax</paragraph> 132*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3146851" role="code" l10n="U">STDEVPA(Value1;Value2;...Value30)</paragraph> 133*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153109" role="paragraph" l10n="CHG"><emph>Value1,value2,...value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> 134*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154506" role="heading" level="3" l10n="U">Example</paragraph> 135*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3145163" role="paragraph" l10n="U"><item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph> 136cdf0e10cSrcweir</section> 137cdf0e10cSrcweir<section id="standardize"> 13888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155928"> 13988cae784Smseidel<bookmark_value>STANDARDIZE function</bookmark_value> 140cdf0e10cSrcweir<bookmark_value>converting;random variables, into normalized values</bookmark_value> 141cdf0e10cSrcweir</bookmark> 142cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDARDISIERUNG" id="bm_id3148764" localize="false"/> 143*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155928" role="heading" level="2" l10n="U">STANDARDIZE</paragraph> 144*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149883" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STANDARDISIERUNG">Converts a random variable to a normalized value.</ahelp></paragraph> 145*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154330" role="heading" level="3" l10n="U">Syntax</paragraph> 146*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150132" role="code" l10n="U">STANDARDIZE(Number; Mean; StDev)</paragraph> 147*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3159139" role="paragraph" l10n="U"><emph>Number</emph> is the value to be standardized.</paragraph> 148*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3145241" role="paragraph" l10n="U"><emph>Mean</emph> is the arithmetic mean of the distribution.</paragraph> 149*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148874" role="paragraph" l10n="U"><emph>StDev</emph> is the standard deviation of the distribution.</paragraph> 150*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3145351" role="heading" level="3" l10n="U">Example</paragraph> 151*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156067" role="paragraph" l10n="U"><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> 152cdf0e10cSrcweir</section> 153cdf0e10cSrcweir<section id="normsinv"> 15488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3157986"> 15588cae784Smseidel<bookmark_value>NORMSINV function</bookmark_value> 156cdf0e10cSrcweir<bookmark_value>normal distribution;inverse of standard</bookmark_value> 157cdf0e10cSrcweir</bookmark> 158cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMINV" id="bm_id3148389" localize="false"/> 159*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3157986" role="heading" level="2" l10n="U">NORMSINV</paragraph> 160*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151282" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STANDNORMINV">Returns the inverse of the standard normal cumulative distribution.</ahelp></paragraph> 161*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153261" role="heading" level="3" l10n="U">Syntax</paragraph> 162*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154195" role="code" l10n="U">NORMINV(Number)</paragraph> 163*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148772" role="paragraph" l10n="U"><emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph> 164*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3150934" role="heading" level="3" l10n="U">Example</paragraph> 165*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149030" role="paragraph" l10n="U"><item type="input">=NORMSINV(0.908789)</item> returns 1.3333.</paragraph> 166cdf0e10cSrcweir</section> 167cdf0e10cSrcweir<section id="normsdist"> 16888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3147538"> 16988cae784Smseidel<bookmark_value>NORMSDIST function</bookmark_value> 170cdf0e10cSrcweir<bookmark_value>normal distribution;statistics</bookmark_value> 171cdf0e10cSrcweir</bookmark> 172cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMVERT" id="bm_id3145269" localize="false"/> 173*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147538" role="heading" level="2" l10n="U">NORMSDIST</paragraph> 174*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150474" role="paragraph" l10n="CHG"><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> 175cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id8652302" role="paragraph" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph> 176*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155083" role="heading" level="3" l10n="U">Syntax</paragraph> 177*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3158411" role="code" l10n="U">NORMSDIST(Number)</paragraph> 178*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154950" role="paragraph" l10n="CHG"><emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated.</paragraph> 179*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U">Example</paragraph> 180*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155984" role="paragraph" l10n="U"><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> 181cdf0e10cSrcweir</section> 182cdf0e10cSrcweir<section id="slope"> 18388cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3152592"> 18488cae784Smseidel<bookmark_value>SLOPE function</bookmark_value> 185cdf0e10cSrcweir</bookmark> 186cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STEIGUNG" id="bm_id3153716" localize="false"/> 187*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3152592" role="heading" level="2" l10n="U">SLOPE</paragraph> 188*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150386" role="paragraph" l10n="U"><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> 189*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154315" role="heading" level="3" l10n="U">Syntax</paragraph> 190*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149819" role="code" l10n="U">SLOPE(DataY; DataX)</paragraph> 191*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3083446" role="paragraph" l10n="U"><emph>DataY</emph> is the array or matrix of Y data.</paragraph> 192*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3152375" role="paragraph" l10n="U"><emph>DataX</emph> is the array or matrix of X data.</paragraph> 193*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3146061" role="heading" level="3" l10n="U">Example</paragraph> 194*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3152480" role="paragraph" l10n="U"><item type="input">=SLOPE(A1:A50;B1:B50)</item> 195cdf0e10cSrcweir</paragraph> 196cdf0e10cSrcweir</section> 197cdf0e10cSrcweir<section id="steyx"> 19888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155836"> 19988cae784Smseidel<bookmark_value>STEYX function</bookmark_value> 200cdf0e10cSrcweir<bookmark_value>standard errors;statistical functions</bookmark_value> 201cdf0e10cSrcweir</bookmark><comment>mw changed "standard errors"</comment> 202cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STFEHLERYX" id="bm_id3150964" localize="false"/> 203*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155836" role="heading" level="2" l10n="U">STEYX</paragraph> 204*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149446" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_STFEHLERYX">Returns the standard error of the predicted y value for each x in the regression.</ahelp></paragraph> 205*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147562" role="heading" level="3" l10n="U">Syntax</paragraph> 206*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151267" role="code" l10n="U">STEYX(DataY; DataX)</paragraph> 207*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3147313" role="paragraph" l10n="U"><emph>DataY</emph> is the array or matrix of Y data.</paragraph> 208*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156097" role="paragraph" l10n="U"><emph>DataX</emph> is the array or matrix of X data.</paragraph> 209*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3145204" role="heading" level="3" l10n="U">Example</paragraph> 210*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156131" role="paragraph" l10n="U"><item type="input">=STEXY(A1:A50;B1:B50)</item> 211cdf0e10cSrcweir</paragraph> 212cdf0e10cSrcweir</section> 213cdf0e10cSrcweir<section id="devsq"> 21488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150873"> 21588cae784Smseidel<bookmark_value>DEVSQ function</bookmark_value> 216cdf0e10cSrcweir<bookmark_value>sums;of squares of deviations</bookmark_value> 217cdf0e10cSrcweir</bookmark> 218cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMQUADABW" id="bm_id3156317" localize="false"/> 219*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3150873" role="heading" level="2" l10n="U">DEVSQ</paragraph> 220*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154748" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_SUMQUADABW">Returns the sum of squares of deviations based on a sample mean.</ahelp></paragraph> 221*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3156121" role="heading" level="3" l10n="U">Syntax</paragraph> 222*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3146790" role="code" l10n="U">DEVSQ(Number1; Number2; ...Number30)</paragraph> 223*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155995" role="paragraph" l10n="CHG"><emph>Number1, Number2, ...Number30</emph> numerical values or ranges representing a sample.</paragraph> 224*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3150254" role="heading" level="3" l10n="U">Example</paragraph> 225*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149136" role="paragraph" l10n="U"><item type="input">=DEVSQ(A1:A50)</item> 226cdf0e10cSrcweir</paragraph> 227cdf0e10cSrcweir</section> 228cdf0e10cSrcweir<section id="tinv"> 22988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3149579"> 23088cae784Smseidel<bookmark_value>TINV function</bookmark_value> 231cdf0e10cSrcweir<bookmark_value>inverse of t-distribution</bookmark_value> 232cdf0e10cSrcweir</bookmark> 233cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV" id="bm_id3153155" localize="false"/> 234*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149579" role="heading" level="2" l10n="U">TINV</paragraph> 235*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3143232" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_TINV">Returns the inverse of the t-distribution.</ahelp></paragraph> 236*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3155101" role="heading" level="3" l10n="U">Syntax</paragraph> 237*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149289" role="code" l10n="U">TINV(Number; DegreesFreedom)</paragraph> 238*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154070" role="paragraph" l10n="U"><emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph> 239*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155315" role="paragraph" l10n="U"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> 240*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153885" role="heading" level="3" l10n="U">Example</paragraph> 241*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156010" role="paragraph" l10n="CHG"><item type="input">=TINV(0.1;6)</item> returns 1.94</paragraph> 242cdf0e10cSrcweir</section> 243cdf0e10cSrcweir<section id="ttest"> 24488cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154129"> 24588cae784Smseidel<bookmark_value>TTEST function</bookmark_value> 246cdf0e10cSrcweir</bookmark> 247cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST" id="bm_id3153981" localize="false"/> 248*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154129" role="heading" level="2" l10n="U">TTEST</paragraph> 249*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3159184" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_TTEST">Returns the probability associated with a Student's t-Test.</ahelp></paragraph> 250*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147257" role="heading" level="3" l10n="U">Syntax</paragraph> 251*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151175" role="code" l10n="U">TTEST(Data1; Data2; Mode; Type)</paragraph> 252*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U"><emph>Data1</emph> is the dependent array or range of data for the first record.</paragraph> 253*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3145666" role="paragraph" l10n="U"><emph>Data2</emph> is the dependent array or range of data for the second record.</paragraph> 254*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153903" role="paragraph" l10n="U"><emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test.</paragraph> 255*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155327" role="paragraph" l10n="U"><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> 256*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3159342" role="heading" level="3" l10n="U">Example</paragraph> 257*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150119" role="paragraph" l10n="U"><item type="input">=TTEST(A1:A50;B1:B50;2;2)</item> 258cdf0e10cSrcweir</paragraph> 259cdf0e10cSrcweir</section> 260cdf0e10cSrcweir<section id="tdist"> 26188cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154930"> 26288cae784Smseidel<bookmark_value>TDIST function</bookmark_value> 263cdf0e10cSrcweir<bookmark_value>t-distribution</bookmark_value> 264cdf0e10cSrcweir</bookmark> 265cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TVERT" id="bm_id3153095" localize="false"/> 266*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154930" role="heading" level="2" l10n="U">TDIST</paragraph> 267*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153372" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_TVERT">Returns the t-distribution.</ahelp></paragraph> 268*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149911" role="heading" level="3" l10n="U">Syntax</paragraph> 269*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150521" role="code" l10n="U">TDIST(Number; DegreesFreedom; Mode)</paragraph> 270*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3146991" role="paragraph" l10n="U"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph> 271*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148824" role="paragraph" l10n="U"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph> 272*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149340" role="paragraph" l10n="U"><emph>Mode</emph> = 1 returns the one-tailed test, <emph>Mode</emph> = 2 returns the two-tailed test.</paragraph> 273*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3159150" role="heading" level="3" l10n="U">Example</paragraph> 274*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149773" role="paragraph" l10n="U"><item type="input">=TDIST(12;5;1)</item> 275cdf0e10cSrcweir</paragraph> 276cdf0e10cSrcweir</section> 277cdf0e10cSrcweir<section id="var"> 27888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153828"> 27988cae784Smseidel<bookmark_value>VAR function</bookmark_value> 280cdf0e10cSrcweir<bookmark_value>variances</bookmark_value> 281cdf0e10cSrcweir</bookmark> 282cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZ" id="bm_id3154898" localize="false"/> 283*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153828" role="heading" level="2" l10n="U">VAR</paragraph> 284*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3159165" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on a sample.</ahelp></paragraph> 285*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154286" role="heading" level="3" l10n="U">Syntax</paragraph> 286*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153054" role="code" l10n="U">VAR(Number1; Number2; ...Number30)</paragraph> 287*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148938" role="paragraph" l10n="CHG"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph> 288*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147233" role="heading" level="3" l10n="U">Example</paragraph> 289*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153575" role="paragraph" l10n="U"><item type="input">=VAR(A1:A50)</item> 290cdf0e10cSrcweir</paragraph> 291cdf0e10cSrcweir</section> 292cdf0e10cSrcweir<section id="vara"> 29388cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3151045"> 29488cae784Smseidel<bookmark_value>VARA function</bookmark_value> 295cdf0e10cSrcweir</bookmark> 296cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZA" id="bm_id3148473" localize="false"/> 297*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3151045" role="heading" level="2" l10n="U">VARA</paragraph> 298*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3155122" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a sample. The value of text is 0.</ahelp></paragraph> 299*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149176" role="heading" level="3" l10n="U">Syntax</paragraph> 300*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149999" role="code" l10n="U">VARA(Value1; Value2; ...Value30)</paragraph> 301*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3158421" role="paragraph" l10n="CHG"><emph>Value1, Value2,...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph> 302*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149160" role="heading" level="3" l10n="U">Example</paragraph> 303*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154279" role="paragraph" l10n="U"><item type="input">=VARA(A1:A50)</item> 304cdf0e10cSrcweir</paragraph> 305cdf0e10cSrcweir</section> 306cdf0e10cSrcweir<section id="varp"> 30788cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3166441"> 30888cae784Smseidel<bookmark_value>VARP function</bookmark_value> 309cdf0e10cSrcweir</bookmark> 310cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZEN" id="bm_id3152359" localize="false"/> 311*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3166441" role="heading" level="2" l10n="U">VARP</paragraph> 312*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3159199" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on the entire population.</ahelp></paragraph> 313*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3150706" role="heading" level="3" l10n="U">Syntax</paragraph> 314*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3147282" role="code" l10n="U">VARP(Number1; Number2; ...Number30)</paragraph> 315*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149793" role="paragraph" l10n="CHG"><emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph> 316*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3152939" role="heading" level="3" l10n="U">Example</paragraph> 317*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153385" role="paragraph" l10n="U"><item type="input">=VARP(A1:A50)</item> 318cdf0e10cSrcweir</paragraph> 319cdf0e10cSrcweir</section> 320cdf0e10cSrcweir<section id="varpa"> 32188cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153688"> 32288cae784Smseidel<bookmark_value>VARPA function</bookmark_value> 323cdf0e10cSrcweir</bookmark> 324cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZENA" id="bm_id3159276" localize="false"/> 325*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153688" role="heading" level="2" l10n="U">VARPA</paragraph> 326*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149109" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based on the entire population. The value of text is 0.</ahelp></paragraph> 327*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3152880" role="heading" level="3" l10n="U">Syntax</paragraph> 328*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149967" role="code" l10n="U">VARPA(Value1; Value2; ...Value30)</paragraph> 329*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149920" role="paragraph" l10n="CHG"><emph>Value1,value2,...Value30</emph> are values or ranges representing an entire population.</paragraph> 330*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154862" role="heading" level="3" l10n="U">Example</paragraph> 331*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156203" role="paragraph" l10n="U"><item type="input">=VARPA(A1:A50)</item> 332cdf0e10cSrcweir</paragraph> 333cdf0e10cSrcweir</section> 334cdf0e10cSrcweir<section id="permut"> 33588cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3154599"> 33688cae784Smseidel<bookmark_value>PERMUT function</bookmark_value> 337cdf0e10cSrcweir<bookmark_value>number of permutations</bookmark_value> 338cdf0e10cSrcweir</bookmark> 339cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN" id="bm_id3154610" localize="false"/> 340*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3154599" role="heading" level="2" l10n="U">PERMUT</paragraph> 341*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154334" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_VARIATIONEN">Returns the number of permutations for a given number of objects.</ahelp></paragraph> 342*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3149422" role="heading" level="3" l10n="U">Syntax</paragraph> 343*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148466" role="code" l10n="U">PERMUT(Count1; Count2)</paragraph> 344*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3148656" role="paragraph" l10n="U"><emph>Count1</emph> is the total number of objects.</paragraph> 345*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150826" role="paragraph" l10n="U"><emph>Count2</emph> is the number of objects in each permutation.</paragraph> 346*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153351" role="heading" level="3" l10n="U">Example</paragraph> 347*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150424" role="paragraph" l10n="U"><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> 348cdf0e10cSrcweir</section> 349cdf0e10cSrcweir<section id="permutationa"> 35088cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3143276"> 35188cae784Smseidel<bookmark_value>PERMUTATIONA function</bookmark_value> 352cdf0e10cSrcweir</bookmark> 353cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN2" id="bm_id3153531" localize="false"/> 354*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3143276" role="heading" level="2" l10n="U">PERMUTATIONA</paragraph> 355*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3144759" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_VARIATIONEN2">Returns the number of permutations for a given number of objects (repetition allowed).</ahelp></paragraph> 356*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3145598" role="heading" level="3" l10n="U">Syntax</paragraph> 357*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149298" role="code" l10n="U">PERMUTATIONA(Count1; Count2)</paragraph> 358*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156139" role="paragraph" l10n="U"><emph>Count1</emph> is the total number of objects.</paragraph> 359*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149519" role="paragraph" l10n="U"><emph>Count2</emph> is the number of objects in each permutation.</paragraph> 360*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3151382" role="heading" level="3" l10n="U">Example</paragraph> 361*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153949" role="paragraph" l10n="U">How often can 2 objects be selected from a total of 11 objects?</paragraph> 362*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3149233" role="paragraph" l10n="U"><item type="input">=PERMUTATIONA(11;2)</item> returns 121.</paragraph> 363*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3150622" role="paragraph" l10n="U"><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> 364cdf0e10cSrcweir</section> 365cdf0e10cSrcweir<section id="prob"> 36688cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3152952"> 36788cae784Smseidel<bookmark_value>PROB function</bookmark_value> 368cdf0e10cSrcweir</bookmark> 369cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHRSCHBEREICH" id="bm_id3152963" localize="false"/> 370*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3152952" role="heading" level="2" l10n="U">PROB</paragraph> 371*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154110" role="paragraph" l10n="U"><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> 372*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3146810" role="heading" level="3" l10n="U">Syntax</paragraph> 373*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3147330" role="code" l10n="U">PROB(Data; Probability; Start; End)</paragraph> 374*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154573" role="paragraph" l10n="U"><emph>Data</emph> is the array or range of data in the sample.</paragraph> 375*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3156334" role="paragraph" l10n="U"><emph>Probability</emph> is the array or range of the corresponding probabilities.</paragraph> 376*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151107" role="paragraph" l10n="U"><emph>Start</emph> is the start value of the interval whose probabilities are to be summed.</paragraph> 377*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153694" role="paragraph" l10n="U"><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> 378*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3147574" role="heading" level="3" l10n="U">Example</paragraph> 379*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3153666" role="paragraph" l10n="U"><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> 380cdf0e10cSrcweir</section> 381cdf0e10cSrcweir<section id="weibull"> 38288cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150941"> 38388cae784Smseidel<bookmark_value>WEIBULL function</bookmark_value> 384cdf0e10cSrcweir</bookmark> 385cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL" id="bm_id3150405" localize="false"/> 386*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3150941" role="heading" level="2" l10n="U">WEIBULL</paragraph> 387*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154916" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull distribution.</ahelp></paragraph> 388cdf0e10cSrcweir<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> 389cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph" l10n="NEW">If C is 0, WEIBULL calculates the probability density function.</paragraph> 390cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph" l10n="NEW">If C is 1, WEIBULL calculates the cumulative distribution function.</paragraph> 391*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3" l10n="U">Syntax</paragraph> 392*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154478" role="code" l10n="U">WEIBULL(Number; Alpha; Beta; C)</paragraph> 393*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3151317" role="paragraph" l10n="U"><emph>Number</emph> is the value at which to calculate the Weibull distribution.</paragraph> 394*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3158436" role="paragraph" l10n="U"><emph>Alpha</emph> is the shape parameter of the Weibull distribution.</paragraph> 395*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154668" role="paragraph" l10n="U"><emph>Beta</emph> is the scale parameter of the Weibull distribution.</paragraph> 396*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3154825" role="paragraph" l10n="CHG"><emph>C</emph> indicates the type of function.</paragraph> 397*d5240548Smseidel<paragraph xml-lang="en-US" id="hd_id3153794" role="heading" level="3" l10n="U">Example</paragraph> 398*d5240548Smseidel<paragraph xml-lang="en-US" id="par_id3146077" role="paragraph" l10n="U"><item type="input">=WEIBULL(2;1;1;1)</item> returns 0.86.</paragraph> 3996f9008d8SAriel Constenla-Haile<paragraph xml-lang="en-US" id="par_id0305200911372899" role="paragraph" l10n="NEW">See also the <link href="https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_WEIBULL_function">Wiki page</link>.</paragraph> 400cdf0e10cSrcweir</section> 401cdf0e10cSrcweir</sort> 402cdf0e10cSrcweir<section id="relatedtopics"> 403cdf0e10cSrcweir<embed href="text/scalc/01/04060100.xhp#drking"/> 404cdf0e10cSrcweir</section> 405cdf0e10cSrcweir</body> 406cdf0e10cSrcweir</helpdocument> 407