Prova Z

Calculates the z-Test of two data samples.

Per accedir a esta orde...

Choose Data - Statistics - Z-test


note

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


Dades

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.

Agrupat per

Select whether the input data has columns or rows layout.

Exemple

La taula següent conté dos conjunts de dades.

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

Alfa

0.05

Hypothesized Mean Difference

0

Variable 1

Variable 2

Known Variance

0

0

Mean

16.9230769231

20.4615384615

Observacions

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


Ens cal la vostra ajuda!