software

I'm trying to find skewness for this distribution. I know how the
skewness function works but I'm not sure how to deal with this dataset
I have.

Bin..........Freq
0-10........78
10-20......2589
20-30......922
30-40......11So, all I know is how many values are in each bin (not what the values
are themselves). Does that mean I have to type in an arbitrary value
of the 2nd bin 2589 times in order for Excel to understand what I'm
looking for? Anyone know of a shorter way? Thanks.--
Embee
------------------------------------------------------------------------
Embee's Profile: www.excelforum.com/member.php...oamp;userid=31455
View this thread: www.excelforum.com/showthread...hreadid=511415You should use the Class Mid-point and not any arbitrary value. For instance,
15 for the class 10-20.

However, EXCEL, being a non Statistical software, is quite limited on this.
(You have to type 2589 of the 15s). It is better to use a high grade
statistical software, such as SPSS to avoid the tedious typing.

Zhj23

quot;Embeequot; wrote:

gt;
gt; I'm trying to find skewness for this distribution. I know how the
gt; skewness function works but I'm not sure how to deal with this dataset
gt; I have.
gt;
gt; Bin..........Freq
gt; 0-10........78
gt; 10-20......2589
gt; 20-30......922
gt; 30-40......11
gt;
gt;
gt; So, all I know is how many values are in each bin (not what the values
gt; are themselves). Does that mean I have to type in an arbitrary value
gt; of the 2nd bin 2589 times in order for Excel to understand what I'm
gt; looking for? Anyone know of a shorter way? Thanks.
gt;
gt;
gt; --
gt; Embee
gt; ------------------------------------------------------------------------
gt; Embee's Profile: www.excelforum.com/member.php...oamp;userid=31455
gt; View this thread: www.excelforum.com/showthread...hreadid=511415
gt;
gt;

You can use an array formula, such as

=SKEW(ISNUMBER(ROW(A1:A78))*AVERAGE(0,10),ISNUMBER (ROW(A1:A2589))*AVERAGE(10,20),ISNUMBER(ROW(A1:A92 2))*AVERAGE(20,30),ISNUMBER(ROW(A1:A11))*AVERAGE(3 0,40))

array entered (Ctrl-Shift-Enter), which will give the result
0.692746935115446. If you get zero, then you did not array enter it.

ISNUMBER(ROW(A1:A78))*AVERAGE(0,10), produces an array of 78 numbers, each
with the value 5 (the midpoint of 0-10), ...

Jerry

quot;Embeequot; wrote:

gt;
gt; I'm trying to find skewness for this distribution. I know how the
gt; skewness function works but I'm not sure how to deal with this dataset
gt; I have.
gt;
gt; Bin..........Freq
gt; 0-10........78
gt; 10-20......2589
gt; 20-30......922
gt; 30-40......11
gt;
gt;
gt; So, all I know is how many values are in each bin (not what the values
gt; are themselves). Does that mean I have to type in an arbitrary value
gt; of the 2nd bin 2589 times in order for Excel to understand what I'm
gt; looking for? Anyone know of a shorter way? Thanks.
gt;
gt;
gt; --
gt; Embee
gt; ------------------------------------------------------------------------
gt; Embee's Profile: www.excelforum.com/member.php...oamp;userid=31455
gt; View this thread: www.excelforum.com/showthread...hreadid=511415
gt;
gt;