Spreadsheet Tutorial 5: Histogram

Topic

Resource Type

Level

High School — General High School — AP/IB College

Used In

1 BioInteractive Playlists

Saved By

13 Users

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

One to two 50-minute class periods.

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.