Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation
Author(s): HHMI BioInteractive
1692 total view(s), 452 download(s)
Summary:
Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.
Description
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 (2018). Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation. HHMI BioInteractive, QUBES Educational Resources. doi:10.25334/Q4TT2T