# 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