Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean

Image from the activity
Topic
Resource Type
Level
High School — GeneralHigh School — AP/IBCollege
Used In
1 BioInteractive Playlists
Favorited By
11 Users
Description

In this activity, students explore different ways of creating simple bar graphs and adding error bars from calculated statistical values using built-in functions in Excel or Google Sheets. Students apply what they learned by plotting beak size measurements of Galapágos finches collected before and after a drought.

This activity covers statistical concepts including standard error of the mean and confidence interval.

Student Learning Targets

  • Use a spreadsheet program to calculate the standard error of the mean for a sample data set.

  • Create a bar graph and add error bars showing the standard error of the mean.

Details
Estimated Time
One to two 50-minute class periods.
Key Terms

analysis, average, column graph, confidence, data, Galapágos finches, mean, plot, standard deviation, sum of squares, variance

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
Date Updated
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, SP5

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 5: Histogram
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
Other Related Resources
Showing of
Image from the activity
Lessons
Spreadsheet Tutorial 4: t-Test
Image from the activity
Lessons
Spreadsheet Tutorial 5: Histogram
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
Photos of four lizards taken from the interactive.
Virtual Labs
Lizard Evolution Virtual Lab
Image from the activity
Lessons
Evolution in Action: Data Analysis
Data Explorer text on a background of charts and graphs
Tools
Data Explorer
Photo of elephants in the wild
Lessons
Using Data to Investigate Elephant Evolution
Screenshot of the virtual lab
Virtual Labs
Stickleback Evolution Virtual Lab
Image of stickleback cards from the activity
Card Activities
Using Genetic Crosses to Analyze a Stickleback Trait
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