summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-07-19 11:18:55 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-07-21 08:06:10 +0000
commit3da3b8063d11ea0d584753e17d13f6ad6b9b0aa4 (patch)
tree4a95d417799419845fdfcb6f4be2dcef428bc06c
parenta8c8f80b933a42a284e681c1d1973166445a4451 (diff)
Fix fdo#80449: help text for CONFIDENCE functions
CONFIDENCE.T and CONFIDENCE.NORM Change-Id: Ie63eddc86dfd1de116acc980d5d672678279e779 Reviewed-on: https://gerrit.libreoffice.org/10408 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
-rw-r--r--source/text/scalc/01/04060183.xhp38
1 files changed, 38 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp
index 0e617b901..d96f6b17f 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -80,6 +80,44 @@
<paragraph role="paragraph" id="par_id3153335" xml-lang="en-US" l10n="U" oldref="28">
<item type="input">=CONFIDENCE(0.05;1.5;100)</item> gives 0.29.</paragraph>
</section>
+<section id="confidencedott">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2953559"><bookmark_value>CONFIDENCE.T function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CONFIDENCE_T" id="bm_id2953803" localize="false"/>
+<paragraph role="heading" id="hd_id2953559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE.T</paragraph>
+<paragraph role="paragraph" id="par_id2953814" xml-lang="en-US" l10n="U" oldref="21">
+ <ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence interval for a Student's t distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id2949315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph>
+<paragraph role="code" id="par_id2947501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE.T(Alpha; StDev; Size)</paragraph>
+<paragraph role="paragraph" id="par_id2949872" xml-lang="en-US" l10n="U" oldref="24">
+<emph>Alpha</emph> is the level of the confidence interval.</paragraph>
+<paragraph role="paragraph" id="par_id2945324" xml-lang="en-US" l10n="U" oldref="25">
+<emph>StDev</emph> is the standard deviation for the total population.</paragraph>
+<paragraph role="paragraph" id="par_id2953075" xml-lang="en-US" l10n="U" oldref="26">
+<emph>Size</emph> is the size of the total population.</paragraph>
+<paragraph role="heading" id="hd_id2950435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph>
+<paragraph role="paragraph" id="par_id2953335" xml-lang="en-US" l10n="U" oldref="28">
+<item type="input">=CONFIDENCE.T(0.05;1.5;100)</item> gives 0.2976325427.</paragraph>
+</section>
+<section id="confidencedotnorm">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2853559"><bookmark_value>CONFIDENCE.NORM function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CONFIDENCE_N" id="bm_id2853803" localize="false"/>
+<paragraph role="heading" id="hd_id2853559" xml-lang="en-US" level="2" l10n="U" oldref="20">CONFIDENCE.NORM</paragraph>
+<paragraph role="paragraph" id="par_id2853814" xml-lang="en-US" l10n="U" oldref="21">
+ <ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence interval for a normal distribution.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id2849315" xml-lang="en-US" level="3" l10n="U" oldref="22">Syntax</paragraph>
+<paragraph role="code" id="par_id2847501" xml-lang="en-US" l10n="U" oldref="23">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph>
+<paragraph role="paragraph" id="par_id2849872" xml-lang="en-US" l10n="U" oldref="24">
+<emph>Alpha</emph> is the level of the confidence interval.</paragraph>
+<paragraph role="paragraph" id="par_id2845324" xml-lang="en-US" l10n="U" oldref="25">
+<emph>StDev</emph> is the standard deviation for the total population.</paragraph>
+<paragraph role="paragraph" id="par_id2853075" xml-lang="en-US" l10n="U" oldref="26">
+<emph>Size</emph> is the size of the total population.</paragraph>
+<paragraph role="heading" id="hd_id2850435" xml-lang="en-US" level="3" l10n="U" oldref="27">Example</paragraph>
+<paragraph role="paragraph" id="par_id2853335" xml-lang="en-US" l10n="U" oldref="28">
+<item type="input">=CONFIDENCE.NORM(0.05;1.5;100)</item> gives 0.2939945977.</paragraph>
+</section>
<section id="correl">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148746"><bookmark_value>CORREL function</bookmark_value>
<bookmark_value>coefficient of correlation</bookmark_value>