Frequency/bins

S

Scottmk

Hi,
I have a column of data that I want to distribute equally to 1
different bins. That is, each bin range will necessarily be
different width. Any idea how to do this easily in excel? Thank
 
J

John Mansfield

Hi,

Assuming cells A1:A15 contain your data and you want to
create five (5) bins, add the following formula as an
array formula (CONTROL-SHIFT-ENTER) into cells B1:B5.
This formula will set up the bins.

=MIN(A1:A15)+(ROW(INDIRECT("1:5"))*(MAX(A1:A15)-MIN(A1:A15)
+1)/5)-1

Then, add the following formula into cells B1:B5 also as
an array (CONTROL-SHIFT-ENTER)

=FREQUENCY(A1:A15,B1:B5)

This formula will calculate the frequency.

John Mansfield
pdbook.com
 
Top