COUNTIFS function: Download your dataset

1. Home
2. NC00437
3. ...
4. COUNTIFS function
ACST

Many of you found the last practical tutorial in class challenging. We want you to become competent and confident with ALL of the skills covered in tutorials, so this virtual tutorial will build on Practical Tutorial #3, giving you more practice in descriptive data analysis, creating graphs, and interpreting your results.

You will also have another go at finding National data through the ABS website to compare with the Health & Society health survey data. YOU WILL NEED TO BE ABLE TO DO THIS FOR THE SECOND ASSIGNMENT!

2. Download your dataset

1: Right click on the file below to save a copy of the dataset for Part 2 of this module containing data from the 2016 Health and Society Health Survey in Excel format. You should select the "save as ..." option, and save the file to your flash drive:

2016 Health and Society Student Health Survey data

2: Open your Excel dataset (workbook)

The workbook has several worksheets, including "data", "metadata", "calculations", "summary table", and "graph".

Your "calculations" worksheet is blank - the tables you will need to enter your calculations have not been pre-formatted for you. This will give you more practice in creating/formatting your own tables in Excel.