Proving the Algorithm for Mean (Average) in Google Sheets

I am a huge spreadsheets nerd and a huge advocate of the use of spreadsheets in mathematics instruction.  If you keep an eye on my site (or Twitter feed or YouTube Channel) you’ll see plenty of my reasons why I feel this way.  Here’s one:

Spreadsheets are a great tool for proving mathematical algorithms and formulas.  In this post . . . how we can use a Google Sheet to prove the formula for the mean (which, in spreadsheet land, is known as the average).

Check out this post about finding and exploring all 3 measures of central tendency with Google Sheets.

Published by

Jake Miller

Jake is the host of the Educational Duct Tape podcast, the #EduGIF Guy, a Tech Integration Coach, speaker, Former STEM, Math & Science Teacher, and a presenter.