First time here? Check out the FAQ!

1 | initial version |

A histogram is basically a graph frequencies by categories (i.e. bins), so you could use the frequency() function provided. It's an "array" function, meaning you need to highlight the range of cells you want filled with the results. Here's a FAQ on this function.

Basically, you need to start with a column listing your data (e.g. scores on an exam?), a 2nd column with bins (e.g. 0, 10, 20, ..., 80, 90, 100), and a third column for frequencies. Highlight the cells in your frequency column (should be one less cells than your # bins) and enter the formula as follows:

=frequency(data,classes)

"data" are your data that you want a histogram for. "classes" would be the bins you've chosen.

If you've entered the formula correctly you just need to plot the values it gave with a bar chart. It might take a bit of fooling around, but it works well, and it's a very effective way to make histograms of all types.

2 | No.2 Revision |

A histogram is basically a graph of frequencies ~~by ~~vs. categories (i.e. bins), so you could use the frequency() function provided. It's an "array" function, meaning you need to highlight the range of cells you want filled with the results. Here's a FAQ on this function.

Basically, you need to start with a column listing your data (e.g. scores on an exam?), a 2nd column with bins (e.g. 0, 10, 20, ..., 80, 90, 100), and a third column for frequencies. Highlight the cells in your frequency column (should be one less cells than your # bins) and enter the formula as follows:

=frequency(data,classes)

"data" are your data that you want a histogram for. "classes" would be the bins you've chosen.

If you've entered the formula correctly you just need to plot the values it gave with a bar chart. It might take a bit of fooling around, but it works well, and it's a very effective way to make histograms of all types.

3 | No.3 Revision |

A histogram is basically a graph of frequencies vs. categories (i.e. ranges of values indicated by bins), so you could use the frequency() function provided. It's an "array" function, meaning you need to highlight the range of cells you want filled with the results. Here's a FAQ on this function.

Basically, you need to start with a column listing your data (e.g. scores on an exam?), a 2nd column with bins (e.g. 0, 10, 20, ..., 80, 90, 100), and a third column for frequencies. Highlight the cells in your frequency column (should be one less cells than your # ~~bins) ~~bins, since the bins indicate the range for each category) and enter the formula as follows:

=frequency(data,classes)

"data" are your data that you want a to create a histogram ~~for. ~~to describe. "classes" would be the bins you've ~~chosen.~~chosen to specify the ranges for each category.

If you've entered the formula correctly you just need to plot the values it gave with a bar chart. It might take a bit of fooling around, but it works well, and it's a very effective way to make histograms of all types.

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.