Z-test

Calculates the z-Test of two data samples.

要访问此命令...

Choose Data - Statistics - Z-test


note

For more information on Z-tests, refer to the corresponding Wikipedia article.


Data

Variable 1 range: The reference of the range of the first data series to analyze.

Variable 2 range: The reference of the range of the second data series to analyze.

Results to: The reference of the top left cell of the range where the test will be displayed.

分组条件

选择输入数据是否具有「」或「」布局。

示例

下表有两组数据集。

A

B

1

28

19

2

26

13

3

31

12

4

23

5

5

20

34

6

27

31

7

28

31

8

14

12

9

4

24

10

0

23

11

2

19

12

8

10

13

9

33


Results for z-Test:

The following table shows the z-Test for the data series above:

z-test

Alpha

0.05

Hypothesized Mean Difference

0

Variable 1

Variable 2

Known Variance

0

0

Mean

16.9230769231

20.4615384615

Observations

13

13

Observed Mean Difference

-3.5384615385

z

#DIV/0!

P (Z<=z) one-tail

#DIV/0!

z Critical one-tail

1.644853627

P (Z<=z) two-tail

#DIV/0!

z Critical two-tail

1.9599639845


请支持我们!