<div class="raw-html-embed">    <p>The <b>ZTEST</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to return the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, <b>ZTEST</b> returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>ZTEST(array, x, [sigma])</em></b></p>
    <p>The <b>ZTEST</b> function has the following arguments:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                <th style="background-color: #f4f4f4"><b>Description</b></th>
            </tr>
            <tr>
                <td><b><em>array</em></b></td>
                <td>The range of numeric values against which to test <b><em>x</em></b>.</td>
            </tr>
            <tr>
                <td><b><em>x</em></b></td>
                <td>The value to test.</td>
            </tr>
            <tr>
                <td><b><em>sigma</em></b></td>
                <td>A population standard deviation. This is an optional argument. If it is omitted, the sample standard deviation is used.</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>ZTEST</b> function.</p>

    <h5 class="pt8">Examples</h5>
    <p>The figure below displays the result returned by the <b>ZTEST</b> function.</p>
    <p><img alt="ZTEST Function" src="https://static-helpcenter.teamlab.info/ztest_52df87641a.png"></p></div>

ZTEST Function

Docs

Argument	Description
*array*	The range of numeric values against which to test x.
x	The value to test.
*sigma*	A population standard deviation. This is an optional argument. If it is omitted, the sample standard deviation is used.

ZTEST Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud