Mac Numbers Notes

From Federal Burro of Information
Jump to navigationJump to search


start at the top, no gaps, leave header blank.

Make a col of data. not a header col

in the next col over make you buckets

in the next col over at the top:

=INDEX(FREQUENCY(A$2:A$79,C$2:C$11),ROW()−1)

then drag the yellow handle in the middle bottom of the cell down to "fill down"

Something like this:

Select the bucket and values cells and make a chart , 2 d column.