Google Spreadsheet: Blood Cholesterol Example

Here is the Google spreadsheet we created in class yesterday (Mon Feb 3), using the blood cholesterol data from the textbook example (Ross, pp32-34):

https://docs.google.com/spreadsheets/d/1D8juK7QANNTCzAZeoA1b84AgmUm-Su8chms8B-rdphQ/edit?usp=sharing

We will continue working with this spreadsheet/data in class tomorrow.

List of Spreadsheet Functions/Techniques

We will use the comments to 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 briefly summarizing a spreadsheet function or technique at sometime during the semester (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 (see my first comment below for an example).

Google Spreadsheet: Class Age Data

Here is the link to the Google spreadsheet we created during our first class session on Monday, containing the class age data we collected:

Class Age Data – 27 Jan 2020

Note that you can only view the spreadsheet via the link, but if you have a Google account, you can save a copy to your Google Drive (“File->Make a Copy”) and then edit your copy.

We will continue working on this spreadsheet this week.  But in the meantime you should familiarize yourself with the basic spreadsheet functions and techniques (e.g., copying and pasting formulas) that we introduced in this spreadsheet.