We will use the comments on this post to keep track of the various spreadsheet functions and techniques we will use in class during the semester.
You will be asked to post a comment at some point during the semester briefly summarizing a spreadsheet function or technique (which will earn you a point towards your course participation grade).
You should post the given spreadsheet function or technique, and give a short summary and/or example of what it does; this can be copied directly (or preferably adapted) from the built-in spreadsheet documentation.
=COUNT(data): Returns the number of numeric values in a dataset; usually the argument “data” is a range of spreadsheet cells, e.g.
In the context of statistics, we often use =COUNT to find the “sample size,” i.e., the number of values in a given dataset.