diff options
| author | tagezi <lera.goncharuk@gmail.com> | 2015-09-26 20:56:19 +0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@edx.srv.br> | 2015-10-03 14:47:18 +0000 |
| commit | 7c74f4a55c7171419a78aa18f6d8842fe4f62833 (patch) | |
| tree | f4960c5283e187ff782b02ecc75ecbb68a06b46f /source/text/scalc/01/ex_data_stat_func.xhp | |
| parent | tdf#92825 Rearrange the edit menu in writer, calc, and impress (diff) | |
| download | help-7c74f4a55c7171419a78aa18f6d8842fe4f62833.tar.gz help-7c74f4a55c7171419a78aa18f6d8842fe4f62833.zip | |
Added description and examples of the AVERAGEIF function
UPD: Changed in accordance with the comment of Olivier Hallot (Sep 29 7:31 PM)
Added value for the missing ID (string 80)
UPD2: typo: forboth -> for both
table for an example was moved to a separate file
the attribute "role" of the tag "paragraph" for all an example
has been changed from "paragraph" to "example"
UDP3: double IDs was deleted in ex_data_stat_func.xhp
Change-Id: I31b377715db133bfaab59047f9613171db8659e1
Reviewed-on: https://gerrit.libreoffice.org/18888
Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Diffstat (limited to 'source/text/scalc/01/ex_data_stat_func.xhp')
| -rw-r--r-- | source/text/scalc/01/ex_data_stat_func.xhp | 125 |
1 files changed, 125 insertions, 0 deletions
diff --git a/source/text/scalc/01/ex_data_stat_func.xhp b/source/text/scalc/01/ex_data_stat_func.xhp new file mode 100644 index 0000000000..b85b770353 --- /dev/null +++ b/source/text/scalc/01/ex_data_stat_func.xhp @@ -0,0 +1,125 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * +--> + +<meta> + <topic id="textscalc01func_averageifxml"> + <title id="tit" xml-lang="en-US">Examples Dataset for Statistical Functions</title> + <filename>/text/scalc/01/ex_data_stat_func.xhp</filename> + </topic> +</meta> + +<body> +<paragraph id="hd_id182061916311770" role="heading" level="2" xml-lang="en-US">Examples Dataset for a family of the AVERAGE</paragraph> +<section id="ex_func_average"> +<paragraph id="hd_id2657394931588" role="heading" level="3" xml-lang="en-US">Examples</paragraph> +<paragraph id="hd_id2609201512474295" role="heading" level="4" xml-lang="en-US">Consider the following table</paragraph> +<table id="table_averageif_example"> + <tablerow> + <tablecell> + </tablecell> + <tablecell> + <paragraph id="par_id2509201517430799" role="tablehead" localize="false" xml-lang="en-US">A</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id250920151743116" role="tablehead" localize="false" xml-lang="en-US">B</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201517431582" role="tablehead" localize="false" xml-lang="en-US">C</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2509201517431967" role="tablehead" localize="false" xml-lang="en-US">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id18260631312423" role="tablecontent" xml-lang="en-US">Product Name</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201517433075" role="tablecontent" xml-lang="en-US">Sales</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201519383294" role="tablecontent" xml-lang="en-US">Revenue</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id959660094035" role="tablehead" localize="false" xml-lang="en-US">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2855779586764" role="tablecontent" xml-lang="en-US">pencil</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id110202156219769" role="tablecontent" localize="false" xml-lang="en-US">20</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id23281929326512" role="tablecontent" localize="false" xml-lang="en-US">65</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2509201517432278" role="tablehead" localize="false" xml-lang="en-US">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id24967262611733" role="tablecontent" xml-lang="en-US">pen</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201517433391" role="tablecontent" localize="false" xml-lang="en-US">35</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id250920151938352" role="tablecontent" localize="false" xml-lang="en-US">85</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id250920151743267" role="tablehead" localize="false" xml-lang="en-US">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id252542413030532" role="tablecontent" xml-lang="en-US">notebook</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201517433781" role="tablecontent" localize="false" xml-lang="en-US">20</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201519383822" role="tablecontent" localize="false" xml-lang="en-US">190</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id2509201519371339" role="tablehead" localize="false" xml-lang="en-US">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201519374677" role="tablecontent" xml-lang="en-US">book</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201519373350" role="tablecontent" localize="false" xml-lang="en-US">17</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id2509201519384171" role="tablecontent" localize="false" xml-lang="en-US">180</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id6009596127912" role="tablehead" localize="false" xml-lang="en-US">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id19479417931163" role="tablecontent" xml-lang="en-US">pencil-case</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id85353130721737" role="tablecontent" xml-lang="en-US">not</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id15693941827291" role="tablecontent" xml-lang="en-US">not</paragraph> + </tablecell> + </tablerow> +</table> +</section> +</body> +</helpdocument> |