SheetFX
≡
<< Go back to all functions

Z.TEST

The Z.TEST function in Google Sheets returns the one-tailed P-value of a Z-test with standard distribution. It is used to determine the probability that a value is drawn from a standard normal distribution. This function is commonly used in statistical analysis and hypothesis testing.

Function Syntax and Parameters

Syntax: Z.TEST(data, value, [standard_deviation])

Parameters:

  • data: The array or range containing the dataset.
  • value: The value to be tested against the null hypothesis.
  • standard_deviation (optional): The standard deviation of the population. If omitted, the sample standard deviation will be used.

Step-by-Step Tutorial

  1. Performing a Z-test on a dataset:

    • Example: If the dataset is in cells A1:A10 and the value to be tested is in cell B1, use the formula =Z.TEST(A1:A10, B1).

  2. Performing a Z-test with a specified standard deviation:

    • Example: If the dataset is in cells A1:A10, the value to be tested is in cell B1, and the standard deviation is in cell C1, use the formula =Z.TEST(A1:A10, B1, C1).

Use Cases and Scenarios

  1. Hypothesis Testing: Determine the statistical significance of a sample or experiment.
  2. Quality Control: Verify if a process is functioning within acceptable limits.
  3. Market Research: Analyze survey data to draw conclusions about a population.

Related Functions

  • T.TEST: Perform a t-test for two samples.

Related Articles