Excel Calculators

This is a function generator so you can simply create a histogram (using a bar chart) in older versions of excel. The function creates the counts for given bins.

This assumed your bin values are in a ordered vertical list (small to large), and you can just drag the output down to get the values. Note the bin count for (for example) B4 is for between B4 and B5

It is recommended to fix the data array in place (i.e. use "$" before and after the letters"). See the microsoft blog for more info on this.

Data Range:

Bin Top Cell:

Calculate Formula

Formula:

This is a handy function generator for converting a n-columns by m-rows matrix of data into a single column of data. Your options are:

• Column First or Row First
• Column First
  (i.e. A1, then B1 and so on)
• Row First
  (i.e. A1, then A2 and so on)

Data Top Left Cell:

I strongly recommend adding "$" either side of the letters (e.g. "$A$1") to *fix* the reference

Number of Data Columns (n):

Number of Data Rows (m):

[Optional] Row of Top Vector Cell:

Calculate Formula

Formula: