summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060181.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-06-29 08:41:02 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-06-30 09:16:12 +0000
commit34bf0f108f0ddafa5675b3723675a7cd611d274b (patch)
tree663c9e5de4e9528185542a219d55cef5402f2c7e /source/text/scalc/01/04060181.xhp
parent74944d4f7fb26dd0db7a94cebf8c66d3023b4aa6 (diff)
Fix fdo#80446: Help entries for BETA.DIST BETA.INV
Change-Id: Ic8570dbe6cfe0bd5ed93ac43cd95470518abedc5 Reviewed-on: https://gerrit.libreoffice.org/9961 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
Diffstat (limited to 'source/text/scalc/01/04060181.xhp')
-rw-r--r--source/text/scalc/01/04060181.xhp39
1 files changed, 39 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 1bf97fc18a..24d7963365 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -163,6 +163,25 @@
<paragraph xml-lang="en-US" id="par_id3146859" role="paragraph" l10n="U" oldref="62">
<item type="input">=BETAINV(0.5;5;10)</item> returns the value 0.33.</paragraph>
</section>
+ <section id="betadotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2945620"><bookmark_value>BETA.INV function</bookmark_value>
+ <bookmark_value>cumulative probability density function;inverse of</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETAINV_MS" id="bm_id2946154" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2945620" role="heading" level="2" l10n="U" oldref="52">BETA.INV</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949825" role="paragraph" l10n="U" oldref="53"><ahelp hid="HID_FUNC_BETAINV_MS">Returns the inverse of the cumulative beta probability density function.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2952479" role="heading" level="3" l10n="U" oldref="54">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956300" role="code" l10n="U" oldref="55">BETA.INV(Number; Alpha; Beta; Start; End)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949266" role="paragraph" l10n="U" oldref="56"><emph>Number</emph> is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949710" role="paragraph" l10n="U" oldref="57"><emph>Alpha</emph> is a parameter to the distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956306" role="paragraph" l10n="U" oldref="58"><emph>Beta</emph> is a parameter to the distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950960" role="paragraph" l10n="U" oldref="59"><emph>Start</emph> (optional) is the lower bound for <emph>Number</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2951268" role="paragraph" l10n="U" oldref="60"><emph>End</emph> (optional) is the upper bound for <emph>Number</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_idN109DFms" role="paragraph" l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2947077" role="heading" level="3" l10n="U" oldref="61">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2946859" role="paragraph" l10n="U" oldref="62">
+ <item type="input">=BETA.INV(0.5;5;10)</item> returns the value 0.3257511553.</paragraph>
+ </section>
<section id="betadist">
<bookmark xml-lang="en-US" branch="index" id="bm_id3156096"><bookmark_value>BETADIST function</bookmark_value>
<bookmark_value>cumulative probability density function;calculating</bookmark_value>
@@ -194,6 +213,26 @@
<paragraph xml-lang="en-US" id="par_id3156118" role="paragraph" l10n="U" oldref="74">
<item type="input">=BETADIST(0.75;3;4)</item> returns the value 0.96</paragraph>
</section>
+ <section id="betadotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2956096"><bookmark_value>BETA.DIST function</bookmark_value>
+ <bookmark_value>cumulative probability density function;calculating</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BETADIST_MS" id="bm_id2953213" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2956096" role="heading" level="2" l10n="U" oldref="64">BETA.DIST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950880" role="paragraph" l10n="U" oldref="65"><ahelp hid="HID_FUNC_BETADIST_MS">Returns the beta function.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2950762" role="heading" level="3" l10n="U" oldref="66">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2947571" role="code" l10n="CHG" oldref="67">BETA.DIST(Number; Alpha; Beta; Cumulative; Start; End)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956317" role="paragraph" l10n="U" oldref="68"><emph>Number</emph> (required) is the value between <emph>Start</emph> and <emph>End</emph> at which to evaluate the function.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956107" role="paragraph" l10n="U" oldref="69"><emph>Alpha</emph> (required) is a parameter to the distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953619" role="paragraph" l10n="U" oldref="70"><emph>Beta</emph> (required) is a parameter to the distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id062920141254453" role="paragraph" l10n="NEW"><emph>Cumulative</emph> (required) can be 0 or False to calculate the probability density function. It can be any other value or True or omitted to calculate the cumulative distribution function.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950254" role="paragraph" l10n="U" oldref="71"><emph>Start</emph> (optional) is the lower bound for <emph>Number</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949138" role="paragraph" l10n="U" oldref="72"><emph>End</emph> (optional) is the upper bound for <emph>Number</emph>.</paragraph>
+ <paragraph xml-lang="en-US" id="par_idN10AB3ms" role="paragraph" l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2945649" role="heading" level="3" l10n="U" oldref="73">Examples</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956118" role="paragraph" l10n="U" oldref="74"><item type="input">=BETA.DIST(2;8;10;1;1;3)</item> returns the value 0.6854706</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956119" role="paragraph" l10n="U" oldref="74"><item type="input">=BETA.DIST(2;8;10;0;1;3)</item> returns the value 1.4837646</paragraph>
+ </section>
<section id="binomdist">
<bookmark xml-lang="en-US" branch="index" id="bm_id3143228"><bookmark_value>BINOMDIST function</bookmark_value>
</bookmark>