Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|