google_sheets_histogram_binning.gs

function histogram(data, bins=5) {
  
    const min = Math.min(...data)
    const max = Math.max(...data)

    const size = Math.ceil((max-min)/bins)

    var histogram = new Array(bins).fill(0);
  
    for (const item of data) {
        index = Math.floor((item - min) / size)
        if ( index > ( bins -1 ) ) { // total hack
          index--
        }
        histogram[index]++;
    }

    return histogram;
}