Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.
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.
Access the Google Sheets version here.
02/10/2016 Version 1.03: Added an explanation of using F4 key to toggle between relative and absolute referencing.
By downloading, you agree to the permissions to use this file.