COUNTIFS function

This Online Tutorial gives you more practice in descriptive data analysis, creating graphs, and interpreting your results.  You will also have a go at finding National data through the ABS website to compare with the Health & Society health survey data.  

This week we will build on what you have learnt over the last few tutorials in undertaking descriptive analyses of health data, using the data from the 2016 Health & Society Student Health Survey. 

You will also find and access data from the most recent National Health Survey and Aboriginal and Torres Strait Islander Health Survey to compare with your Health and Society data, and you'll spend some time writing up a brief interpretation of your analyses and graphs.

On completion of this tutorial, you should be able to:

On completion of this tutorial, you should be able to:

1:  Confidently navigate data sets in Excel;

2:  Confidently calculate counts and prevalence (%) in Excel;

3:  Create and format tables in Excel to summarise data;

4:  Find and use relevant national data on the Australian Bureau of Statistics Website;

5:  Create a table and a graph comparing 2014 Health & Society Health Survey data with national data; and  

6:  Write a summary comparing the Health & Society with national data presented in the graph.