SKEW and KURT functions
 

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.

SKEW and KURT functions
 

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.

SKEW and KURT functions
 

I'm using XL 2003 too....
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

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.

SKEW and KURT functions
 

Actually, this is interesting. Turns out I formatted the entire column as
currency, and THEN did the SKEW and KURT calculations. So those numbers
adopted the $ sign format.


--
Brevity is the soul of wit.


"Dave F" wrote:

I'm using XL 2003 too....
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

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.

SKEW and KURT functions
 

Use Edit | Clear All on the cell and re-enter the SKEW formula.
Still get $ ?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
I'm using XL 2003 too....
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

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.

SKEW and KURT functions
 

Yeah that fixes it. Should have been obvious to me.

Duh.
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

Use Edit | Clear All on the cell and re-enter the SKEW formula.
Still get $ ?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
I'm using XL 2003 too....
--
Brevity is the soul of wit.


"Bernard Liengme" wrote:

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.