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 2 - Autofill Data, Cell References, and Standard Deviation

By HHMI BioInteractive

Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.

Listed in Teaching Materials | resource by group HHMI BioInteractive

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

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

tutorial 2.jpg


This tutorial introduces easy ways to fill cells with a series of numbers, how to copy and paste formulae, and different methods of referencing individual cells to use in calculations.

Statistical concepts covered in this tutorial include range, sum of squares, variance, and standard deviation.


Cite this work

Researchers should cite this work as follows:


HHMI BioInteractive

HHMI BioInteractive group image

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