Hi Leonard,

Leonard Mada schrieb:
Dear Calc team,

the following wording is ambiguous and it may be wrong altogether:

function description:
calculates the probability of a *sample* mean greater than the mean of
the given *sample*.
[EMPHASIS ADDED]

A long phrase for the application help would be:

For a given random sample of size n, drawn from a normally distributed population with a known mean µ and standard deviation sigma, ZTEST calculates the probability that another sample of the same size would have a mean greater than the mean m of the given sample.

ZTEST calculates 1-NORMSDIST(z) where z = (m-µ)/(sigma/sqrt(n)).


The function ZTEST is not a Z-test, but you can calculate a value by ZTEST, which you can use to perform a Z-test.

Do you know a better phrase, that *does not exceed two lines* for the function wizard? We can explain the function in detail on the Wiki, where you already find the formula and nice diagramms. The problem is, to get a very short description, without given such useless phrases like for TTest, where you find "Calculates the T test" in the function wizard and "Returns the probability associated with a Student's t-Test." in the application help.

kind regards
Regina



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org

Reply via email to