Skip to main content
Toggle User Menu

HHMI BioInteractive

  • Español
  • Search
  • Log In/Create Account
  • Classroom Resources
  • Planning Tools
  • Professional Development
  • About Us

Spreadsheet Tutorial 5: Histogram

Topic
  • Evolution
  • Speciation
  • Science Practices
  • Data Analysis
  • Statistics
Resource Type
  • Activities
  • Lessons
Level
High School — GeneralHigh School — AP/IBCollege
Used In
1 BioInteractive Playlists
Favorited By
7 Users
Share This
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.
Details
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.

Version History
Date Published 03.29.16
Date Updated 04.22.16
Curriculum Connections
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

Materials
Worksheet (Google Sheets link)
Worksheet (Excel) 869 KB
Additional Materials

If using the Excel activity, students will need access to a computer with Excel installed.

Use This Resource With
Activity Resource
Evolution in Action: Data Analysis

Explore Related Content

Other Resources About Spreadsheets
Showing of
Lessons
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Lessons
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
Lessons
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
Lessons
Building Ecological Pyramids
Lessons
Spreadsheet Tutorial 4: t-Test
Other Related Resources
Showing of
Lessons
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Lessons
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
Lessons
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
Lessons
Spreadsheet Tutorial 4: t-Test
Virtual Labs
Lizard Evolution Virtual Lab
Lessons
Evolution in Action: Data Analysis
Card Activities
Using Genetic Crosses to Analyze a Stickleback Trait
Virtual Labs
Stickleback Evolution Virtual Lab
Click & Learn
Sorting Finch Species
Click & Learn
How to Analyze DNA Microarray Data
This Resource Appears in the Following Playlists
Showing of
hhmi-card
Teaching Statistics and Math Using Spreadsheet Tutorials and Galapágos Finches
5 Resources
By: BioInteractive

HHMI BioInteractive

  • Facebook
  • Instagram
  • Twitter
  • YouTube
  • Newsletter Signup
  • HHMI.org
  • Terms of Use
  • Privacy Policy