Skip to main content
HHMI BioInteractive
  • Español
  • Site Search
  • Log in
  • Create Account
  • Community
    • Group Rules
    • Join the Community
  • Classroom Resources
  • Teaching Tools
  • Professional Development
  • Partner Content
BioInteractive Resource Playlist
Teaching Statistics and Math Using Spreadsheet Tutorials and Galapágos Finches
Previous Resource
5. Spreadsheet Tutorial 5: Histogram
Next Resource

Spreadsheet Tutorial 5: Histogram

Image from the activity

Topic

  • Evolution
  • Speciation
  • Science Practices
  • Data Analysis
  • Statistics

Resource Type

  • Activities
  • Lessons

Level

High School — GeneralHigh School — AP/IBCollege
Used In
1 BioInteractive Playlists
Saved By
15 Members

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.

Version History

Date Published 03.29.16
Date Updated 04.22.16

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

Download Worksheet (Google Sheets link)
Download 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
Image of an animal drinking from a watering hole
Lessons
Building Ecological Pyramids
Image from the activity
Lessons
Spreadsheet Tutorial 4: t-Test
Image from the activity
Lessons
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Image from the activity
Lessons
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
Image from the activity
Lessons
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
An icon of a spreadsheet with labeled rows and columns.
Skill Builders
Setting Up Your Data for Success

Other Related Resources

Showing of
Image from the activity
Lessons
Spreadsheet Tutorial 4: t-Test
Image from the activity
Lessons
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Image from the activity
Lessons
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
Image from the activity
Lessons
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
Photos of four lizards taken from the interactive.
Virtual Labs
Lizard Evolution Virtual Lab
Photo of elephants in the wild
Lessons
Using Data to Investigate Elephant Evolution
Data Explorer text on a background of charts and graphs
Tools
Data Explorer
Image from the activity
Lessons
Evolution in Action: Data Analysis
An icon of a spreadsheet with labeled rows and columns.
Skill Builders
Setting Up Your Data for Success
Screenshot of the virtual lab
Virtual Labs
Stickleback Evolution Virtual Lab

This Resource Appears in the Following Playlists

Showing of
Teaching Statistics and Math Using Spreadsheet Tutorials and Galapágos Finches
5 Resources
By: BioInteractive
HHMI BioInteractive
  • About Us
  • Our Team
  • Our Advisors
  • FAQ
  • Contact Us
  • Facebook
  • Instagram
  • Twitter
  • YouTube
  • Newsletter Signup
  • HHMI.org
  • Terms of Use
  • Privacy Policy
  • Accessibility