QUBES will have scheduled maintenance work beginning on Wednesday, June 26, 2024, 4pm ET/1pm PT. The platform will operate normally for most of the day, except for an extended outage period lasting no more than 4 hours. All running tool sessions will expire during the maintenance window. Please plan accordingly and we do apologize for any inconvenience. close

Resource Image

Spreadsheet Tutorial 5: Histogram

Author(s): HHMI BioInteractive

1230 total view(s), 364 download(s)

0 comment(s) (Post a comment)

Summary:
Generate a histogram using a variety of methods.

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

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

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.

Cite this work

Researchers should cite this work as follows: