Z-test

Calculates the z-Test of two data samples.

β€‹β€‹αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž”αŸ’αžšαžΎβ€‹β€‹αž”αž‰αŸ’αž‡αžΆβ€‹αž“αŸαŸ‡...

From the menu bar:

Choose Data - Statistics - Z-test

From the tabbed interface:

Choose Data - Statistics - Z-test.

On the Data menu of the Data tab, choose Statistics - Z-test.


note

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


αž‘αž·αž“αŸ’αž“αž“αŸαž™

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.

Grouped By

Select whether the input data has columns or rows layout.

Open file with example:

αž§αž‘αžΆαž αžšαžŽαŸ

The following table has two data sets.

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

αž’αžΆαž›αŸ‹αž αŸ’αžœαžΆ

0.05

Hypothesized Mean Difference

0

Variable 1

Variable 2

Known Variance

0

0

αž˜αž’αŸ’αž™αž˜

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


Please support us!