<?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/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="zteststat" indexer="include" status="PUBLISH">
<title id="tit">Z Test Statistics in Calc</title>
<filename>/text/scalc/01/statistics_test_z.xhp</filename>
</topic>
</meta>
<body>
<bookmark branch="index" id="bm_id05003">
<bookmark_value>Analysis toolpack;Z-test</bookmark_value>
<bookmark_value>Z-test;Analysis toolpack</bookmark_value>
<bookmark_value>Data statistics;Z-test</bookmark_value>
</bookmark>
<bookmark branch="hid/.uno:ZTestDialog" id="bm_id541704458842579" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuStatistic-ZTestDialog" id="bm_id441704459441338" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/ztestdialog/ZTestDialog" id="bm_id05004" localize="false"/>
<bookmark branch="hid/modules/scalc/ui/ztestdialog/@@nowidget@@" id="bm_id05104" localize="false"/>
<section id="ztest">
<h1 id="hd_id1000210"><variable id="ztesth1"><link href="text/scalc/01/statistics_test_z.xhp">Z-test</link></variable></h1>
<paragraph id="par_id1003640" role="paragraph"><ahelp hid="modules/scalc/ui/ztestdialog/ZTestDialog">Calculates the z-Test of two data samples.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000412.xhp#stat_ztest"/>
</section>
<note id="par_id1003660">For more information on Z-tests, refer to the <link href="https://en.wikipedia.org/wiki/Z-test">corresponding Wikipedia article</link>.</note>
<h2 id="hd_id1000220">Data</h2>
<paragraph id="par_id1003670" role="paragraph"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph>
<paragraph id="par_id1003680" role="paragraph"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph>
<paragraph id="par_id1003690" 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_id1000230">Results for z-Test:</h2>
<paragraph id="par_id1003700" role="paragraph">The following table shows the <emph>z-Test</emph> for the data series above:</paragraph>
<table id="Tabela13">
<tablerow>
<tablecell>
<paragraph id="par_id1003710" role="tablecontent">z-test</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003720" role="tablecontent">Alpha</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003730" role="tablecontent" localize="false">0.05</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003740" role="tablecontent">Hypothesized Mean Difference</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003750" role="tablecontent" localize="false">0</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
</tablecell>
<tablecell>
<paragraph id="par_id1003760" role="tablecontent">Variable 1</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003770" role="tablecontent">Variable 2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003780" role="tablecontent">Known Variance</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003790" role="tablecontent" localize="false">0</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003800" role="tablecontent" localize="false">0</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003810" role="tablecontent">Mean</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003820" role="tablecontent" localize="false">16.9230769231</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003830" role="tablecontent" localize="false">20.4615384615</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003840" role="tablecontent">Observations</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003850" role="tablecontent" localize="false">13</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003860" role="tablecontent" localize="false">13</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003870" role="tablecontent">Observed Mean Difference</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003880" role="tablecontent" localize="false">-3.5384615385</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003890" role="tablecontent">z</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003900" role="tablecontent">#DIV/0!</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003910" role="tablecontent">P (Z<=z) one-tail</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003920" role="tablecontent">#DIV/0!</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003930" role="tablecontent">z Critical one-tail</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003940" role="tablecontent" localize="false">1.644853627</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003950" role="tablecontent">P (Z<=z) two-tail</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003960" role="tablecontent">#DIV/0!</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id1003970" role="tablecontent">z Critical two-tail</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id1003980" role="tablecontent" localize="false">1.9599639845</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
</table>
<section id="relatedtopics">
<embed href="text/scalc/01/stat_data.xhp#otherstat"/>
</section>
</body>
</helpdocument>