helpcontent2/source/text/schart/01/04050000.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <helpdocument version="1.0">
   3
   4 <!--
   5  ***********************************************************************
   6  *
   7  *  OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  *  $RCSfile: 04050000.xhp,v $fileonly,v $
  10  *
  11  *  $Revision: 1.9.4.3 $
  12  *
  13  *  last change: $Author: ufi $ $Date: 2008/09/16 12:40:37 $
  14  *
  15  * This file is part of OpenOffice.org.
  16  *
  17  * OpenOffice.org is free software: you can redistribute it and/or modify
  18  * it under the terms of the GNU Lesser General Public License version 3
  19  * only, as published by the Free Software Foundation.
  20  *
  21  * OpenOffice.org is distributed in the hope that it will be useful,
  22  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  23  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  24  * GNU Lesser General Public License version 3 for more details
  25  * (a copy is included in the LICENSE file that accompanied this code).
  26  *
  27  * You should have received a copy of the GNU Lesser General Public License
  28  * version 3 along with OpenOffice.org.  If not, see
  29  * <http://www.openoffice.org/license.html>
  30  * for a copy of the LGPLv3 License.
  31  *
  32  ************************************************************************
  33  -->
  34
  35
  36 <meta>
  37 <topic id="textschart0104050000xml" indexer="include" status="PUBLISH">
  38 <title id="tit" xml-lang="en-US">Y Error Bars</title>
  39 <filename>/text/schart/01/04050000.xhp</filename>
  40 </topic>
  41 </meta>
  42 <body>
  43 <bookmark xml-lang="en-US" branch="hid/.uno:InsertMenuYErrorBars" id="bm_id877101" localize="false"/>
  44 <paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/schart/01/04050000.xhp" name="Y Error Bars">Y Error Bars</link></paragraph><comment>i85330</comment>
  45 <paragraph role="paragraph" id="par_id3149666" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="statistik"><ahelp hid=".">Use the <emph>Y Error Bars</emph> dialog to display error bars for 2D charts.</ahelp>
  46 </variable></paragraph>
  47 <embed href="text/schart/01/04030000.xhp#context"/>
  48 <section id="howtoget">
  49 <embed href="text/schart/00/00000004.xhp#efgsta"/>
  50 </section>
  51 <paragraph role="paragraph" id="par_id3401287" xml-lang="en-US" l10n="NEW">An error bar is an indicator line that spans over a range from y - NegativeErrorValue to y + PositiveErrorValue. In this term, y is the value of the data point. When "standard deviation" is selected, y is the mean value of the data series. NegativeErrorValue and PositiveErrorValue are the amounts calculated by the error bar function or given explicitly.</paragraph>
  52 <paragraph role="note" id="par_id3153965" xml-lang="en-US" l10n="CHG" oldref="23">The <emph>Insert - Y Error Bars</emph> menu command is only available for 2D charts.</paragraph>
  53 <paragraph role="heading" id="hd_id3150344" xml-lang="en-US" level="2" l10n="U" oldref="5">Error category</paragraph>
  54 <paragraph role="paragraph" id="par_id3150202" xml-lang="en-US" l10n="CHG" oldref="6">In the <emph>Error category</emph> area, you can choose different ways to display the error category.</paragraph>
  55 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_NONE" id="bm_id3156445" localize="false"/>
  56 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_STAT:RBT_NONE" id="bm_id3156449" localize="false"/>
  57 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_NO_ERROR" id="bm_id3862117" localize="false"/>
  58 <paragraph role="heading" id="hd_id3152989" xml-lang="en-US" level="3" l10n="CHG" oldref="7">None</paragraph>
  59 <paragraph role="paragraph" id="par_id3149409" xml-lang="en-US" l10n="CHG" oldref="8"><ahelp hid="SCH:RADIOBUTTON:TP_STAT:RBT_NONE">Does not show any error bars.</ahelp></paragraph>
  60 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_CONST" id="bm_id3149052" localize="false"/>
  61 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_PLUS" id="bm_id3153955" localize="false"/>
  62 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_MINUS" id="bm_id3153960" localize="false"/>
  63 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_STAT:RBT_CONST" id="bm_id3153336" localize="false"/>
  64 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:TP_STAT:MTR_FLD_PLUS" id="bm_id3153340" localize="false"/>
  65 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:TP_STAT:MTR_FLD_MINUS" id="bm_id3147298" localize="false"/>
  66 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_CONSTERROR" id="bm_id3964964" localize="false"/>
  67 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_PLUS_VALUE" id="bm_id5771965" localize="false"/>
  68 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_MINUS_VALUE" id="bm_id1989196" localize="false"/>
  69 <paragraph role="heading" id="hd_id3145117" xml-lang="en-US" level="3" l10n="U" oldref="17">Constant value</paragraph>
  70 <paragraph role="paragraph" id="par_id3151390" xml-lang="en-US" l10n="CHG" oldref="18"><ahelp hid="SCH:METRICFIELD:TP_STAT:MTR_FLD_MINUS">Displays constant values that you specify in the Parameters area.</ahelp></paragraph>
  71 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_PERCENT" id="bm_id3145358" localize="false"/>
  72 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_PERCENT" id="bm_id3154762" localize="false"/>
  73 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_STAT:RBT_PERCENTVALUE" id="bm_id3145362" localize="false"/>
  74 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:TP_STAT:MTR_FLD_PERCENT" id="bm_id3154650" localize="false"/>
  75 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_PERCENT" id="bm_id3336588" localize="false"/>
  76 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_PERCENT_VALUE" id="bm_id1381572" localize="false"/>
  77 <paragraph role="heading" id="hd_id3159204" xml-lang="en-US" level="3" l10n="U" oldref="13">Percentage</paragraph>
  78 <paragraph role="paragraph" id="par_id3150048" xml-lang="en-US" l10n="CHG" oldref="14"><ahelp hid="SCH:METRICFIELD:TP_STAT:MTR_FLD_PERCENT">Displays a percentage. The display refers to the corresponding data point. Set the percentage in the Parameters area.</ahelp></paragraph>
  79 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_FUNCTION" id="bm_id7856685" localize="false"/>
  80 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_FUNCTION_LB" id="bm_id0428200810313556" localize="false"/>
  81 <paragraph role="heading" id="hd_id8977629" xml-lang="en-US" level="3" l10n="NEW">Functions</paragraph>
  82 <paragraph role="paragraph" id="par_id7109286" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select a function to calculate the error bars.</ahelp></paragraph>
  83 <paragraph role="paragraph" id="par_id5154576" xml-lang="en-US" l10n="NEW">Standard Error: Displays the standard error.</paragraph>
  84 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_VARIANT" id="bm_id3148868" localize="false"/>
  85 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_STAT:RBT_VARIANT" id="bm_id3151239" localize="false"/>
  86 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_VARIANT" id="bm_id1840876" localize="false"/>
  87 <paragraph role="paragraph" id="par_id3157979" xml-lang="en-US" l10n="CHG" oldref="10"><ahelp hid=".">Variance: Displays the variance calculated from the number of data points and respective values.</ahelp></paragraph>
  88 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_SIGMA" id="bm_id3156017" localize="false"/>
  89 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_STAT:RBT_SIGMA" id="bm_id3156021" localize="false"/>
  90 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_SIGMA" id="bm_id1873836" localize="false"/>
  91 <paragraph role="paragraph" id="par_id3153249" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid=".">Standard Deviation: Displays the standard deviation (square root of the variance).</ahelp></paragraph>
  92 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:DLG_DATA_STAT:RBT_BIGERROR" id="bm_id3154707" localize="false"/>
  93 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:DLG_DATA_STAT:MTR_FLD_BIGERROR" id="bm_id3154711" localize="false"/>
  94 <bookmark xml-lang="en-US" branch="hid/SCH:RADIOBUTTON:TP_STAT:RBT_BIGERROR" id="bm_id3151197" localize="false"/>
  95 <bookmark xml-lang="en-US" branch="hid/SCH:METRICFIELD:TP_STAT:MTR_FLD_BIGERROR" id="bm_id3153070" localize="false"/>
  96 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_BIGERROR" id="bm_id5876949" localize="false"/>
  97 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_BIGERROR_VALUE" id="bm_id9021271" localize="false"/>
  98 <paragraph role="paragraph" id="par_id3149870" xml-lang="en-US" l10n="CHG" oldref="16"><ahelp hid=".">Error Margin: Displays the highest error margin in percent according to the highest value of the data group. Set the percentage in the Parameters area.</ahelp></paragraph>
  99 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_RANGE" id="bm_id0428200810324237" localize="false"/>
 100 <paragraph role="heading" id="hd_id350962" xml-lang="en-US" level="3" l10n="NEW">Cell Range</paragraph>
 101 <paragraph role="paragraph" id="par_id6679586" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Click Cell Range and then specify a cell range from which to take the positive and negative error bar values.</ahelp></paragraph>
 102 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_POSITIVE_RANGE_CHOOSER" id="bm_id8996856" localize="false"/>
 103 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_NEGATIVE_RANGE_CHOOSER" id="bm_id8254646" localize="false"/>
 104 <paragraph role="paragraph" id="par_id3872188" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click a button to shrink the dialog, then use the mouse to select the cell range in the spreadsheet. Click the button again to restore the dialog to full size.</ahelp></paragraph>
 105 <paragraph role="heading" id="hd_id2633747" xml-lang="en-US" level="3" l10n="NEW">From Data Table</paragraph>
 106 <paragraph role="paragraph" id="par_id6633503" xml-lang="en-US" l10n="NEW"><ahelp hid=".">For a chart with its own data, the error bar values can be entered in the chart data table. The Data Table dialog shows additional columns titled Positive Y-Error-Bars and Negative Y-Error-Bars.</ahelp></paragraph><comment>Positive (+)</comment>
 107 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_POSITIVE_VALUE" id="bm_id042820081035035" localize="false"/>
 108 <paragraph role="paragraph" id="par_id0428200810573839" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the value to add to the displayed value as the positive error value.</ahelp></paragraph><comment>Negative (-)</comment>
 109 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_NEGATIVE_VALUE" id="bm_id042820081036404" localize="false"/>
 110 <paragraph role="paragraph" id="par_id0428200810573862" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the value to subtract from the displayed value as the negative error value.</ahelp></paragraph><comment>Positive (+) when Cell Range is selected</comment>
 111 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_POSITIVE_RANGE" id="bm_id0428200810391875" localize="false"/>
 112 <paragraph role="paragraph" id="par_id0428200810573844" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the address range from where to get the positive error values. Use the Shrink button to select the range from a sheet.</ahelp></paragraph><comment>Negative (-) when Cell Range is selected</comment>
 113 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_NEGATIVE_RANGE" id="bm_id0428200810445387" localize="false"/>
 114 <paragraph role="paragraph" id="par_id0428200810573970" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the address range from where to get the negative error values. Use the Shrink button to select the range from a sheet.</ahelp></paragraph>
 115 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_SAME_FOR_BOTH" id="bm_id0428200810464079" localize="false"/>
 116 <paragraph role="heading" id="hd_id0428200810573977" xml-lang="en-US" level="3" l10n="NEW">Same value for both</paragraph>
 117 <paragraph role="paragraph" id="par_id0428200810573991" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enable to use the positive error values also as negative error values. You can only change the value of the "Positve (+)" box. That value gets copied to the "Negative (-)" box automatically.</ahelp></paragraph>
 118 <bookmark xml-lang="en-US" branch="hid/HID_SCH_CT_INDICATE" id="bm_id3166467" localize="false"/>
 119 <bookmark xml-lang="en-US" branch="hid/HID_SCH_CT_INDICATE2" id="bm_id3150533" localize="false"/>
 120 <paragraph role="heading" id="hd_id3156396" xml-lang="en-US" level="2" l10n="U" oldref="19">Error indicator</paragraph>
 121 <paragraph role="paragraph" id="par_id3150539" xml-lang="en-US" l10n="CHG" oldref="20"><ahelp hid="HID_SCH_CT_INDICATE2">Specifies the error indicator.</ahelp></paragraph>
 122 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_SHOW_BOTH" id="bm_id0428200810544351" localize="false"/>
 123 <paragraph role="heading" id="hd_id0428200810574027" xml-lang="en-US" level="3" l10n="NEW">Positive and Negative</paragraph>
 124 <paragraph role="paragraph" id="par_id0428200810574039" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Shows positive and negative error bars.</ahelp></paragraph>
 125 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_SHOW_POSITIVE" id="bm_id0428200810550028" localize="false"/>
 126 <paragraph role="heading" id="hd_id0428200810574031" xml-lang="en-US" level="3" l10n="NEW">Positive</paragraph>
 127 <paragraph role="paragraph" id="par_id042820081057411" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Shows only positive error bars.</ahelp></paragraph>
 128 <bookmark xml-lang="en-US" branch="hid/HID_SCH_STATISTIK_SHOW_NEGATIVE" id="bm_id0428200810551739" localize="false"/>
 129 <paragraph role="heading" id="hd_id0428200810574138" xml-lang="en-US" level="3" l10n="NEW">Negative</paragraph>
 130 <paragraph role="paragraph" id="par_id0522200809110667" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Shows only negative error bars.</ahelp></paragraph>
 131 <section id="relatedtopics">
 132 <embed href="text/schart/01/04050100.xhp#regression"/>
 133 </section>
 134 </body>
 135 </helpdocument>