If you want to know how many numbers are in a given group of cells, there’s an easy way to do it: use the count() function. Imagine, for a moment, that you have a list of 100 dates. The question… Read moreSimple statistics: counting numbers

Sometimes, when working with spreadsheets, you need to know how many rows or columns are in a table, without particularly needing to know anything about their contents.

One thing that people often want to know, especially if they’re storing lists of things in spreadsheets, is “how many” there are of something. Fortunately, there are a fair number of ways to get a spreadsheet to tell you how… Read moreSimple statistics: Counting

As promised last week, today I’m going to talk about how to use a spreadsheet to calculate weighted averages in general, and Grade Point Averages (GPA) in particular.* A weighted average is just any average where some values are more… Read moreExample: GPA as a weighted average