1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2*d1c38b03Smseidel
302dbb15cSAndrew Rist<!--***********************************************************
4*d1c38b03Smseidel *
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
12*d1c38b03Smseidel *
1302dbb15cSAndrew Rist *   http://www.apache.org/licenses/LICENSE-2.0
14*d1c38b03Smseidel *
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.
21*d1c38b03Smseidel *
2202dbb15cSAndrew Rist ***********************************************************-->
2302dbb15cSAndrew Rist
24*d1c38b03Smseidel<helpdocument version="1.0">
25cdf0e10cSrcweir<meta>
26*d1c38b03Smseidel<topic id="textscalc0104060185xml" indexer="include">
27*d1c38b03Smseidel<title xml-lang="en-US" id="tit">Statistical Functions Part Five</title>
28*d1c38b03Smseidel<filename>/text/scalc/01/04060185.xhp</filename>
29*d1c38b03Smseidel</topic>
30*d1c38b03Smseidel</meta>
31*d1c38b03Smseidel<body>
32*d1c38b03Smseidel<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>
33cdf0e10cSrcweir</variable></paragraph>
34cdf0e10cSrcweir<sort order="asc">
35cdf0e10cSrcweir<section id="rank">
36*d1c38b03Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3155071">
37*d1c38b03Smseidel<bookmark_value>RANK function</bookmark_value>
38*d1c38b03Smseidel<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"/>
41cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155071" role="heading" level="2" l10n="U" oldref="2">RANK</paragraph>
42*d1c38b03Smseidel<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>
43*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3159206" role="heading" level="3" l10n="U" oldref="4">Syntax</paragraph>
44*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153250" role="code" l10n="U" oldref="5">RANK(Value; Data; Type)</paragraph>
45*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154543" role="paragraph" l10n="U" oldref="6">
46*d1c38b03Smseidel<emph>Value</emph> is the value, whose rank is to be determined.</paragraph>
47*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149130" role="paragraph" l10n="U" oldref="7">
48*d1c38b03Smseidel<emph>Data</emph> is the array or range of data in the sample.</paragraph>
49*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150215" role="paragraph" l10n="CHG" oldref="8">
50*d1c38b03Smseidel<emph>Type</emph> (optional) is the sequence order.</paragraph>
51*d1c38b03Smseidel<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>
52*d1c38b03Smseidel<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>
53*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3143223" role="heading" level="3" l10n="U" oldref="9">Example</paragraph>
54*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155919" role="paragraph" l10n="U" oldref="10">
55*d1c38b03Smseidel<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>
56*d1c38b03Smseidel</section>
57*d1c38b03Smseidel<section id="skew">
58cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153556"><bookmark_value>SKEW function</bookmark_value>
59cdf0e10cSrcweir</bookmark>
60cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SCHIEFE" id="bm_id3153801" localize="false"/>
61cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153556" role="heading" level="2" l10n="U"
62*d1c38b03Smseideloldref="12">SKEW</paragraph>
63*d1c38b03Smseidel<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>
64*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154733" role="heading" level="3" l10n="U"
65*d1c38b03Smseideloldref="14">Syntax</paragraph>
66*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3151191" role="code" l10n="U" oldref="15">SKEW(Number1; Number2; ...Number30)</paragraph>
67*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155757" role="paragraph" l10n="CHG" oldref="16">
68*d1c38b03Smseidel<emph>Number1, Number2...Number30</emph> are numerical values or ranges.</paragraph>
69*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3153297" role="heading" level="3" l10n="U"
70*d1c38b03Smseideloldref="17">Example</paragraph>
71*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3145118" role="paragraph" l10n="U" oldref="18">
72*d1c38b03Smseidel<item type="input">=SKEW(A1:A50)</item> calculates the value of skew for the data referenced.</paragraph>
73*d1c38b03Smseidel</section>
74*d1c38b03Smseidel<section id="forecast">
75cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149051"><bookmark_value>regression lines;FORECAST function</bookmark_value>
76*d1c38b03Smseidel<bookmark_value>extrapolations</bookmark_value>
77*d1c38b03Smseidel<bookmark_value>FORECAST function</bookmark_value>
78cdf0e10cSrcweir</bookmark>
79cdf0e10cSrcweir<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>
80cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149051" role="heading" level="2" l10n="U"
81*d1c38b03Smseideloldref="20">FORECAST</paragraph>
82*d1c38b03Smseidel<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>
83*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3151343" role="heading" level="3" l10n="U"
84*d1c38b03Smseideloldref="22">Syntax</paragraph>
85*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3147404" role="code" l10n="U" oldref="23">FORECAST(Value; DataY; DataX)</paragraph>
86*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148743" role="paragraph" l10n="U" oldref="24">
87*d1c38b03Smseidel<emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph>
88*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3146325" role="paragraph" l10n="U" oldref="25">
89*d1c38b03Smseidel<emph>DataY</emph> is the array or range of known y's.</paragraph>
90*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150536" role="paragraph" l10n="U" oldref="26">
91*d1c38b03Smseidel<emph>DataX</emph> is the array or range of known x's.</paragraph>
92*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3147416" role="heading" level="3" l10n="U"
93*d1c38b03Smseideloldref="27">Example</paragraph>
94*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3157874" role="paragraph" l10n="U" oldref="28">
95*d1c38b03Smseidel<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>
96*d1c38b03Smseidel</section>
97*d1c38b03Smseidel<section id="stdev">
98cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value>
99*d1c38b03Smseidel<bookmark_value>standard deviations in statistics;based on a sample</bookmark_value>
100cdf0e10cSrcweir</bookmark>
101cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABW" id="bm_id3153121" localize="false"/>
102cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149143" role="heading" level="2" l10n="U"
103*d1c38b03Smseideloldref="30">STDEV</paragraph>
104*d1c38b03Smseidel<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>
105*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3146815" role="heading" level="3" l10n="U"
106*d1c38b03Smseideloldref="32">Syntax</paragraph>
107*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149946" role="code" l10n="U" oldref="33">STDEV(Number1;Number2;...Number30)</paragraph>
108*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3157904" role="paragraph" l10n="CHG" oldref="34">
109*d1c38b03Smseidel<emph>Number1, Number2, ... Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
110*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3150650" role="heading" level="3" l10n="U"
111*d1c38b03Smseideloldref="35">Example</paragraph>
112*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149434" role="paragraph" l10n="U" oldref="36">
113*d1c38b03Smseidel<item type="input">=STDEV(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph>
114*d1c38b03Smseidel</section>
115*d1c38b03Smseidel<section id="stdeva">
116cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value>
117cdf0e10cSrcweir</bookmark>
118cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWA" id="bm_id3154846" localize="false"/>
119cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3144745" role="heading" level="2" l10n="U"
120*d1c38b03Smseideloldref="186">STDEVA</paragraph>
121*d1c38b03Smseidel<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>
122*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3148884" role="heading" level="3" l10n="U"
123*d1c38b03Smseideloldref="188">Syntax</paragraph>
124*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3147422" role="code" l10n="U" oldref="189">STDEVA(Value1;Value2;...Value30)</paragraph>
125*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154547" role="paragraph" l10n="CHG" oldref="190">
126*d1c38b03Smseidel<emph>Value1, Value2, ...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
127*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3155829" role="heading" level="3" l10n="U"
128*d1c38b03Smseideloldref="191">Example</paragraph>
129*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148581" role="paragraph" l10n="U" oldref="192">
130*d1c38b03Smseidel<item type="input">=STDEVA(A1:A50)</item> returns the estimated standard deviation based on the data referenced.</paragraph>
131*d1c38b03Smseidel</section>
132*d1c38b03Smseidel<section id="stdevp">
133cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149734"><bookmark_value>STDEVP function</bookmark_value>
134*d1c38b03Smseidel<bookmark_value>standard deviations in statistics;based on a population</bookmark_value>
135cdf0e10cSrcweir</bookmark>
136cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWN" id="bm_id3146139" localize="false"/>
137cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149734" role="heading" level="2" l10n="U"
138*d1c38b03Smseideloldref="38">STDEVP</paragraph>
139*d1c38b03Smseidel<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>
140*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154387" role="heading" level="3" l10n="U"
141*d1c38b03Smseideloldref="40">Syntax</paragraph>
142*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154392" role="code" l10n="U" oldref="41">STDEVP(Number1;Number2;...Number30)</paragraph>
143*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155261" role="paragraph" l10n="CHG" oldref="42">
144*d1c38b03Smseidel<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
145*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3" l10n="U"
146*d1c38b03Smseideloldref="43">Example</paragraph>
147*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153933" role="paragraph" l10n="U" oldref="44">
148*d1c38b03Smseidel<item type="input">=STDEVP(A1:A50)</item> returns a standard deviation of the data referenced.</paragraph>
149*d1c38b03Smseidel</section>
150*d1c38b03Smseidel<section id="stdevpa">
151cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154522"><bookmark_value>STDEVPA function</bookmark_value>
152cdf0e10cSrcweir</bookmark>
153cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STABWNA" id="bm_id3150902" localize="false"/>
154cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154522" role="heading" level="2" l10n="U"
155*d1c38b03Smseideloldref="194">STDEVPA</paragraph>
156*d1c38b03Smseidel<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>
157*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3155950" role="heading" level="3" l10n="U"
158*d1c38b03Smseideloldref="196">Syntax</paragraph>
159*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3146851" role="code" l10n="U" oldref="197">STDEVPA(Value1;Value2;...Value30)</paragraph>
160*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153109" role="paragraph" l10n="CHG" oldref="198">
161*d1c38b03Smseidel<emph>Value1,value2,...value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
162*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154506" role="heading" level="3" l10n="U"
163*d1c38b03Smseideloldref="199">Example</paragraph>
164*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3145163" role="paragraph" l10n="U" oldref="200">
165*d1c38b03Smseidel<item type="input">=STDEVPA(A1:A50)</item> returns the standard deviation of the data referenced.</paragraph>
166*d1c38b03Smseidel</section>
167*d1c38b03Smseidel<section id="standardize">
168cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3155928"><bookmark_value>STANDARDIZE function</bookmark_value>
169*d1c38b03Smseidel<bookmark_value>converting;random variables, into normalized values</bookmark_value>
170cdf0e10cSrcweir</bookmark>
171cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDARDISIERUNG" id="bm_id3148764" localize="false"/>
172cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155928" role="heading" level="2" l10n="U"
173*d1c38b03Smseideloldref="46">STANDARDIZE</paragraph>
174*d1c38b03Smseidel<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>
175*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154330" role="heading" level="3" l10n="U"
176*d1c38b03Smseideloldref="48">Syntax</paragraph>
177*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150132" role="code" l10n="U" oldref="49">STANDARDIZE(Number; Mean; StDev)</paragraph>
178*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3159139" role="paragraph" l10n="U" oldref="50">
179*d1c38b03Smseidel<emph>Number</emph> is the value to be standardized.</paragraph>
180*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3145241" role="paragraph" l10n="U" oldref="51">
181*d1c38b03Smseidel<emph>Mean</emph> is the arithmetic mean of the distribution.</paragraph>
182*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148874" role="paragraph" l10n="U" oldref="52">
183*d1c38b03Smseidel<emph>StDev</emph> is the standard deviation of the distribution.</paragraph>
184*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3145351" role="heading" level="3" l10n="U"
185*d1c38b03Smseideloldref="53">Example</paragraph>
186*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156067" role="paragraph" l10n="U" oldref="54">
187*d1c38b03Smseidel<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>
188*d1c38b03Smseidel</section>
189*d1c38b03Smseidel<section id="normsinv">
190cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3157986"><bookmark_value>NORMSINV function</bookmark_value>
191*d1c38b03Smseidel<bookmark_value>normal distribution;inverse of standard</bookmark_value>
192cdf0e10cSrcweir</bookmark>
193cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMINV" id="bm_id3148389" localize="false"/>
194cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3157986" role="heading" level="2" l10n="U"
195*d1c38b03Smseideloldref="56">NORMSINV</paragraph>
196*d1c38b03Smseidel<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>
197*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3153261" role="heading" level="3" l10n="U"
198*d1c38b03Smseideloldref="58">Syntax</paragraph>
199*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154195" role="code" l10n="U" oldref="59">NORMINV(Number)</paragraph>
200*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148772" role="paragraph" l10n="U" oldref="60">
201*d1c38b03Smseidel<emph>Number</emph> is the probability to which the inverse standard normal distribution is calculated.</paragraph>
202*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3150934" role="heading" level="3" l10n="U"
203*d1c38b03Smseideloldref="61">Example</paragraph>
204*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149030" role="paragraph" l10n="U" oldref="62">
205*d1c38b03Smseidel<item type="input">=NORMSINV(0.908789)</item> returns 1.3333.</paragraph>
206*d1c38b03Smseidel</section>
207*d1c38b03Smseidel<section id="normsdist">
208cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3147538"><bookmark_value>NORMSDIST function</bookmark_value>
209*d1c38b03Smseidel<bookmark_value>normal distribution;statistics</bookmark_value>
210cdf0e10cSrcweir</bookmark>
211cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STANDNORMVERT" id="bm_id3145269" localize="false"/>
212cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3147538" role="heading" level="2" l10n="U"
213*d1c38b03Smseideloldref="64">NORMSDIST</paragraph>
214*d1c38b03Smseidel<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>
215*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id8652302" role="paragraph" l10n="NEW">It is GAUSS(x)=NORMSDIST(x)-0.5</paragraph>
216*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3155083" role="heading" level="3" l10n="U"
217*d1c38b03Smseideloldref="66">Syntax</paragraph>
218*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3158411" role="code" l10n="U" oldref="67">NORMSDIST(Number)</paragraph>
219*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154950" role="paragraph" l10n="CHG" oldref="68">
220*d1c38b03Smseidel<emph>Number</emph> is the value to which the standard normal cumulative distribution is calculated.</paragraph>
221*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U"
222*d1c38b03Smseideloldref="69">Example</paragraph>
223*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155984" role="paragraph" l10n="U" oldref="70">
224*d1c38b03Smseidel<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>
225*d1c38b03Smseidel</section>
226*d1c38b03Smseidel<section id="slope">
227cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3152592"><bookmark_value>SLOPE function</bookmark_value>
228cdf0e10cSrcweir</bookmark>
229cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STEIGUNG" id="bm_id3153716" localize="false"/>
230cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3152592" role="heading" level="2" l10n="U"
231*d1c38b03Smseideloldref="72">SLOPE</paragraph>
232*d1c38b03Smseidel<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>
233*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154315" role="heading" level="3" l10n="U"
234*d1c38b03Smseideloldref="74">Syntax</paragraph>
235*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149819" role="code" l10n="U" oldref="75">SLOPE(DataY; DataX)</paragraph>
236*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3083446" role="paragraph" l10n="U" oldref="76">
237*d1c38b03Smseidel<emph>DataY</emph> is the array or matrix of Y data.</paragraph>
238*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3152375" role="paragraph" l10n="U" oldref="77">
239*d1c38b03Smseidel<emph>DataX</emph> is the array or matrix of X data.</paragraph>
240*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3146061" role="heading" level="3" l10n="U"
241*d1c38b03Smseideloldref="78">Example</paragraph>
242*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3152480" role="paragraph" l10n="U" oldref="79">
243*d1c38b03Smseidel<item type="input">=SLOPE(A1:A50;B1:B50)</item>
244*d1c38b03Smseidel</paragraph>
245*d1c38b03Smseidel</section>
246*d1c38b03Smseidel<section id="steyx">
247cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3155836"><bookmark_value>STEYX function</bookmark_value>
248*d1c38b03Smseidel<bookmark_value>standard errors;statistical functions</bookmark_value>
249cdf0e10cSrcweir</bookmark><comment>mw changed "standard errors"</comment>
250cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STFEHLERYX" id="bm_id3150964" localize="false"/>
251cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3155836" role="heading" level="2" l10n="U"
252*d1c38b03Smseideloldref="81">STEYX</paragraph>
253*d1c38b03Smseidel<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>
254*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3147562" role="heading" level="3" l10n="U"
255*d1c38b03Smseideloldref="83">Syntax</paragraph>
256*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3151267" role="code" l10n="U" oldref="84">STEYX(DataY; DataX)</paragraph>
257*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3147313" role="paragraph" l10n="U" oldref="85">
258*d1c38b03Smseidel<emph>DataY</emph> is the array or matrix of Y data.</paragraph>
259*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156097" role="paragraph" l10n="U" oldref="86">
260*d1c38b03Smseidel<emph>DataX</emph> is the array or matrix of X data.</paragraph>
261*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3145204" role="heading" level="3" l10n="U"
262*d1c38b03Smseideloldref="87">Example</paragraph>
263*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156131" role="paragraph" l10n="U" oldref="88">
264*d1c38b03Smseidel<item type="input">=STEXY(A1:A50;B1:B50)</item>
265*d1c38b03Smseidel</paragraph>
266*d1c38b03Smseidel</section>
267*d1c38b03Smseidel<section id="devsq">
268cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150873"><bookmark_value>DEVSQ function</bookmark_value>
269*d1c38b03Smseidel<bookmark_value>sums;of squares of deviations</bookmark_value>
270cdf0e10cSrcweir</bookmark>
271cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMQUADABW" id="bm_id3156317" localize="false"/>
272cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3150873" role="heading" level="2" l10n="U"
273*d1c38b03Smseideloldref="90">DEVSQ</paragraph>
274*d1c38b03Smseidel<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>
275*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3156121" role="heading" level="3" l10n="U"
276*d1c38b03Smseideloldref="92">Syntax</paragraph>
277*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3146790" role="code" l10n="U" oldref="93">DEVSQ(Number1; Number2; ...Number30)</paragraph>
278*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155995" role="paragraph" l10n="CHG" oldref="94">
279*d1c38b03Smseidel<emph>Number1, Number2, ...Number30</emph> numerical values or ranges representing a sample. </paragraph>
280*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3150254" role="heading" level="3" l10n="U"
281*d1c38b03Smseideloldref="95">Example</paragraph>
282*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149136" role="paragraph" l10n="U" oldref="96">
283*d1c38b03Smseidel<item type="input">=DEVSQ(A1:A50)</item>
284*d1c38b03Smseidel</paragraph>
285*d1c38b03Smseidel</section>
286*d1c38b03Smseidel<section id="tinv">
287cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3149579"><bookmark_value>TINV function</bookmark_value>
288*d1c38b03Smseidel<bookmark_value>inverse of t-distribution</bookmark_value>
289cdf0e10cSrcweir</bookmark>
290cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV" id="bm_id3153155" localize="false"/>
291cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3149579" role="heading" level="2" l10n="U"
292*d1c38b03Smseideloldref="98">TINV</paragraph>
293*d1c38b03Smseidel<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>
294*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3155101" role="heading" level="3" l10n="U"
295*d1c38b03Smseideloldref="100">Syntax</paragraph>
296*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149289" role="code" l10n="U" oldref="101">TINV(Number; DegreesFreedom)</paragraph>
297*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154070" role="paragraph" l10n="U" oldref="102">
298*d1c38b03Smseidel<emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph>
299*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155315" role="paragraph" l10n="U" oldref="103">
300*d1c38b03Smseidel<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
301*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3153885" role="heading" level="3" l10n="U"
302*d1c38b03Smseideloldref="104">Example</paragraph>
303*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156010" role="paragraph" l10n="CHG" oldref="105">
304*d1c38b03Smseidel<item type="input">=TINV(0.1;6)</item> returns 1.94</paragraph>
305*d1c38b03Smseidel</section>
306*d1c38b03Smseidel<section id="ttest">
307cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value>
308cdf0e10cSrcweir</bookmark>
309cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST" id="bm_id3153981" localize="false"/>
310cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154129" role="heading" level="2" l10n="U"
311*d1c38b03Smseideloldref="107">TTEST</paragraph>
312*d1c38b03Smseidel<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>
313*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3147257" role="heading" level="3" l10n="U"
314*d1c38b03Smseideloldref="109">Syntax</paragraph>
315*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3151175" role="code" l10n="U" oldref="110">TTEST(Data1; Data2; Mode; Type)</paragraph>
316*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149202" role="paragraph" l10n="U" oldref="111">
317*d1c38b03Smseidel<emph>Data1</emph> is the dependent array or range of data for the first record.</paragraph>
318*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3145666" role="paragraph" l10n="U" oldref="112">
319*d1c38b03Smseidel<emph>Data2</emph> is the dependent array or range of data for the second record.</paragraph>
320*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153903" role="paragraph" l10n="U" oldref="113">
321*d1c38b03Smseidel<emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test.</paragraph>
322*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3155327" role="paragraph" l10n="U" oldref="114">
323*d1c38b03Smseidel<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>
324*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3159342" role="heading" level="3" l10n="U"
325*d1c38b03Smseideloldref="115">Example</paragraph>
326*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150119" role="paragraph" l10n="U" oldref="116">
327*d1c38b03Smseidel<item type="input">=TTEST(A1:A50;B1:B50;2;2)</item>
328*d1c38b03Smseidel</paragraph>
329*d1c38b03Smseidel</section>
330*d1c38b03Smseidel<section id="tdist">
331cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value>
332*d1c38b03Smseidel<bookmark_value>t-distribution</bookmark_value>
333cdf0e10cSrcweir</bookmark>
334cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TVERT" id="bm_id3153095" localize="false"/>
335cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154930" role="heading" level="2" l10n="U"
336*d1c38b03Smseideloldref="118">TDIST</paragraph>
337*d1c38b03Smseidel<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>
338*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3149911" role="heading" level="3" l10n="U"
339*d1c38b03Smseideloldref="120">Syntax</paragraph>
340*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150521" role="code" l10n="U" oldref="121">TDIST(Number; DegreesFreedom; Mode)</paragraph>
341*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3146991" role="paragraph" l10n="U" oldref="122">
342*d1c38b03Smseidel<emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
343*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148824" role="paragraph" l10n="U" oldref="123">
344*d1c38b03Smseidel<emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
345*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149340" role="paragraph" l10n="U" oldref="124">
346*d1c38b03Smseidel<emph>Mode</emph> = 1 returns the one-tailed test, <emph>Mode</emph> = 2 returns the two-tailed test.</paragraph>
347*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3159150" role="heading" level="3" l10n="U"
348*d1c38b03Smseideloldref="125">Example</paragraph>
349*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149773" role="paragraph" l10n="U" oldref="126">
350*d1c38b03Smseidel<item type="input">=TDIST(12;5;1)</item>
351*d1c38b03Smseidel</paragraph>
352*d1c38b03Smseidel</section>
353*d1c38b03Smseidel<section id="var">
354cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153828"><bookmark_value>VAR function</bookmark_value>
355*d1c38b03Smseidel<bookmark_value>variances</bookmark_value>
356cdf0e10cSrcweir</bookmark>
357cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZ" id="bm_id3154898" localize="false"/>
358cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153828" role="heading" level="2" l10n="U"
359*d1c38b03Smseideloldref="128">VAR</paragraph>
360*d1c38b03Smseidel<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>
361*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154286" role="heading" level="3" l10n="U"
362*d1c38b03Smseideloldref="130">Syntax</paragraph>
363*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153054" role="code" l10n="U" oldref="131">VAR(Number1; Number2; ...Number30)</paragraph>
364*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148938" role="paragraph" l10n="CHG" oldref="132">
365*d1c38b03Smseidel<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population.</paragraph>
366*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3147233" role="heading" level="3" l10n="U"
367*d1c38b03Smseideloldref="133">Example</paragraph>
368*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153575" role="paragraph" l10n="U" oldref="134">
369*d1c38b03Smseidel<item type="input">=VAR(A1:A50)</item>
370*d1c38b03Smseidel</paragraph>
371*d1c38b03Smseidel</section>
372*d1c38b03Smseidel<section id="vara">
373cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3151045"><bookmark_value>VARA function</bookmark_value>
374cdf0e10cSrcweir</bookmark>
375cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZA" id="bm_id3148473" localize="false"/>
376cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3151045" role="heading" level="2" l10n="U"
377*d1c38b03Smseideloldref="202">VARA</paragraph>
378*d1c38b03Smseidel<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>
379*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3149176" role="heading" level="3" l10n="U"
380*d1c38b03Smseideloldref="204">Syntax</paragraph>
381*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149999" role="code" l10n="U" oldref="205">VARA(Value1; Value2; ...Value30)</paragraph>
382*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3158421" role="paragraph" l10n="CHG" oldref="206">
383*d1c38b03Smseidel<emph>Value1, Value2,...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0.</paragraph>
384*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3149160" role="heading" level="3" l10n="U"
385*d1c38b03Smseideloldref="207">Example</paragraph>
386*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154279" role="paragraph" l10n="U" oldref="208">
387*d1c38b03Smseidel<item type="input">=VARA(A1:A50)</item>
388*d1c38b03Smseidel</paragraph>
389*d1c38b03Smseidel</section>
390*d1c38b03Smseidel<section id="varp">
391cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3166441"><bookmark_value>VARP function</bookmark_value>
392cdf0e10cSrcweir</bookmark>
393cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZEN" id="bm_id3152359" localize="false"/>
394cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3166441" role="heading" level="2" l10n="U"
395*d1c38b03Smseideloldref="136">VARP</paragraph>
396*d1c38b03Smseidel<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>
397*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3150706" role="heading" level="3" l10n="U"
398*d1c38b03Smseideloldref="138">Syntax</paragraph>
399*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3147282" role="code" l10n="U" oldref="139">VARP(Number1; Number2; ...Number30)</paragraph>
400*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149793" role="paragraph" l10n="CHG" oldref="140">
401*d1c38b03Smseidel<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population.</paragraph>
402*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3152939" role="heading" level="3" l10n="U"
403*d1c38b03Smseideloldref="141">Example</paragraph>
404*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153385" role="paragraph" l10n="U" oldref="142">
405*d1c38b03Smseidel<item type="input">=VARP(A1:A50)</item>
406*d1c38b03Smseidel</paragraph>
407*d1c38b03Smseidel</section>
408*d1c38b03Smseidel<section id="varpa">
409cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153688"><bookmark_value>VARPA function</bookmark_value>
410cdf0e10cSrcweir</bookmark>
411cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIANZENA" id="bm_id3159276" localize="false"/>
412cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3153688" role="heading" level="2" l10n="U"
413*d1c38b03Smseideloldref="210">VARPA</paragraph>
414*d1c38b03Smseidel<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>
415*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3152880" role="heading" level="3" l10n="U"
416*d1c38b03Smseideloldref="212">Syntax</paragraph>
417*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149967" role="code" l10n="U" oldref="213">VARPA(Value1; Value2; ...Value30)</paragraph>
418*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149920" role="paragraph" l10n="CHG" oldref="214">
419*d1c38b03Smseidel<emph>Value1,value2,...Value30</emph> are values or ranges representing an entire population.</paragraph>
420*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3154862" role="heading" level="3" l10n="U"
421*d1c38b03Smseideloldref="215">Example</paragraph>
422*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156203" role="paragraph" l10n="U" oldref="216">
423*d1c38b03Smseidel<item type="input">=VARPA(A1:A50)</item>
424*d1c38b03Smseidel</paragraph>
425*d1c38b03Smseidel</section>
426*d1c38b03Smseidel<section id="permut">
427cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154599"><bookmark_value>PERMUT function</bookmark_value>
428*d1c38b03Smseidel<bookmark_value>number of permutations</bookmark_value>
429cdf0e10cSrcweir</bookmark>
430cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN" id="bm_id3154610" localize="false"/>
431cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3154599" role="heading" level="2" l10n="U"
432*d1c38b03Smseideloldref="144">PERMUT</paragraph>
433*d1c38b03Smseidel<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>
434*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3149422" role="heading" level="3" l10n="U"
435*d1c38b03Smseideloldref="146">Syntax</paragraph>
436*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148466" role="code" l10n="U" oldref="147">PERMUT(Count1; Count2)</paragraph>
437*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3148656" role="paragraph" l10n="U" oldref="148">
438*d1c38b03Smseidel<emph>Count1</emph> is the total number of objects.</paragraph>
439*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150826" role="paragraph" l10n="U" oldref="149">
440*d1c38b03Smseidel<emph>Count2</emph> is the number of objects in each permutation.</paragraph>
441*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3153351" role="heading" level="3" l10n="U"
442*d1c38b03Smseideloldref="150">Example</paragraph>
443*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150424" role="paragraph" l10n="U" oldref="151">
444*d1c38b03Smseidel<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>
445*d1c38b03Smseidel</section>
446*d1c38b03Smseidel<section id="permutationa">
447cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3143276"><bookmark_value>PERMUTATIONA function</bookmark_value>
448cdf0e10cSrcweir</bookmark>
449cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATIONEN2" id="bm_id3153531" localize="false"/>
450cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3143276" role="heading" level="2" l10n="U"
451*d1c38b03Smseideloldref="153">PERMUTATIONA</paragraph>
452*d1c38b03Smseidel<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>
453*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3145598" role="heading" level="3" l10n="U"
454*d1c38b03Smseideloldref="155">Syntax</paragraph>
455*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149298" role="code" l10n="U" oldref="156">PERMUTATIONA(Count1; Count2)</paragraph>
456*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156139" role="paragraph" l10n="U" oldref="157">
457*d1c38b03Smseidel<emph>Count1</emph> is the total number of objects.</paragraph>
458*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149519" role="paragraph" l10n="U" oldref="158">
459*d1c38b03Smseidel<emph>Count2</emph> is the number of objects in each permutation.</paragraph>
460*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3151382" role="heading" level="3" l10n="U"
461*d1c38b03Smseideloldref="159">Example</paragraph>
462*d1c38b03Smseidel<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>
463*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3149233" role="paragraph" l10n="U" oldref="161">
464*d1c38b03Smseidel<item type="input">=PERMUTATIONA(11;2)</item> returns 121.</paragraph>
465*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3150622" role="paragraph" l10n="U" oldref="162">
466*d1c38b03Smseidel<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>
467*d1c38b03Smseidel</section>
468*d1c38b03Smseidel<section id="prob">
469cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3152952"><bookmark_value>PROB function</bookmark_value>
470cdf0e10cSrcweir</bookmark>
471cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHRSCHBEREICH" id="bm_id3152963" localize="false"/>
472cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3152952" role="heading" level="2" l10n="U"
473*d1c38b03Smseideloldref="164">PROB</paragraph>
474*d1c38b03Smseidel<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>
475*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3146810" role="heading" level="3" l10n="U"
476*d1c38b03Smseideloldref="166">Syntax</paragraph>
477*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3147330" role="code" l10n="U" oldref="167">PROB(Data; Probability; Start; End)</paragraph>
478*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154573" role="paragraph" l10n="U" oldref="168">
479*d1c38b03Smseidel<emph>Data</emph> is the array or range of data in the sample.</paragraph>
480*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3156334" role="paragraph" l10n="U" oldref="169">
481*d1c38b03Smseidel<emph>Probability</emph> is the array or range of the corresponding probabilities.</paragraph>
482*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3151107" role="paragraph" l10n="U" oldref="170">
483*d1c38b03Smseidel<emph>Start</emph> is the start value of the interval whose probabilities are to be summed.</paragraph>
484*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153694" role="paragraph" l10n="U" oldref="171">
485*d1c38b03Smseidel<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>
486*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3147574" role="heading" level="3" l10n="U"
487*d1c38b03Smseideloldref="172">Example</paragraph>
488*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3153666" role="paragraph" l10n="U" oldref="173">
489*d1c38b03Smseidel<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>
490*d1c38b03Smseidel</section>
491*d1c38b03Smseidel<section id="weibull">
492cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3150941"><bookmark_value>WEIBULL function</bookmark_value>
493cdf0e10cSrcweir</bookmark>
494cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WEIBULL" id="bm_id3150405" localize="false"/>
495cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id3150941" role="heading" level="2" l10n="U"
496*d1c38b03Smseideloldref="175">WEIBULL</paragraph>
497*d1c38b03Smseidel<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>
498*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph" l10n="NEW">The Weibull distribution is a continuous probability distribution, with parameters Alpha &gt; 0 (shape) and Beta &gt; 0 (scale). </paragraph>
499*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph" l10n="NEW">If C is 0, WEIBULL calculates the probability density function.</paragraph>
500*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph" l10n="NEW">If C is 1, WEIBULL calculates the cumulative distribution function.</paragraph>
501*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3" l10n="U"
502*d1c38b03Smseideloldref="177">Syntax</paragraph>
503*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154478" role="code" l10n="U" oldref="178">WEIBULL(Number; Alpha; Beta; C)</paragraph>
504*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3151317" role="paragraph" l10n="U" oldref="179">
505*d1c38b03Smseidel<emph>Number</emph> is the value at which to calculate the Weibull distribution.</paragraph>
506*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3158436" role="paragraph" l10n="U" oldref="180">
507*d1c38b03Smseidel<emph>Alpha </emph>is the shape parameter of the Weibull distribution.</paragraph>
508*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154668" role="paragraph" l10n="U" oldref="181">
509*d1c38b03Smseidel<emph>Beta</emph> is the scale parameter of the Weibull distribution.</paragraph>
510*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3154825" role="paragraph" l10n="CHG" oldref="182">
511*d1c38b03Smseidel<emph>C</emph> indicates the type of function.</paragraph>
512*d1c38b03Smseidel<paragraph xml-lang="en-US" id="hd_id3153794" role="heading" level="3" l10n="U"
513*d1c38b03Smseideloldref="183">Example</paragraph>
514*d1c38b03Smseidel<paragraph xml-lang="en-US" id="par_id3146077" role="paragraph" l10n="U" oldref="184">
515*d1c38b03Smseidel<item type="input">=WEIBULL(2;1;1;1)</item> returns 0.86.</paragraph>
516*d1c38b03Smseidel<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>
517*d1c38b03Smseidel</section>
518cdf0e10cSrcweir</sort>
519cdf0e10cSrcweir<section id="relatedtopics">
520*d1c38b03Smseidel<embed href="text/scalc/01/04060100.xhp#drking"/>
521*d1c38b03Smseidel</section>
522*d1c38b03Smseidel</body>
523*d1c38b03Smseidel</helpdocument>
524