Mystery Dataset
Learning Objectives
By the end of this activity, you should be able to:
- Use formulas in spreadsheets to calculate summary statistics
- Make charts in spreadsheets
- Discuss the limitations of summary statistics
Instructions
-
Open the mystery dataset spreadsheet and make a copy (File → Make a copy) so you have your own editable version.
-
Calculate:
- Mean
- Median
- Mode
- Correlation (between column1 and column2 for each dataset)
- Standard Deviation
Dataset 1 is done for you. Examples of how to write the formulas are in red.
-
Discuss: describe the 4 mystery datasets using summary statistics—what can you tell me about these mystery data?
Bonus
Done early? Try:
Instructions
- Redo the calculations in the LONG tab with a pivot table. The LONG tab contains the same data as before, just arranged in long format instead of wide format.
- Explore the data in the BONUS tab, tell us what you find!
Learning Objectives
- Distinguish between long-format and wide-format data
- Use pivot tables to calculate summary statistics