Histogram

from here.

You have a long column of data in column A and want to observe their distribution (histogram).

C1 =COUNT(A:A)
C2 =Min(A:A)
C3 =Max(A:A)

put some desired bucket size in D3 e.g. D3 = 2

put:

C5 =C2
C6 =$C5 + $D$3
drag the bottom-right corner of the C6 cell down, to the create the desired number of bucket ranges

In column D select the cells in front of the cells that are showing bucket boundaries
in the formula row which is a part of the excel toolbox type:

=frequency(A:A, C5:C12) 

hit CTRL  + SHIFT + Enter

This will choose the data as first argument and bucket ranges in second.

 A: data
 BC
 data that are in buckets. e.g. for bucket 0 includes data that are less than or equal to bucket range (which is 0) but bigger than the previous bucket limit (which is non existence, hence 0 itself)
 2  0 1
 3  2 1
 5  4 3
 10  6 2
 3  8 2
4  10 1
 0  12 0
 6  14 0
 8  16 0
 8  18 0
















Ĉ
Morteza Sh-,
Dec 1, 2010, 2:46 PM
Comments