summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-07-20 20:18:56 -0300
committerCaolán McNamara <caolanm@redhat.com>2014-07-21 08:08:14 +0000
commit7a0a3f1e2063343be1325f6fc5136e597606a107 (patch)
treef438081f80e3edb2ded78c6f5ec172c47128c94f
parent678f0e0d9c99e25a66c17450a58a888e2b0213e0 (diff)
Fix fdo#80433 help pages for new T functions
T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T and T.TEST Change-Id: I65fc995e0131cfcc528d64984ceafed25cd74fbc Reviewed-on: https://gerrit.libreoffice.org/10426 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
-rw-r--r--source/text/scalc/01/04060185.xhp92
1 files changed, 92 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 7baa691a8d..1c0db0c61d 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -334,6 +334,36 @@
<paragraph xml-lang="en-US" id="par_id3156010" role="paragraph" l10n="CHG" oldref="105">
<item type="input">=TINV(0.1;6)</item> returns 1.94</paragraph>
</section>
+<section id="tdotinv">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2949579">
+ <bookmark_value>T.INV function</bookmark_value>
+ <bookmark_value>two tailed inverse of t-distribution</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS" id="bm_id2953155" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2949579" role="heading" level="2" l10n="U" oldref="98">T.INV</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2943232" role="paragraph" l10n="U" oldref="99"><ahelp hid="HID_FUNC_TINV_MS">Returns the two tailed inverse of the t-distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2955101" role="heading" level="3" l10n="U" oldref="100">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949289" role="code" l10n="U" oldref="101">T.INV(Number; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2954070" role="paragraph" l10n="U" oldref="102"><emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2955315" role="paragraph" l10n="U" oldref="103"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2953885" role="heading" level="3" l10n="U" oldref="104">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2956010" role="paragraph" l10n="CHG" oldref="105"><item type="input">=T.INV(0.1;6)</item> returns -1.4397557473.</paragraph>
+</section>
+<section id="tdotinvdot2t">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2849579">
+ <bookmark_value>T.INV.2T function</bookmark_value>
+ <bookmark_value>inverse of two tailed t-distribution</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T" id="bm_id2853155" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2849579" role="heading" level="2" l10n="U" oldref="98">T.INV.2T</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2843232" role="paragraph" l10n="U" oldref="99"><ahelp hid="HID_FUNC_TINV_2T">Calculates the inverse of the two-tailed Student's T Distribution </ahelp>, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2855101" role="heading" level="3" l10n="U" oldref="100">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2849289" role="code" l10n="U" oldref="101">T.INV.2T(Number; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2854070" role="paragraph" l10n="U" oldref="102"><emph>Number</emph> is the probability associated with the two-tailed t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2855315" role="paragraph" l10n="U" oldref="103"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2853885" role="heading" level="3" l10n="U" oldref="104">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2856010" role="paragraph" l10n="CHG" oldref="105"><item type="input">=T.INV.2T(0.25; 10)</item> returns 1.221255395.</paragraph>
+</section>
<section id="ttest">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154129"><bookmark_value>TTEST function</bookmark_value>
</bookmark>
@@ -358,6 +388,22 @@
<item type="input">=TTEST(A1:A50;B1:B50;2;2)</item>
</paragraph>
</section>
+<section id="tdottest">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2954129">
+ <bookmark_value>T.TEST function</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST_MS" id="bm_id2953981" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2954129" role="heading" level="2" l10n="U" oldref="107">T.TEST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2959184" role="paragraph" l10n="U" oldref="108"><ahelp hid="HID_FUNC_TTEST_MS">Returns the probability associated with a Student's t-Test.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2947257" role="heading" level="3" l10n="U" oldref="109">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2951175" role="code" l10n="U" oldref="110">T.TEST(Data1; Data2; Mode; Type)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949202" role="paragraph" l10n="U" oldref="111"><emph>Data1</emph> is the dependent array or range of data for the first record.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2945666" role="paragraph" l10n="U" oldref="112"><emph>Data2</emph> is the dependent array or range of data for the second record.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953903" role="paragraph" l10n="U" oldref="113"><emph>Mode</emph> = 1 calculates the one-tailed test, <emph>Mode</emph> = 2 the two- tailed test.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2955327" role="paragraph" l10n="U" oldref="114"><emph>Type</emph> is the kind of t-test to perform. Type 1 means paired. Type 2 means two samples, equal variance (homoscedastic). Type 3 means two samples, unequal variance (heteroscedastic).</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2959342" role="heading" level="3" l10n="U" oldref="115">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950119" role="paragraph" l10n="U" oldref="116"><item type="input">=T.TEST(A1:A50;B1:B50;2;2)</item></paragraph>
+</section>
<section id="tdist">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154930"><bookmark_value>TDIST function</bookmark_value>
<bookmark_value>t-distribution</bookmark_value>
@@ -381,6 +427,52 @@
<item type="input">=TDIST(12;5;1)</item>
</paragraph>
</section>
+<section id="tdotdist">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2954930">
+ <bookmark_value>T.DIST function</bookmark_value>
+ <bookmark_value>t-distribution</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_MS" id="bm_id2953095" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2954930" role="heading" level="2" l10n="U" oldref="118">T.DIST</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2953372" role="paragraph" l10n="U" oldref="119"><ahelp hid="HID_FUNC_TDIST_MS">Returns the t-distribution.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2949911" role="heading" level="3" l10n="U" oldref="120">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2950521" role="code" l10n="U" oldref="121">T.DIST(Number; DegreesFreedom; Cumulative)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2946991" role="paragraph" l10n="U" oldref="122"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2948824" role="paragraph" l10n="U" oldref="123"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949340" role="paragraph" l10n="U" oldref="124"><emph>Cumulative</emph> = 0 or FALSE returns the probability density function, 1 or TRUE returns the cumulative distribution function.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2959150" role="heading" level="3" l10n="U" oldref="125">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2949773" role="paragraph" l10n="U" oldref="126"><item type="input">=T.DIST(1; 10; TRUE)</item> returns 0.8295534338</paragraph>
+</section>
+<section id="tdotdistdot2t">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id2854930">
+ <bookmark_value>T.DIST.2T function</bookmark_value>
+ <bookmark_value>two tailed t-distribution</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_2T" id="bm_id2853095" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id2854930" role="heading" level="2" l10n="U" oldref="118">T.DIST.2T</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2853372" role="paragraph" l10n="U" oldref="119"><ahelp hid="HID_FUNC_TDIST_2T">Calculates the two-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2849911" role="heading" level="3" l10n="U" oldref="120">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2850521" role="code" l10n="U" oldref="121">T.DIST.2T(Number; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2846991" role="paragraph" l10n="U" oldref="122"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2848824" role="paragraph" l10n="U" oldref="123"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2859150" role="heading" level="3" l10n="U" oldref="125">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2849773" role="paragraph" l10n="U" oldref="126"><item type="input">=T.DIST.2T(1; 10)</item> returns 0.3408931323.</paragraph>
+</section>
+<section id="tdotdistdotrt">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id274930">
+ <bookmark_value>T.DIST.RT function</bookmark_value>
+ <bookmark_value>right tailed t-distribution</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_RT" id="bm_id273095" localize="false"/>
+ <paragraph xml-lang="en-US" id="hd_id274930" role="heading" level="2" l10n="U" oldref="118">T.DIST.RT</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2753372" role="paragraph" l10n="U" oldref="119"><ahelp hid="HID_FUNC_TDIST_RT">Calculates the right-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2749911" role="heading" level="3" l10n="U" oldref="120">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2750521" role="code" l10n="U" oldref="121">T.DIST.RT(Number; DegreesFreedom)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2746991" role="paragraph" l10n="U" oldref="122"><emph>Number</emph> is the value for which the t-distribution is calculated.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2748824" role="paragraph" l10n="U" oldref="123"><emph>DegreesFreedom</emph> is the number of degrees of freedom for the t-distribution.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id2759150" role="heading" level="3" l10n="U" oldref="125">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id2749773" role="paragraph" l10n="U" oldref="126"><item type="input">=T.DIST.RT(1; 10)</item> returns 0.1704465662.</paragraph>
+</section>
<section id="var">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153828"><bookmark_value>VAR function</bookmark_value>
<bookmark_value>variances</bookmark_value>