216 lines
7.3 KiB
XML
216 lines
7.3 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<helpdocument version="1.0">
|
|
<!--
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
-->
|
|
|
|
<meta>
|
|
<topic id="tteststat" indexer="include" status="PUBLISH">
|
|
<title id="tit">Paired t-test in Calc</title>
|
|
<filename>/text/scalc/01/statistics_test_t.xhp</filename>
|
|
</topic>
|
|
</meta>
|
|
<body>
|
|
|
|
<bookmark branch="index" id="bm_id05001">
|
|
<bookmark_value>Analysis toolpack;t-test</bookmark_value>
|
|
<bookmark_value>Analysis toolpack;paired t-test</bookmark_value>
|
|
<bookmark_value>t-test;Analysis toolpack</bookmark_value>
|
|
<bookmark_value>paired t-test;Analysis toolpack</bookmark_value>
|
|
<bookmark_value>Data statistics;paired t-test</bookmark_value>
|
|
</bookmark>
|
|
<bookmark branch="hid/.uno:TTestDialog" id="bm_id601704458770471" localize="false"/>
|
|
<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-TTestDialog" id="bm_id551704460497766" localize="false"/>
|
|
<bookmark branch="hid/modules/scalc/ui/ttestdialog/TTestDialog" id="bm_id05002" localize="false"/>
|
|
<bookmark branch="hid/modules/scalc/ui/ttestdialog/@@nowidget@@" id="bm_id05102" localize="false"/>
|
|
<section id="ttest">
|
|
<h1 id="hd_id1000150"><variable id="ttesth1"><link href="text/scalc/01/statistics_test_t.xhp">Paired t-test</link></variable></h1>
|
|
<paragraph id="par_id1002820" role="paragraph"><ahelp hid="modules/scalc/ui/ttestdialog/TTestDialog">Calculates the paired t-Test of two data samples.</ahelp></paragraph>
|
|
</section>
|
|
<section id="howtoget">
|
|
<embed href="text/scalc/00/00000412.xhp#stat_ttest"/>
|
|
</section>
|
|
<paragraph id="par_id1002840" role="paragraph">A <emph>paired t-test</emph> is any statistical hypothesis test that follows a Student's t distribution.</paragraph>
|
|
<note id="par_id1002850">For more information on paired t-tests, refer to the <link href="https://en.wikipedia.org/wiki/T-test">corresponding Wikipedia article</link>.</note>
|
|
<h2 id="hd_id1000160">Data</h2>
|
|
<paragraph id="par_id1002860" role="paragraph"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
|
|
<paragraph id="par_id1002870" role="paragraph"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
|
|
<paragraph id="par_id1002880" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph>
|
|
<embed href="text/scalc/01/stat_data.xhp#grouped"/>
|
|
<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/>
|
|
<embed href="text/scalc/01/stat_data.xhp#datafortests"/>
|
|
<h2 id="hd_id1000170">Results for paired t-test:</h2>
|
|
<paragraph id="par_id1002890" role="paragraph">The following table shows the <emph>paired t-test</emph> for the data series above:</paragraph>
|
|
<table id="Tabela11">
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1002900" role="tablehead">paired t-test</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1002910" role="tablecontent">Alpha</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1002920" role="tablecontent" localize="false">0.05</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1002930" role="tablecontent">Hypothesized Mean Difference</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1002940" role="tablecontent" localize="false">0</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1002950" role="tablecontent">Variable 1</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1002960" role="tablecontent">Variable 2</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1002970" role="tablecontent">Mean</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1002980" role="tablecontent" localize="false">16.9230769231</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1002990" role="tablecontent" localize="false">20.4615384615</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003000" role="tablecontent">Variance</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003010" role="tablecontent" localize="false">125.0769230769</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003020" role="tablecontent" localize="false">94.4358974359</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003030" role="tablecontent">Observations</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003040" role="tablecontent" localize="false">13</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003050" role="tablecontent" localize="false">13</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003060" role="tablecontent">Pearson Correlation</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003070" role="tablecontent" localize="false">-0.0617539772</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003080" role="tablecontent">Observed Mean Difference</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003090" role="tablecontent" localize="false">-3.5384615385</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003100" role="tablecontent">Variance of the Differences</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003110" role="tablecontent" localize="false">232.9358974359</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003120" role="tablecontent">df </paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003130" role="tablecontent" localize="false">12</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003140" role="tablecontent">t Stat</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003150" role="tablecontent" localize="false">-0.8359262137</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003160" role="tablecontent">P (T<=t) one-tail</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003170" role="tablecontent" localize="false">0.2097651442</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003180" role="tablecontent">t Critical one-tail</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003190" role="tablecontent" localize="false">1.7822875556</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003200" role="tablecontent">P (T<=t) two-tail</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003210" role="tablecontent" localize="false">0.4195302884</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph id="par_id1003220" role="tablecontent">t Critical two-tail</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph id="par_id1003230" role="tablecontent" localize="false">2.1788128297</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
</tablecell>
|
|
</tablerow>
|
|
</table>
|
|
<section id="relatedtopics">
|
|
<embed href="text/scalc/01/stat_data.xhp#otherstat"/>
|
|
</section>
|
|
</body>
|
|
</helpdocument>
|