Support

This tutorial explores how to generate frequency histograms. A variety of different methods are covered because different versions of spreadsheet programs support different methods. The methods covered range from manual counts, COUNTIFS function, Analysis Toolpak, Pivot Table, and indexed-array.

Statistical concepts covered in this tutorial include histogram and histogram bins.

• Tutorial-5-Histogram.xlsx(XLSX | 869 KB)
• Spreadsheet Tutorial 5: Histogram | HHMI BioInteractive
• License terms

Researchers should cite this work as follows:

• HHMI BioInteractive (2018). Spreadsheet Tutorial 5: Histogram. HHMI BioInteractive, QUBES Educational Resources. doi:10.25334/Q4295Z

  BibTex | EndNote

1. High School
2. introductory
3. Resources @ HHMI - BioInteractive
4. Scientific Methodology
5. Scientific Process
6. Statistics and Math
7. Teaching material
8. Undergraduate

The resource is part of the series below:

• Spreadsheet Data Analysis Tutorial Series

  This series of self-paced tutorials show how to analyze data using a spreadsheet program.

• Amylase Copy Number and Diet

  An adapted module from HHMI Spreadsheet Tutorials using amylase data for students to gain data analysis and excel skills

• Expanded Graphing Tutorial

  The tutorial has two approaches for teaching about graph building and choosing the appropriate graph for different data types, a scaffolding approach and a exploration approach which can be utilized depending on how you wish to use the resource.

• Using HHMI Tutorials to Prepare Students for Investigating Authentic Datasets in Biology

  HHMI tutorial modules were modified and condensed to bring all students up to the same skill level, and students took a pre-assessment to demonstrate adequate preparation for class.

• Expanded Graphing Tutorial

  The tutorial has two approaches for teaching about graph building and choosing the appropriate graph for different data types, a scaffolding approach and a exploration approach which can be utilized depending on how you wish to use the resource.

• Amylase Copy Number and Diet

  An adapted module from HHMI Spreadsheet Tutorials using amylase data for students to gain data analysis and excel skills