What version of Excel? I do not get this with XL 2003
If A1:A10 has dollar values then formulas such as=SUM(A1:A10, =MAX(A1:A10)
and =AVERAGE(A1:A10) give formatted results just like a simple formula such
as =2*A2 does.
But I get no formatting with =SKEW(A1:A10) (or with =STDEV(A1:A10) ).
Actually it surprises me that the programmers would have bothered to carry
the format with some functions and not with others. Or maybe it is just
accidental!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dave F" wrote in message
...
Why does excel return the unit of measure when skewness or kurtosis is
calculated?
Example: I have a range of dollar values in C2:C120. =SKEW(C2:C120)
returns
$5.28.
Does it make sense to talk about the skewness or kurtosis of a population
in
terms of its units of measure?
--
Brevity is the soul of wit.