COUNTIFS function: Create a Graph

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

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!

4. Create a Graph

Create a bar graph from the summary table you have just made for cardiovascular conditions data, to compare the prevalence of cardiovascular conditions among men, women, and the total cohort.

- - You should end up with a graph with three bars (males, females and total persons).
  - Make sure you have a graph title, axis titles and labels and a key (legend).
  - Have a go at making the graph more visually appealing by changing colours and fonts.

Go to Part 3: Derived variables