Resource Image

Spreadsheet Tutorial 5: Histogram

Author(s): HHMI BioInteractive

1203 total view(s), 361 download(s)

0 comment(s) (Post a comment)

Generate a histogram using a variety of methods.

Licensed under CC Attribution-NonCommercial-NoDerivatives 4.0 International according to these terms

Version 1.0 - published on 15 Jan 2018 doi:10.25334/Q4295Z - cite this


This tutorial explores how to generate frequency histograms. A variety of different methods are covered because different versions of spreadsheet programs support different methods. The methods covered range from manual counts, COUNTIFS function, Analysis Toolpak, Pivot Table, and indexed-array.

Statistical concepts covered in this tutorial include histogram and histogram bins.

Cite this work

Researchers should cite this work as follows: