Z-test
Calculates the z-Test of two data samples.
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.
Results for z-Test:
The following table shows the z-Test for the data series above:
|
z-แจแแแแฌแแแแ |
||
|
alpha |
0.05 |
|
|
แฐแแแแแแขแฃแ แ แกแแจแฃแแแแก แกแฎแแแแแ |
0 |
|
|
แชแแแแแ 1 |
แชแแแแแ 2 |
|
|
แชแแแแแแ แแแกแแแ แกแแ |
0 |
0 |
|
แกแแจแฃแแแ |
16.9230769231 |
20.4615384615 |
|
แแแแแแ แแแแแแ |
13 |
13 |
|
แแแแแแแแ แกแแจแฃแแแแก แกแฎแแแแแ |
-3.5384615385 |
|
|
z |
#DIV/0! |
|
|
P (Z<=z) แชแแแแฎแ แแแ |
#DIV/0! |
|
|
แแ แแขแแแฃแแ z แชแแแแฎแ แแแ |
1.644853627 |
|
|
P (Z<=z) แแ แแฎแ แแแ |
#DIV/0! |
|
|
แแ แแขแแแฃแแ z แแ แแฎแ แแแ |
1.9599639845 |