Spreadsheet Tutorial 5: Histogram
In this activity, students explore different ways of constructing a histogram using Excel or Google Sheets. Students apply what they learned by plotting beak size measurements of Galapágos finches before and after a drought.
This activity covers the different methods for constructing frequency histograms supported by different versions of spreadsheet programs. Methods range from manual counts, COUNTIFS function, Analysis Toolpak, Pivot Table, and indexed-array. The activity also touches on statistical concepts, including histogram bins.
Student Learning Targets
- Use a spreadsheet program to construct a histogram from a data set.
array, data, distribution, frequency, Galapágos finches, graph, pivot table, quantitative, worksheet
The resource is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license. No rights are granted to use HHMI’s or BioInteractive’s names or logos independent from this Resource or in any derivative works.
Common Core (2010)
Math.N-Q.1, Math.F-LE.5, Math.A-SSE.3, Math.A-REI.3, Math.S-ID.5, Math.S-IC.3; MP1, MP2, MP4, MP5
AP Biology (2019)