[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel phenomenon



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