PureBytes Links
Trading Reference Links
|
> If I include the LN function in a STDEV array I get a (slightly)
> different answer on a small sample than not including it. For example,
> ={STDEVP(LN(C3:C15/C2:C14))} doesn't resolve to the same value as
> STDEVP(D3:D15) where column D contains the LNs of C3/C2, C4/C3, etc.
I can't explain it, but did you also try
={STDEVP(LN(C3:C15)-LN(C2:C14))}
It's mathematically the same, and might give you the correct result.
I avoid array formulas, personally. Useful sometimes, but I don't use
them if I don't have to.
-Alex
|