Manuals/calci/ZTESTEQUALMEANS
ZTESTTWOSAMPLEFORMEANS(Array1, Array2, Variance1, Variance2, Alpha, NewTableFlag)
where,
Array1 - Input range should be one block.
Array2 - Input range should be one block.
Variance1 - Input range should be one block.
Variance2 - Input range should be one block.
HypothesizeDiff - represents the Hypothesized Mean Difference.A value 0 indicates that sample means are hypothesized to be equal.
Alpha - represents the significance level and value in range 0 to 1.
' 'NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.Lets see an example in (Column4Row5)
=ZTESTTWOSAMPLESFORMEANS (R1C1:R4C1, R1C2:R4C2, R1C3:R4C3, R1C4:R4C3, 0, 0.05, TRUE)
ZTESTTWOSAMPLESFORMEANS returns the result in new sheet(5Space).
=ZTESTTWOSAMPLESFORMEANS(R1C1:R4C1, R1C2:R4C2, R1C3:R4C3, R1C4:R4C3, 0, -0.055, TRUE)
ZTESTTWOSAMPLESFORMEANS returns the #ERROR(Alpha = -0.055).
Z-TEST : TWO SAMPLE FOR MEANS
If the Alpha < 0 or Alpha >1, ZTESTTWOSAMPLEFORMEANS returns the #ERROR.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10 | 3 | 1 | 8 |
| Row2 | 7 | 8 | 2 | 9 |
| Row3 | 12 | 8 | 3 | 10 |
| Row4 | 17 | 18 | 4 | 11 |
| Row5 | 46 | 34 | 5Space | |
| Row6 | 6 | 7 | #ERROR |
| Variable1 | Variable2 | |
|---|---|---|
| Mean | 11.5 | 9.25 |
| Known Variance | 1,2,3,4 | 8,9,10,11 |
| Observations | 4 | 4 |
| Hypothesized Mean Difference | 0 | |
| z Value | NaN | |
| P(T<=t) One-tail | 0 | |
| z Critical One-tail | 1.6448536269514715 | |
| P(T<=t) Two-tail | 0 | |
| z Critical Two-tail | 1.9599639845400536 |