1 files changed, 369 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060181.xhp b/helpcontent2/source/text/scalc/01/04060181.xhp
new file mode 100755
index 0000000000..2b05d6d9e2
--- /dev/null
+++ b/helpcontent2/source/text/scalc/01/04060181.xhp
@@ -0,0 +1,369 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  either of the following licenses
+ *
+ *         - GNU Lesser General Public License Version 2.1
+ *         - Sun Industry Standards Source License Version 1.1
+ *
+ *  Sun Microsystems Inc., October, 2000
+ *
+ *  GNU Lesser General Public License Version 2.1
+ *  =============================================
+ *  Copyright 2000 by Sun Microsystems, Inc.
+ *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ *  This library is free software; you can redistribute it and/or
+ *  modify it under the terms of the GNU Lesser General Public
+ *  License version 2.1, as published by the Free Software Foundation.
+ *
+ *  This library is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *  Lesser General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Lesser General Public
+ *  License along with this library; if not, write to the Free Software
+ *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *  MA  02111-1307  USA
+ *
+ *
+ *  Sun Industry Standards Source License Version 1.1
+ *  =================================================
+ *  The contents of this file are subject to the Sun Industry Standards
+ *  Source License Version 1.1 (the "License"); You may not use this file
+ *  except in compliance with the License. You may obtain a copy of the
+ *  License at http://www.openoffice.org/license.html.
+ *
+ *  Software provided under this License is provided on an "AS IS" basis,
+ *  WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ *  WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ *  See the License for the specific provisions governing your rights and
+ *  obligations concerning the Software.
+ *
+ *  The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ *  Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ *  All Rights Reserved.
+ *
+ *  Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+	
+<helpdocument version="1.0">
+<meta>
+<topic id="textscalc0104060181xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Statistical Functions Part One</title>
+<filename>/text/scalc/01/04060181.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-08-10T10:49:59">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<paragraph role="heading" id="hd_id3146320" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="ae"><link href="text/scalc/01/04060181.xhp">Statistical Functions Part One</link>
+</variable></paragraph>
+<sort order="asc">
+<section id="intercept">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145632"><bookmark_value>INTERCEPT function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ACHSENABSCHNITT" id="bm_id3153018" localize="false"/>
+<paragraph role="heading" id="hd_id3145632" xml-lang="en-US" level="2" l10n="U" oldref="2">INTERCEPT</paragraph>
+<paragraph role="paragraph" id="par_id3146887" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_ACHSENABSCHNITT">Calculates the point at which a line will intersect the y-values by using known x-values and y-values.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150374" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3149718" xml-lang="en-US" l10n="U" oldref="5">INTERCEPT(data_Y; data_X)</paragraph>
+<paragraph role="paragraph" id="par_id3149947" xml-lang="en-US" l10n="U" oldref="6">
+<emph>Data_Y</emph> is the dependent set of observations or data.</paragraph>
+<paragraph role="paragraph" id="par_id3147412" xml-lang="en-US" l10n="U" oldref="7">
+<emph>Data_X</emph> is the independent set of observations or data.</paragraph>
+<paragraph role="paragraph" id="par_id3152983" xml-lang="en-US" l10n="U" oldref="8">Names, arrays or references containing numbers must be used here. Numbers can also be entered directly.</paragraph>
+<paragraph role="heading" id="hd_id3157906" xml-lang="en-US" level="3" l10n="U" oldref="9">Example</paragraph>
+<paragraph role="paragraph" id="par_id3148728" xml-lang="en-US" l10n="U" oldref="10">To calculate the intercept, use cells D3:D9 as the y value and C3:C9 as the x value from the example spreadsheet. Input will be as follows:</paragraph>
+<paragraph role="paragraph" id="par_id3149013" xml-lang="en-US" l10n="U" oldref="11">INTERCEPT(D3:D9;C3:C9) = 2.15.</paragraph>
+</section>
+<section id="count">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148437"><bookmark_value>COUNT function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/>
+<paragraph role="heading" id="hd_id3148437" xml-lang="en-US" level="2" l10n="U" oldref="13">COUNT</paragraph>
+<paragraph role="paragraph" id="par_id3150700" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph>
+<paragraph role="heading" id="hd_id3153930" xml-lang="en-US" level="3" l10n="U" oldref="15">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3148585" xml-lang="en-US" l10n="U" oldref="16">COUNT(value1; value2; ... value30)</paragraph>
+<paragraph role="paragraph" id="par_id3155827" xml-lang="en-US" l10n="CHG" oldref="17">
+<emph>Value1; value2, ...</emph> are 1 to 30 values or ranges representing the values to be counted.</paragraph>
+<paragraph role="heading" id="hd_id3149254" xml-lang="en-US" level="3" l10n="U" oldref="18">Example</paragraph>
+<paragraph role="paragraph" id="par_id3149953" xml-lang="en-US" l10n="U" oldref="19">The entries <emph>2, 4, 6</emph> and <emph>eight</emph> in the <emph>value 1 - 4</emph> fields are to be counted.</paragraph>
+<paragraph role="paragraph" id="par_id3154558" xml-lang="en-US" l10n="U" oldref="20">COUNT(2;4;6;"eight") = 3. The count of numbers is therefore <emph>3</emph>.</paragraph>
+</section>
+<section id="counta">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149729"><bookmark_value>COUNTA function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/>
+<paragraph role="heading" id="hd_id3149729" xml-lang="en-US" level="2" l10n="U" oldref="22">COUNTA</paragraph>
+<paragraph role="paragraph" id="par_id3150142" xml-lang="en-US" l10n="U" oldref="23"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted. Empty arguments are ignored.</paragraph>
+<paragraph role="heading" id="hd_id3148573" xml-lang="en-US" level="3" l10n="U" oldref="24">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3153111" xml-lang="en-US" l10n="U" oldref="25">COUNTA(value1; value2; ... value30)</paragraph>
+<paragraph role="paragraph" id="par_id3150001" xml-lang="en-US" l10n="U" oldref="26">
+<emph>value1; value2, ...</emph> are 1 to 30 arguments representing the values to be counted.</paragraph>
+<paragraph role="heading" id="hd_id3150334" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph>
+<paragraph role="paragraph" id="par_id3154508" xml-lang="en-US" l10n="U" oldref="28">The entries <emph>2, 4, 6</emph> and <emph>eight</emph> in the <emph>value 1 - 4</emph> fields are to be counted.</paragraph>
+<paragraph role="paragraph" id="par_id3158000" xml-lang="en-US" l10n="U" oldref="29">COUNTA(2;4;6;"eight") = 4. The count of values is therefore <emph>4</emph>.</paragraph>
+</section>
+<section id="b">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150267"><bookmark_value>B function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_B" id="bm_id3153044" localize="false"/>
+<paragraph role="heading" id="hd_id3150267" xml-lang="en-US" level="2" l10n="U" oldref="31">B</paragraph>
+<paragraph role="paragraph" id="par_id3156061" xml-lang="en-US" l10n="U" oldref="32"><ahelp hid="HID_FUNC_B">Returns the probability of a sample with binomial distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150659" xml-lang="en-US" level="3" l10n="U" oldref="33">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3148392" xml-lang="en-US" l10n="U" oldref="34">B(trials;SP;T_1;T_2)</paragraph>
+<paragraph role="paragraph" id="par_id3149002" xml-lang="en-US" l10n="U" oldref="35">
+<emph>Trials</emph> is the number of independent trials.</paragraph>
+<paragraph role="paragraph" id="par_id3148875" xml-lang="en-US" l10n="U" oldref="36">
+<emph>SP</emph> is the probability of success on each trial.</paragraph>
+<paragraph role="paragraph" id="par_id3145352" xml-lang="en-US" l10n="U" oldref="37">
+<emph>T_1</emph> defines the lower limit for the number of trials.</paragraph>
+<paragraph role="paragraph" id="par_id3149538" xml-lang="en-US" l10n="U" oldref="38">
+<emph>T_2</emph> (optional) defines the upper limit for the number of trials.</paragraph>
+<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="39">Example</paragraph>
+<paragraph role="paragraph" id="par_id3154633" xml-lang="en-US" l10n="U" oldref="40">What is the probability with ten throws of the dice, that a six will come up exactly twice? The probability of a six (or any other number) is 1/6. The following formula combines these factors:</paragraph>
+<paragraph role="paragraph" id="par_id3149393" xml-lang="en-US" l10n="U" oldref="41">=B(10; 1/6; 2) returns a probability of 29%.</paragraph>
+</section>
+<section id="rsq">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3158416"><bookmark_value>RSQ function</bookmark_value>
+<bookmark_value>determination coefficients</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BESTIMMTHEITSMASS" id="bm_id3153228" localize="false"/>
+<paragraph role="heading" id="hd_id3158416" xml-lang="en-US" level="2" l10n="U" oldref="43">RSQ</paragraph>
+<paragraph role="paragraph" id="par_id3154949" xml-lang="en-US" l10n="U" oldref="44"><ahelp hid="HID_FUNC_BESTIMMTHEITSMASS">Returns the square of the Pearson correlation coefficient based on the given values.</ahelp> RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis.</paragraph>
+<paragraph role="heading" id="hd_id3152820" xml-lang="en-US" level="3" l10n="U" oldref="45">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3155822" xml-lang="en-US" l10n="U" oldref="46">RSQ(Data_Y; Data_X)</paragraph>
+<paragraph role="paragraph" id="par_id3150470" xml-lang="en-US" l10n="U" oldref="47">
+<emph>Data_Y</emph> is an array or range of data points.</paragraph>
+<paragraph role="paragraph" id="par_id3153181" xml-lang="en-US" l10n="U" oldref="48">
+<emph>Data_X</emph> is an array or range of data points.</paragraph>
+<paragraph role="heading" id="hd_id3156258" xml-lang="en-US" level="3" l10n="U" oldref="49">Example</paragraph>
+<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U" oldref="50">=RSQ(A1:A20; B1:B20) calculates the correlation coefficient for both data sets in columns A and B.</paragraph>
+</section>
+<section id="betainv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145620"><bookmark_value>BETAINV function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BETAINV" id="bm_id3146154" localize="false"/>
+<paragraph role="heading" id="hd_id3145620" xml-lang="en-US" level="2" l10n="U" oldref="52">BETAINV</paragraph>
+<paragraph role="paragraph" id="par_id3149825" xml-lang="en-US" l10n="U" oldref="53"><ahelp hid="HID_FUNC_BETAINV">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3152479" xml-lang="en-US" level="3" l10n="U" oldref="54">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3156300" xml-lang="en-US" l10n="U" oldref="55">BETAINV(Number;Alpha;Beta;Start;End)</paragraph>
+<paragraph role="paragraph" id="par_id3149266" xml-lang="en-US" l10n="U" oldref="56">
+<emph>Number</emph> is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function.</paragraph>
+<paragraph role="paragraph" id="par_id3149710" xml-lang="en-US" l10n="U" oldref="57">
+<emph>Alpha</emph> is a parameter to the distribution.</paragraph>
+<paragraph role="paragraph" id="par_id3156306" xml-lang="en-US" l10n="U" oldref="58">
+<emph>Beta</emph> is a parameter to the distribution.</paragraph>
+<paragraph role="paragraph" id="par_id3150960" xml-lang="en-US" l10n="U" oldref="59">
+<emph>Start</emph> (optional) is the lower bound for <emph>number</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3151268" xml-lang="en-US" l10n="U" oldref="60">
+<emph>End</emph> (optional) is the upper bound for <emph>number</emph>.</paragraph>
+<paragraph role="heading" id="hd_id3147077" xml-lang="en-US" level="3" l10n="U" oldref="61">Example</paragraph>
+<paragraph role="paragraph" id="par_id3146859" xml-lang="en-US" l10n="U" oldref="62">=BETAINV(0.5; 5; 10) returns the value 0.33.</paragraph>
+</section>
+<section id="betadist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3156096"><bookmark_value>BETADIST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BETAVERT" id="bm_id3153213" localize="false"/>
+<paragraph role="heading" id="hd_id3156096" xml-lang="en-US" level="2" l10n="U" oldref="64">BETADIST</paragraph>
+<paragraph role="paragraph" id="par_id3150880" xml-lang="en-US" l10n="U" oldref="65"><ahelp hid="HID_FUNC_BETAVERT">Returns the cumulative beta probability density function.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3150762" xml-lang="en-US" level="3" l10n="U" oldref="66">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3147571" xml-lang="en-US" l10n="U" oldref="67">BETADIST(Number;Alpha;Beta;Start;End)</paragraph>
+<paragraph role="paragraph" id="par_id3156317" xml-lang="en-US" l10n="U" oldref="68">
+<emph>Number</emph> is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function.</paragraph>
+<paragraph role="paragraph" id="par_id3156107" xml-lang="en-US" l10n="U" oldref="69">
+<emph>Alpha</emph> is a parameter to the distribution.</paragraph>
+<paragraph role="paragraph" id="par_id3153619" xml-lang="en-US" l10n="U" oldref="70">
+<emph>Beta</emph> is a parameter to the distribution.</paragraph>
+<paragraph role="paragraph" id="par_id3150254" xml-lang="en-US" l10n="U" oldref="71">
+<emph>Start</emph> (optional) is the lower bound for <emph>number</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3149138" xml-lang="en-US" l10n="U" oldref="72">
+<emph>End</emph> (optional) is the upper bound for <emph>number</emph>.</paragraph>
+<paragraph role="heading" id="hd_id3145649" xml-lang="en-US" level="3" l10n="U" oldref="73">Example</paragraph>
+<paragraph role="paragraph" id="par_id3156118" xml-lang="en-US" l10n="U" oldref="74">=BETADIST(0.75; 3; 4) returns the value 0.96</paragraph>
+</section>
+<section id="binomdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3143228"><bookmark_value>BINOMDIST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BINOMVERT" id="bm_id3150146" localize="false"/>
+<paragraph role="heading" id="hd_id3143228" xml-lang="en-US" level="2" l10n="U" oldref="76">BINOMDIST</paragraph>
+<paragraph role="paragraph" id="par_id3146897" xml-lang="en-US" l10n="U" oldref="77"><ahelp hid="HID_FUNC_BINOMVERT">Returns the individual term binomial distribution probability.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149289" xml-lang="en-US" level="3" l10n="U" oldref="78">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3156009" xml-lang="en-US" l10n="U" oldref="79">BINOMDIST(X;trials;SP;C)</paragraph>
+<paragraph role="paragraph" id="par_id3154304" xml-lang="en-US" l10n="U" oldref="80">
+<emph>X</emph> is the number of successes in a set of trials.</paragraph>
+<paragraph role="paragraph" id="par_id3147492" xml-lang="en-US" l10n="U" oldref="81">
+<emph>Trials</emph> is the number of independent trials.</paragraph>
+<paragraph role="paragraph" id="par_id3146085" xml-lang="en-US" l10n="U" oldref="82">
+<emph>SP</emph> is the probability of success on each trial.</paragraph>
+<paragraph role="paragraph" id="par_id3149760" xml-lang="en-US" l10n="U" oldref="83">
+<emph>C</emph> = 0 calculates the probability of a single event and <emph>C</emph> = 1 calculates the cumulative probability.</paragraph>
+<paragraph role="heading" id="hd_id3151171" xml-lang="en-US" level="3" l10n="U" oldref="84">Example</paragraph>
+<paragraph role="paragraph" id="par_id3145666" xml-lang="en-US" l10n="U" oldref="85">=BINOMDIST(A1; 12; 0.5; 0) shows (if the values 0 to 12 are entered in A1) the probabilities for 12 flips of a coin that <emph>Heads</emph> will come up exactly the number of times entered in A1.</paragraph>
+<paragraph role="paragraph" id="par_id3150120" xml-lang="en-US" l10n="U" oldref="86">=BINOMDIST(A1; 12; 0.5; 1) shows the cumulative probabilities for the same series. For example, if A1 = 4, the cumulative probability of the series is 0, 1, 2, 3 or 4 times <emph>Heads</emph> (non-exclusive OR).</paragraph>
+</section>
+<section id="chiinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148835"><bookmark_value>CHIINV function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHIINV" id="bm_id3148823" localize="false"/>
+<paragraph role="heading" id="hd_id3148835" xml-lang="en-US" level="2" l10n="U" oldref="88">CHIINV</paragraph>
+<paragraph role="paragraph" id="par_id3149906" xml-lang="en-US" l10n="U" oldref="89"><ahelp hid="HID_FUNC_CHIINV">Returns the inverse of the one-tailed probability of the chi-squared distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3159157" xml-lang="en-US" level="3" l10n="U" oldref="90">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3150504" xml-lang="en-US" l10n="U" oldref="91">CHIINV(number; degrees_freedom)</paragraph>
+<paragraph role="paragraph" id="par_id3154898" xml-lang="en-US" l10n="U" oldref="92">
+<emph>Number</emph> is the value of the error probability.</paragraph>
+<paragraph role="paragraph" id="par_id3154294" xml-lang="en-US" l10n="U" oldref="93">
+<emph>Degrees_freedom</emph> is the degrees of freedom of the experiment.</paragraph>
+<paragraph role="heading" id="hd_id3154208" xml-lang="en-US" level="3" l10n="U" oldref="94">Example</paragraph>
+<paragraph role="paragraph" id="par_id3150777" xml-lang="en-US" l10n="U" oldref="130">A die is thrown 1020 times. The numbers on the die 1 through 6 come up 195, 151, 148, 189, 183 and 154 times (observation values). The hypothesis that the die is not fixed is to be tested.</paragraph>
+<paragraph role="paragraph" id="par_id3153062" xml-lang="en-US" l10n="U" oldref="131">The Chi square distribution of the random sample is determined by the formula given above. Since the expected value for a given number on the die for n throws is n times 1/6, thus 1020/6 = 170, the formula returns a Chi square value of 13.27.</paragraph>
+<paragraph role="paragraph" id="par_id3148806" xml-lang="en-US" l10n="U" oldref="132">If the (observed) Chi square is greater than or equal to the (theoretical) Chi square CHIINV, the hypothesis will be discarded, since the deviation between theory and experiment is too great. If the observed Chi square is less that CHIINV, the hypothesis is confirmed with the indicated probability of error.</paragraph>
+<paragraph role="paragraph" id="par_id3149763" xml-lang="en-US" l10n="U" oldref="95">=CHIINV(0.05; 5) returns 11.07.</paragraph>
+<paragraph role="paragraph" id="par_id3159142" xml-lang="en-US" l10n="U" oldref="133">=CHIINV(0.02; 5) returns 13.39.</paragraph>
+<paragraph role="paragraph" id="par_id3158401" xml-lang="en-US" l10n="U" oldref="134">If the probability of error is 5%, the die is not true. If the probability of error is 2%, there is no reason to believe it is fixed.</paragraph>
+</section>
+<section id="chitest">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3154260"><bookmark_value>CHITEST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHITEST" id="bm_id3155355" localize="false"/>
+<paragraph role="heading" id="hd_id3154260" xml-lang="en-US" level="2" l10n="U" oldref="97">CHITEST</paragraph>
+<paragraph role="paragraph" id="par_id3151052" xml-lang="en-US" l10n="U" oldref="98"><ahelp hid="HID_FUNC_CHITEST">Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</ahelp> CHITEST returns the chi-squared distribution of the data.</paragraph>
+<paragraph role="paragraph" id="par_id3148925" xml-lang="en-US" l10n="U" oldref="135">The probability determined by CHITEST can also be determined with CHIDIST, in which case the Chi square of the random sample must then be passed as a parameter instead of the data row.</paragraph>
+<paragraph role="heading" id="hd_id3154280" xml-lang="en-US" level="3" l10n="U" oldref="99">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3149162" xml-lang="en-US" l10n="U" oldref="100">CHITEST(Data_B; Data_E)</paragraph>
+<paragraph role="paragraph" id="par_id3158421" xml-lang="en-US" l10n="U" oldref="101">
+<emph>Data_B</emph> is the array of the observations.</paragraph>
+<paragraph role="paragraph" id="par_id3166453" xml-lang="en-US" l10n="U" oldref="102">
+<emph>Data_E</emph> is the range of the expected values.</paragraph>
+<paragraph role="heading" id="hd_id3146946" xml-lang="en-US" level="3" l10n="U" oldref="103">Example</paragraph>
+<table id="tbl_id3153233">
+<tablerow>
+<tablecell colspan="" rowspan="">
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3154096" xml-lang="en-US" l10n="U" oldref="136">Data_B (observed)</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" l10n="U" oldref="137">Data_E (expected)</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3152876" xml-lang="en-US" l10n="U" oldref="138">1</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3159279" xml-lang="en-US" l10n="U" oldref="139">195</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149105" xml-lang="en-US" l10n="U" oldref="140">170</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149922" xml-lang="en-US" l10n="U" oldref="141">2</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148621" xml-lang="en-US" l10n="U" oldref="142">151</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148987" xml-lang="en-US" l10n="U" oldref="143">170</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149417" xml-lang="en-US" l10n="U" oldref="144">3</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148661" xml-lang="en-US" l10n="U" oldref="145">148</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3151128" xml-lang="en-US" l10n="U" oldref="146">170</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3148467" xml-lang="en-US" l10n="U" oldref="147">4</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149237" xml-lang="en-US" l10n="U" oldref="148">189</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3145304" xml-lang="en-US" l10n="U" oldref="149">170</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3149927" xml-lang="en-US" l10n="U" oldref="150">5</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150630" xml-lang="en-US" l10n="U" oldref="151">183</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3150423" xml-lang="en-US" l10n="U" oldref="152">170</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3143275" xml-lang="en-US" l10n="U" oldref="153">6</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3144750" xml-lang="en-US" l10n="U" oldref="154">154</paragraph>
+</tablecell>
+<tablecell colspan="" rowspan="">
+<paragraph role="paragraph" id="par_id3153947" xml-lang="en-US" l10n="U" oldref="155">170</paragraph>
+</tablecell>
+</tablerow>
+</table>
+
+<paragraph role="paragraph" id="par_id3149481" xml-lang="en-US" l10n="U" oldref="104">=CHITEST(A1:A6; B1:B6) equals 0.02. This is the probability which suffices the observed data of the theoretical Chi-square distribution.</paragraph>
+</section>
+<section id="chidist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148690"><bookmark_value>CHIDIST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_CHIVERT" id="bm_id3147521" localize="false"/>
+<paragraph role="heading" id="hd_id3148690" xml-lang="en-US" level="2" l10n="U" oldref="106">CHIDIST</paragraph>
+<paragraph role="paragraph" id="par_id3156338" xml-lang="en-US" l10n="U" oldref="156"><ahelp hid="HID_FUNC_CHIVERT">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHIDIST compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error for the hypothesis to be tested.</paragraph>
+<paragraph role="paragraph" id="par_id3151316" xml-lang="en-US" l10n="U" oldref="157">The probability determined by CHIDIST can also be determined by CHITEST.</paragraph>
+<paragraph role="heading" id="hd_id3155123" xml-lang="en-US" level="3" l10n="U" oldref="108">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3158439" xml-lang="en-US" l10n="U" oldref="109">CHIDIST (Number; degrees_freedom)</paragraph>
+<paragraph role="paragraph" id="par_id3148675" xml-lang="en-US" l10n="U" oldref="110">
+<emph>Number</emph> is the chi-square value of the random sample used to determine the error probability.</paragraph>
+<paragraph role="paragraph" id="par_id3155615" xml-lang="en-US" l10n="U" oldref="111">
+<emph>Degrees_freedom</emph> are the degrees of freedom of the experiment.</paragraph>
+<paragraph role="heading" id="hd_id3146787" xml-lang="en-US" level="3" l10n="U" oldref="112">Example</paragraph>
+<paragraph role="paragraph" id="par_id3145774" xml-lang="en-US" l10n="U" oldref="113">=CHIDIST(13.27; 5) equals 0.02.</paragraph>
+<paragraph role="paragraph" id="par_id3156141" xml-lang="en-US" l10n="U" oldref="158">If the Chi square value of the random sample is 13.27 and if the experiment has 5 degrees of freedom, then the hypothesis is assured with a probability of error of 2%.</paragraph>
+</section>
+<section id="expondist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150603"><bookmark_value>EXPONDIST function</bookmark_value>
+<bookmark_value>exponential distributions</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EXPONVERT" id="bm_id3152962" localize="false"/>
+<paragraph role="heading" id="hd_id3150603" xml-lang="en-US" level="2" l10n="U" oldref="115">EXPONDIST</paragraph>
+<paragraph role="paragraph" id="par_id3149563" xml-lang="en-US" l10n="U" oldref="116"><ahelp hid="HID_FUNC_EXPONVERT">Returns the exponential distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3153789" xml-lang="en-US" level="3" l10n="U" oldref="117">Syntax</paragraph>
+<paragraph role="paragraph" id="par_id3150987" xml-lang="en-US" l10n="U" oldref="118">EXPONDIST(Number; lambda; C)</paragraph>
+<paragraph role="paragraph" id="par_id3154663" xml-lang="en-US" l10n="U" oldref="119">
+<emph>Number</emph> is the value of the function.</paragraph>
+<paragraph role="paragraph" id="par_id3154569" xml-lang="en-US" l10n="U" oldref="120">
+<emph>Lambda</emph> is the parameter value.</paragraph>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3147332"><bookmark_value>density function</bookmark_value>
+</bookmark>
+<paragraph role="paragraph" id="par_id3147332" xml-lang="en-US" l10n="U" oldref="121">
+<emph>C</emph> is a logical value that determines the form of the function. <emph>C = 0</emph> calculates the density function, and <emph>C = 1</emph> calculates the distribution.</paragraph>
+<paragraph role="heading" id="hd_id3146133" xml-lang="en-US" level="3" l10n="U" oldref="122">Example</paragraph>
+<paragraph role="paragraph" id="par_id3150357" xml-lang="en-US" l10n="U" oldref="123">=EXPONDIST(3; 0.5; 1) returns 0.78.</paragraph>
+</section>
+</sort>
+</body>
+</helpdocument>