Re: [office-formula] ZTEST

[Stefan Nikolaus <stefan.nikolaus@kdemail.net>]

On Friday 09 February 2007 12:56:09 Stefan Nikolaus(UNTRUSTED, sender is 
<srs0=vgmu=hr=lists.oasis-open.org=office-formula-return-280-stefan.nikolaus=opendocument.us@bounce.secureserver.net>) 
wrote:
> gauss() is the method returning the value for GAUSS (what a surprise ;-) ).
> And that is defined as NORMDIST(x)-0.5. NORMDIST(x) returns the value of
> the normal distribution pdf (!) at position x. Is that what you call the
> p-value? I think not. You want the value of the cdf! Otherwise, it makes no
> sense at all (AFAICT).

Whoops. I got this wrong: the default of NORMDIST() is to return the cdf. That 
means
                PushDouble(0.5 - gauss((mue-x)/sqrt(sigma/rValCount)));
could be written as
                PushDouble(1.0 - NORMDIST((mue-x)/sqrt(sigma/rValCount)));
, which is the one-tailed test and which fails for a negative argument of 
NORMDIST().

Regards,
Stefan

-- 
Stefan Nikolaus
humba, humba, tätärää, tätärää, tätäräää ;-)

PGP signature