Support

Support Options

  • Knowledge Base

    Find information on common questions and issues.

  • Support Messages

    Check on the status of your correspondences with members of the QUBES team.

Contact Us

About you
About the problem

Spreadsheet Tutorial 5: Histogram

By HHMI BioInteractive

Generate a histogram using a variety of methods.

Listed in Teaching Materials | resource by group HHMI BioInteractive

Version 1.0 - published on 15 Jan 2018 doi:10.25334/Q4295Z - cite this

Licensed under CC Attribution-NonCommercial-NoDerivatives 4.0 International according to these terms

tutorial 5.jpg

Description

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.

Contents

Cite this work

Researchers should cite this work as follows:

Tags

Relation to series

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

HHMI BioInteractive

HHMI BioInteractive group image

When watching a resource, you will be notified when a new version is released.