summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-07-26 23:19:36 -0300
committerDavid Tardon <dtardon@redhat.com>2014-07-27 08:16:59 +0000
commit762152378c05a12e0670b20b1125633d8c57dfcb (patch)
tree7e4dfc7df9650613a24fc3120dab1fb288c8cb0c
parent7f0032fe6975853065f593830c82ff37a9f61cd5 (diff)
Fix fdo#80443: Help pages for COVARIANCE functions
Help page for COVARIANCE.P and COVARIANCE.S spreadsheet functions Change-Id: I130ec30ece2ec31cc540ab9e651140b2ea1ed07c Reviewed-on: https://gerrit.libreoffice.org/10567 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
-rw-r--r--source/text/scalc/01/04060183.xhp28
1 files changed, 28 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index d96f6b17f..54bc190c9 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -152,6 +152,34 @@
<item type="input">=COVAR(A1:A30;B1:B30)</item>
</paragraph>
</section>
+<section id="covariancedotp">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2950652">
+ <bookmark_value>COVARIANCE.P function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P" id="bm_id2952983" localize="false"/>
+ <paragraph role="heading" id="hd_id2950652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVARIANCE.P</paragraph>
+ <paragraph role="paragraph" id="par_id2946875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired deviations, for the entire population.</ahelp></paragraph>
+ <paragraph role="heading" id="hd_id2949013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph>
+ <paragraph role="code" id="par_id2950740" xml-lang="en-US" l10n="U" oldref="42">COVARIANCE.P(Data1; Data2)</paragraph>
+ <paragraph role="paragraph" id="par_id2945827" xml-lang="en-US" l10n="U" oldref="43"><emph>Data1</emph> is the first data set.</paragraph>
+ <paragraph role="paragraph" id="par_id2950465" xml-lang="en-US" l10n="U" oldref="44"><emph>Data2</emph> is the second data set.</paragraph>
+ <paragraph role="heading" id="hd_id2954677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph>
+ <paragraph role="paragraph" id="par_id2944748" xml-lang="en-US" l10n="U" oldref="46"><item type="input">=COVARIANCE.P(A1:A30;B1:B30)</item></paragraph>
+</section>
+<section id="covariancedots">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id280652">
+ <bookmark_value>COVARIANCE.S function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S" id="bm_id2852983" localize="false"/>
+ <paragraph role="heading" id="hd_id2850652" xml-lang="en-US" level="2" l10n="U" oldref="39">COVARIANCE.S</paragraph>
+ <paragraph role="paragraph" id="par_id2846875" xml-lang="en-US" l10n="U" oldref="40"><ahelp hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired deviations, for a sample of the population.</ahelp></paragraph>
+ <paragraph role="heading" id="hd_id2849013" xml-lang="en-US" level="3" l10n="U" oldref="41">Syntax</paragraph>
+ <paragraph role="code" id="par_id2850740" xml-lang="en-US" l10n="U" oldref="42">COVARIANCE.S(Data1; Data2)</paragraph>
+ <paragraph role="paragraph" id="par_id2845827" xml-lang="en-US" l10n="U" oldref="43"><emph>Data1</emph> is the first data set.</paragraph>
+ <paragraph role="paragraph" id="par_id2850465" xml-lang="en-US" l10n="U" oldref="44"><emph>Data2</emph> is the second data set.</paragraph>
+ <paragraph role="heading" id="hd_id284677" xml-lang="en-US" level="3" l10n="U" oldref="45">Example</paragraph>
+ <paragraph role="paragraph" id="par_id2844748" xml-lang="en-US" l10n="U" oldref="46"><item type="input">=COVARIANCE.S(A1:A30;B1:B30)</item></paragraph>
+</section>
<section id="critbinom">
<bookmark xml-lang="en-US" branch="index" id="bm_id3147472"><bookmark_value>CRITBINOM function</bookmark_value>
</bookmark>