Spreadsheet Tutorial 5: Histogram

Resource Type
Description
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.
Estimated Time
Key Terms
array, data, distribution, frequency, Galapágos finches, graph, pivot table, quantitative, worksheet
Terms of Use
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.
Version History
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)
SP4