Regina Henschel
Tue, 25 Aug 2009 05:24:05 -0700
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