summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060182.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-06-26 09:04:37 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-06-26 15:39:06 +0000
commitcb00f782515e7a11796d7996e89073a4ecfdb3d7 (patch)
tree5e3272b68c531afcad89345780ec65dc5d11fd4a /source/text/scalc/01/04060182.xhp
parentc18a4da59f386b125bf65adc0238a4fa712910a5 (diff)
Fix bug fdo#80431 Help entries for GAMMA functions
Provides help entries for functions GAMMA.DIST GAMMA.INV and GAMMALN.PRECISE Change-Id: I9a675d40f7eca6a799e49706e062ea77e05feffd Reviewed-on: https://gerrit.libreoffice.org/9916 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
Diffstat (limited to 'source/text/scalc/01/04060182.xhp')
-rw-r--r--source/text/scalc/01/04060182.xhp59
1 files changed, 59 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index f462edb16..3d595d033 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -155,6 +155,29 @@
<paragraph xml-lang="en-US" id="par_id3153331" role="paragraph" l10n="U" oldref="55">
<item type="input">=GAMMAINV(0.8;1;1)</item> yields 1.61.</paragraph>
</section>
+
+ <section id="gammadotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2914841"><bookmark_value>GAMMA.INV function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAINV_MS" id="bm_id2919249" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2914841" role="heading" level="2" l10n="U"
+ oldref="47">GAMMA.INV</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2913932" role="paragraph" l10n="U" oldref="48"><ahelp hid="HID_FUNC_GAMMAINV_MS">Returns the inverse of the Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to search for variables with different distribution.</paragraph>
+ <paragraph id="par_id291422405814" role="paragraph" xml-lang="en-US">This function is identical to GAMAINV and was introduced for interoperability with other office suites.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2919949" role="heading" level="3" l10n="U"
+ oldref="49">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2915828" role="code" l10n="U" oldref="50">GAMMA.INV(Number; Alpha; Beta)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2915138" role="paragraph" l10n="U" oldref="51">
+ <emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2912785" role="paragraph" l10n="U" oldref="52">
+ <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2914561" role="paragraph" l10n="U" oldref="53">
+ <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2918734" role="heading" level="3" l10n="U"
+ oldref="54">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph" l10n="U" oldref="55">
+ <item type="input">=GAMMA.INV(0.8;1;1)</item> yields 1.61.</paragraph>
+ </section>
<section id="gammaln">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value>
<bookmark_value>natural logarithm of Gamma function</bookmark_value>
@@ -173,6 +196,24 @@
<paragraph xml-lang="en-US" id="par_id3153730" role="paragraph" l10n="U" oldref="63">
<item type="input">=GAMMALN(2)</item> yields 0.</paragraph>
</section>
+ <section id="gammalnprecise">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2914806"><bookmark_value>GAMMALN.PRECISE function</bookmark_value>
+ <bookmark_value>natural logarithm of Gamma function</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN_MS" id="bm_id2919511" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2914806" role="heading" level="2" l10n="U"
+ oldref="57">GAMMALN.PRECISE</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2918572" role="paragraph" l10n="U" oldref="58"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2912999" role="heading" level="3" l10n="U"
+ oldref="59">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2913112" role="code" l10n="U" oldref="60">GAMMALN.PRECISE(Number)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2914502" role="paragraph" l10n="U" oldref="61">
+ <emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2913568" role="heading" level="3" l10n="U"
+ oldref="62">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph" l10n="U" oldref="63">
+ <item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph>
+ </section>
<section id="gammadist">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value>
</bookmark>
@@ -197,6 +238,24 @@
<paragraph xml-lang="en-US" id="par_id3145354" role="paragraph" l10n="U" oldref="74">
<item type="input">=GAMMADIST(2;1;1;1)</item> yields 0.86.</paragraph>
</section>
+ <section id="gammadotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id240620142206421">
+<bookmark_value>GAMMA.DIST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMADIST_MS" id="bm_id2406201421290724" localize="false"/>
+<paragraph id="hd_id2406201422120061" role="heading" xml-lang="en-US" level="2">GAMMA.DIST</paragraph>
+<paragraph id="par_id2406201422414690" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GAMMADIST_MS">Returns the values of a Gamma distribution.</ahelp></paragraph>
+<paragraph id="par_id24061422414690" role="paragraph" xml-lang="en-US">The inverse function is GAMMAINV or GAMMA.INV.</paragraph>
+<paragraph id="par_id2406201422405814" role="paragraph" xml-lang="en-US">This function is identical to GAMADIST and was introduced for interoperability with other office suites.</paragraph>
+<paragraph id="hd_id2406201422383599" role="heading" xml-lang="en-US" level="3">Syntax</paragraph>
+<paragraph id="par_id240620142238475" role="code" xml-lang="en-US">GAMMA.DIST(Number; Alpha; Beta; C)</paragraph>
+<paragraph id="par_id2406201422385134" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph>
+<paragraph id="par_id2406201422385590" role="paragraph" xml-lang="en-US"><emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
+<paragraph id="par_id2406201422390458" role="paragraph" xml-lang="en-US"><emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph>
+<paragraph id="par_id2406201422391058" role="paragraph" xml-lang="en-US"><emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph>
+<paragraph id="hd_id2406201422391870" role="heading" xml-lang="en-US" level="3">Example</paragraph>
+<paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph>
+</section>
<section id="gauss">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value>
<bookmark_value>normal distribution; standard</bookmark_value>