Как пользоваться функцией Z.TEST в Excel

Русский	Английский
Z.ТЕСТ	Z.TEST

The Z.TEST function is used to compute the one-tail p-value in a Z-test for large samples in both Excel and Google Sheets. The Z-test assesses the significance of differences between the means of two samples, given known standard deviations and sample sizes. This test is based on the standard normal distribution.

Syntax:

Excel: Z.TEST(array1, array2, tails, type)

Google Sheets: Z.TEST(range1, range2, tails)

array1 (or range1 in Google Sheets) — the first data set for the test.
array2 (or range2 in Google Sheets) — the second data set for the test.
tails — determines whether the test is one-sided or two-sided (1 for one-sided, 2 for two-sided).
type — an optional argument specifying the type of test (1 for paired samples, 2 for independent samples).

Example Scenarios:

1. Suppose you have two data samples and you want to determine if the difference between their averages is statistically significant.

2. You can also use the Z.TEST function to evaluate the effectiveness of a new drug by comparing the results of patients who received the drug to those who received a placebo.