helpcontent2/source/text/scalc/01/04060108.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <helpdocument version="1.0">
   3
   4 <!--
   5 ***********************************************************************
   6  *
   7  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   8  *
   9  * Copyright 2008 by Sun Microsystems, Inc.
  10  *
  11  * OpenOffice.org - a multi-platform office productivity suite
  12  *
  13  * $RCSfile: 04060108.xhp,v $
  14  * $Revision: 1.9.4.1 $
  15  *
  16  * This file is part of OpenOffice.org.
  17  *
  18  * OpenOffice.org is free software: you can redistribute it and/or modify
  19  * it under the terms of the GNU Lesser General Public License version 3
  20  * only, as published by the Free Software Foundation.
  21  *
  22  * OpenOffice.org is distributed in the hope that it will be useful,
  23  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  24  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  25  * GNU Lesser General Public License version 3 for more details
  26  * (a copy is included in the LICENSE file that accompanied this code).
  27  *
  28  * You should have received a copy of the GNU Lesser General Public License
  29  * version 3 along with OpenOffice.org.  If not, see
  30  * <http://www.openoffice.org/license.html>
  31  * for a copy of the LGPLv3 License.
  32  *
  33  ************************************************************************
  34  -->
  35
  36
  37 <meta>
  38 <topic id="textscalc0104060108xml" indexer="include">
  39 <title id="tit" xml-lang="en-US">Statistics Functions</title>
  40 <filename>/text/scalc/01/04060108.xhp</filename>
  41 </topic>
  42 </meta>
  43 <body>
  44 <bookmark xml-lang="en-US" branch="index" id="bm_id3153018"><bookmark_value>statistics functions</bookmark_value>
  45 <bookmark_value>Function Wizard; statistics</bookmark_value>
  46 <bookmark_value>functions; statistics functions</bookmark_value>
  47 </bookmark>
  48 <paragraph role="heading" id="hd_id3153018" xml-lang="en-US" level="1" l10n="U" oldref="1">Statistics Functions</paragraph>
  49 <paragraph role="paragraph" id="par_id3157874" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="statistiktext">This category contains the <emph>Statistics</emph> functions.
  50 </variable></paragraph>
  51 <section id="howtoget">
  52 <embed href="text/scalc/00/00000404.xhp#eikasta"/>
  53 </section>
  54 <paragraph role="paragraph" id="par_id3149001" xml-lang="en-US" l10n="U" oldref="9">Some of the examples use the following data table:</paragraph>
  55 <table id="tbl_id3156066">
  56 <tablerow>
  57 <tablecell>
  58 </tablecell>
  59 <tablecell>
  60 <paragraph role="tablehead" id="par_id3148775" xml-lang="en-US" l10n="U" oldref="10">C</paragraph>
  61 </tablecell>
  62 <tablecell>
  63 <paragraph role="tablehead" id="par_id3145297" xml-lang="en-US" l10n="U" oldref="11">D</paragraph>
  64 </tablecell>
  65 </tablerow>
  66 <tablerow>
  67 <tablecell>
  68 <paragraph role="tablecontent" id="par_id3150661" xml-lang="en-US" l10n="U" oldref="12">2</paragraph>
  69 </tablecell>
  70 <tablecell>
  71 <paragraph role="tablecontent" id="par_id3153551" xml-lang="en-US" l10n="U" oldref="13">x value</paragraph>
  72 </tablecell>
  73 <tablecell>
  74 <paragraph role="tablecontent" id="par_id3147536" xml-lang="en-US" l10n="U" oldref="14">y value</paragraph>
  75 </tablecell>
  76 </tablerow>
  77 <tablerow>
  78 <tablecell>
  79 <paragraph role="tablecontent" id="par_id3153224" xml-lang="en-US" l10n="U" oldref="15">3</paragraph>
  80 </tablecell>
  81 <tablecell>
  82 <paragraph role="tablecontent" id="par_id3150475" xml-lang="en-US" l10n="U" oldref="16">-5</paragraph>
  83 </tablecell>
  84 <tablecell>
  85 <paragraph role="tablecontent" id="par_id3155367" xml-lang="en-US" l10n="U" oldref="17">-3</paragraph>
  86 </tablecell>
  87 </tablerow>
  88 <tablerow>
  89 <tablecell>
  90 <paragraph role="tablecontent" id="par_id3149783" xml-lang="en-US" l10n="U" oldref="18">4</paragraph>
  91 </tablecell>
  92 <tablecell>
  93 <paragraph role="tablecontent" id="par_id3153181" xml-lang="en-US" l10n="U" oldref="19">-2</paragraph>
  94 </tablecell>
  95 <tablecell>
  96 <paragraph role="tablecontent" id="par_id3148429" xml-lang="en-US" l10n="U" oldref="20">0</paragraph>
  97 </tablecell>
  98 </tablerow>
  99 <tablerow>
 100 <tablecell>
 101 <paragraph role="tablecontent" id="par_id3152588" xml-lang="en-US" l10n="U" oldref="21">5</paragraph>
 102 </tablecell>
 103 <tablecell>
 104 <paragraph role="tablecontent" id="par_id3147483" xml-lang="en-US" l10n="U" oldref="22">-1</paragraph>
 105 </tablecell>
 106 <tablecell>
 107 <paragraph role="tablecontent" id="par_id3083443" xml-lang="en-US" l10n="U" oldref="23">1</paragraph>
 108 </tablecell>
 109 </tablerow>
 110 <tablerow>
 111 <tablecell>
 112 <paragraph role="tablecontent" id="par_id3149826" xml-lang="en-US" l10n="U" oldref="24">6</paragraph>
 113 </tablecell>
 114 <tablecell>
 115 <paragraph role="tablecontent" id="par_id3163820" xml-lang="en-US" l10n="U" oldref="25">0</paragraph>
 116 </tablecell>
 117 <tablecell>
 118 <paragraph role="tablecontent" id="par_id3154816" xml-lang="en-US" l10n="U" oldref="26">3</paragraph>
 119 </tablecell>
 120 </tablerow>
 121 <tablerow>
 122 <tablecell>
 123 <paragraph role="tablecontent" id="par_id3149276" xml-lang="en-US" l10n="U" oldref="27">7</paragraph>
 124 </tablecell>
 125 <tablecell>
 126 <paragraph role="tablecontent" id="par_id3149267" xml-lang="en-US" l10n="U" oldref="28">2</paragraph>
 127 </tablecell>
 128 <tablecell>
 129 <paragraph role="tablecontent" id="par_id3156310" xml-lang="en-US" l10n="U" oldref="29">4</paragraph>
 130 </tablecell>
 131 </tablerow>
 132 <tablerow>
 133 <tablecell>
 134 <paragraph role="tablecontent" id="par_id3154639" xml-lang="en-US" l10n="U" oldref="30">8</paragraph>
 135 </tablecell>
 136 <tablecell>
 137 <paragraph role="tablecontent" id="par_id3145205" xml-lang="en-US" l10n="U" oldref="31">4</paragraph>
 138 </tablecell>
 139 <tablecell>
 140 <paragraph role="tablecontent" id="par_id3153276" xml-lang="en-US" l10n="U" oldref="32">6</paragraph>
 141 </tablecell>
 142 </tablerow>
 143 <tablerow>
 144 <tablecell>
 145 <paragraph role="tablecontent" id="par_id3150756" xml-lang="en-US" l10n="U" oldref="33">9</paragraph>
 146 </tablecell>
 147 <tablecell>
 148 <paragraph role="tablecontent" id="par_id3156095" xml-lang="en-US" l10n="U" oldref="34">6</paragraph>
 149 </tablecell>
 150 <tablecell>
 151 <paragraph role="tablecontent" id="par_id3152929" xml-lang="en-US" l10n="U" oldref="35">8</paragraph>
 152 </tablecell>
 153 </tablerow>
 154 </table>
 155
 156 <paragraph role="paragraph" id="par_id3156324" xml-lang="en-US" l10n="U" oldref="36">The statistical functions are described in the following subsections.</paragraph>
 157 <embed href="text/scalc/01/04060181.xhp#ae"/>
 158 <embed href="text/scalc/01/04060182.xhp#fh"/>
 159 <embed href="text/scalc/01/04060183.xhp#kl"/>
 160 <embed href="text/scalc/01/04060184.xhp#mq"/>
 161 <embed href="text/scalc/01/04060185.xhp#rz"/>
 162 <paragraph role="paragraph" id="par_id3150271" xml-lang="en-US" l10n="U" oldref="37"><link href="text/scalc/01/04060116.xhp" name="Statistical Functions in the Analysis-AddIn.">Statistical Functions in the Analysis-AddIn</link></paragraph>
 163 <embed href="text/scalc/01/04060100.xhp#drking"/>
 164 </body>
 165 </helpdocument>