summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01
diff options
context:
space:
mode:
authorRĂ¼diger Timm <rt@openoffice.org>2005-10-19 08:37:11 +0000
committerRĂ¼diger Timm <rt@openoffice.org>2005-10-19 08:37:11 +0000
commit0ba656e1491beeb3d1edce989eff641f0bb7b5ce (patch)
treed8c4870f470154273fb160683c2039c9f3dfef7b /helpcontent2/source/text/scalc/01
parentINTEGRATION: CWS hc680qq1 (1.3.74); FILE MERGED (diff)
downloadhelp-0ba656e1491beeb3d1edce989eff641f0bb7b5ce.tar.gz
help-0ba656e1491beeb3d1edce989eff641f0bb7b5ce.zip
INTEGRATION: CWS hc680qq1 (1.5.16); FILE MERGED
2005/09/20 16:12:50 ufi 1.5.16.2: RESYNC: (1.5-1.6); FILE MERGED 2005/09/13 13:14:29 ufi 1.5.16.1: firsttry
Diffstat (limited to 'helpcontent2/source/text/scalc/01')
-rw-r--r--helpcontent2/source/text/scalc/01/04060107.xhp18
1 files changed, 9 insertions, 9 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060107.xhp b/helpcontent2/source/text/scalc/01/04060107.xhp
index 7609511eb5..1111d89692 100644
--- a/helpcontent2/source/text/scalc/01/04060107.xhp
+++ b/helpcontent2/source/text/scalc/01/04060107.xhp
@@ -5,9 +5,9 @@
*
* $RCSfile: 04060107.xhp,v $
*
- * $Revision: 1.6 $
+ * $Revision: 1.7 $
*
- * last change: $Author: rt $ $Date: 2005-09-07 17:28:22 $
+ * last change: $Author: rt $ $Date: 2005-10-19 09:37:11 $
*
* The Contents of this file are made available subject to
* the terms of GNU Lesser General Public License Version 2.1.
@@ -42,7 +42,7 @@
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2005-06-29T13:20:33">UFI: sorted, added note text to every syntax description, added spec "Conditional Array Calculation and Specific Array Handling"
+<lastedited date="2005-09-13T09:30:52">UFI: sorted, added note text to every syntax description, added spec "Conditional Array Calculation and Specific Array Handling"
dedr: reviewed, fixed #i31269#
UFI: someone deleted the example table, so most examples became meaningless -&gt; I deleted those examples</lastedited>
</history>
@@ -365,13 +365,13 @@ UFI: someone deleted the example table, so most examples became meaningless -&gt
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_FUNC_HAEUFIGKEIT" id="bm_id3153883" localize="false"/>
<paragraph role="heading" id="hd_id3159084" xml-lang="en-US" level="2" l10n="U" oldref="22">FREQUENCY</paragraph>
-<paragraph role="paragraph" id="par_id3145777" xml-lang="en-US" l10n="U" oldref="23"><ahelp hid="HID_FUNC_HAEUFIGKEIT">Indicates the frequency distribution in a one-column-array.</ahelp> The default value supply and the number of intervals or classes are used to count how many values are omitted on the single intervals.</paragraph>
+<paragraph role="paragraph" id="par_id3145777" xml-lang="en-US" l10n="CHG" oldref="23"><ahelp hid="HID_FUNC_HAEUFIGKEIT">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the Data array that are within the values given by the Classes array.</paragraph>
<paragraph role="heading" id="hd_id3153347" xml-lang="en-US" level="3" l10n="U" oldref="24">Syntax</paragraph>
<paragraph role="code" id="par_id3155498" xml-lang="en-US" l10n="U" oldref="25">FREQUENCY(Data; Classes)</paragraph>
-<paragraph role="paragraph" id="par_id3154352" xml-lang="en-US" l10n="U" oldref="26">
-<emph>Data</emph> represents the array of or reference to the set of values to be counted.</paragraph>
-<paragraph role="paragraph" id="par_id3148402" xml-lang="en-US" l10n="U" oldref="27">
-<emph>Classes</emph> represents the array of the class set.</paragraph>
+<paragraph role="paragraph" id="par_id3154352" xml-lang="en-US" l10n="CHG" oldref="26">
+<emph>Data</emph> represents the reference to the values to be counted.</paragraph>
+<paragraph role="paragraph" id="par_id3148402" xml-lang="en-US" l10n="CHG" oldref="27">
+<emph>Classes</emph> represents the array of the limit values.</paragraph>
<paragraph role="note" id="par_idN10D71" xml-lang="en-US" l10n="NEW">You can find a general introduction to Array functions at the top of this page.</paragraph>
<paragraph role="heading" id="hd_id3148981" xml-lang="en-US" level="3" l10n="U" oldref="28">Example</paragraph>
<paragraph role="paragraph" id="par_id3155904" xml-lang="en-US" l10n="U" oldref="219">In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 or greater than or equal to 10. The text you entered in B6, "&gt;25", is only for reference purposes.</paragraph>
@@ -563,7 +563,7 @@ UFI: someone deleted the example table, so most examples became meaningless -&gt
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3150312" xml-lang="en-US" l10n="U" oldref="29">Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the <emph>Function Wizard</emph>. Select the measurement range for <emph>Data</emph> in (A1:A11), and then a column for <emph>Classes</emph>, in which you entered the class limits (B1:B6) Select the <emph>array</emph> check box and click <emph>OK</emph>. You will see the frequency count in the initially selected range C1:C6.</paragraph>
+<paragraph role="paragraph" id="par_id3150312" xml-lang="en-US" l10n="CHG" oldref="29">Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the <emph>Function Wizard</emph>. Select the <emph>Data</emph> range in (A1:A11), and then the <emph>Classes</emph> range in which you entered the class limits (B1:B6). Select the <emph>Array</emph> check box and click <emph>OK</emph>. You will see the frequency count in the range C1:C6.</paragraph>
<paragraph role="paragraph" id="par_idN11269" xml-lang="en-US" l10n="NEW">
<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
</paragraph>