summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060183.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'source/text/scalc/01/04060183.xhp')
-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 d96f6b17f1..54bc190c9e 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>