diff options
| author | Olivier Hallot <olivier.hallot@edx.srv.br> | 2014-07-19 11:18:55 -0300 |
|---|---|---|
| committer | Caolán McNamara <caolanm@redhat.com> | 2014-07-21 08:06:10 +0000 |
| commit | 3da3b8063d11ea0d584753e17d13f6ad6b9b0aa4 (patch) | |
| tree | 4a95d417799419845fdfcb6f4be2dcef428bc06c /source | |
| parent | a8c8f80b933a42a284e681c1d1973166445a4451 (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>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060183.xhp | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index 0e617b9019..d96f6b17f1 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> |