Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-09-21 Thread Eike Rathke
Hi Leonard, Just returned from vacation, hence the silence.. On Friday, 2009-09-11 00:43:09 +0200, Leonard Mada wrote: > I might be too late, Yes, too late, UI string changes aren't allowed anymore. > but the following small correction > sounds slightly better: > > Calculates the probability

[sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-09-10 Thread Leonard Mada
Hello Eike, I might be too late, but the following small correction sounds slightly better: Calculates the probability of observing a z-statistic greater than the one computed based on *the* sample. Original-Nachricht > Datum: 3 Sep 2009 12:34:44 - > Von: e...@openoffice.or

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-26 Thread Leonard Mada
a z-statistic as extreme or more extreme than that observed with our real sample. It is the probability of drawing such a sample, not of comparing 2 samples.] Original-Nachricht > Datum: Wed, 26 Aug 2009 22:35:29 +0200 > Von: Eike Rathke > An: dev@sc.openoffice.o

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-26 Thread Eike Rathke
Hi Regina, On Wednesday, 2009-08-26 18:02:44 +0200, Regina Henschel wrote: >> "calculates the probability of observing a value as large >> or larger for the z-statistic" > > There is a comparison "observing a value larger" but it does not > contain, to what it is compared. There must be someth

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-26 Thread Regina Henschel
Hi Eike, hi Leonard, Eike Rathke schrieb: Hi Leonard, On Tuesday, 2009-08-25 15:45:42 +0200, Leonard Mada wrote: I would therefore stick with the one sample definition, and adapt only the text to correspond to what actually the function computes. "The p-value is the probability, under the nu

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-26 Thread Eike Rathke
Hi Leonard, On Tuesday, 2009-08-25 15:45:42 +0200, Leonard Mada wrote: > I would therefore stick with the one sample definition, > and adapt only the text to correspond to what actually > the function computes. > > "The p-value is the probability, under the null hypothesis, > of observing a val

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-25 Thread Leonard Mada
ncern, then compacting "as large or larger" will result in: "calculates the probability of observing a value larger than the z-statistic" Sincerely, Leonard Mada Original-Nachricht > Datum: Tue, 25 Aug 2009 14:23:33 +0200 > Von: Regina Henschel >

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-25 Thread Regina Henschel
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 woul

[sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-25 Thread Leonard Mada
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] So, does it compute the probabilities based on 2 samples? I doubt it. I may