The University of Sydney Page 1
QBUS6860
Visual Data Analytics
Weekly Assignment 8
Dr Demetris Christodoulou
Discipline of Accounting
MEAFA Research Group
http://sydney.edu.au/business/research/meafa
The University of Sydney Page 2
Weekly Assignment 8
o The Weekly Assignment 8 asks to investigate the changing relation
over time between income per capita and life expectancy
o Theory suggests that as income per capita for a country increases,
there would be more investment in education, public health,
technology and pro-social initiatives in that country, thus improving
living conditions overall and life expectancy at birth
o More specifically, the graph objective to be analysed is defined as:
“The changing relation between GDP per capita and life expectancy
from 1961 to 2017”
Hint: think of GDP per capita as an explanatory variable that can
help explain the variation in life expectancy
The University of Sydney Page 3
Weekly Assignment 8
The data is available from the World Bank Open Data initiative.
o The life expectancy at birth by jurisdiction is found here:
https://data.worldbank.org/indicator/sp.dyn.le00.in
o The GDP income per capita (in constant 2010 UDD) by jurisdiction is
found here: https://data.worldbank.org/indicator/NY.GDP.PCAP.KD
o These datasets contain jurisdiction-level observations for life
expectancy and GDP per capita
o From these links you can
download the CSV or Excel
files – look for these links:
o You are required to manage the data to prepare it for analysis.
You are also required to validate the data as in every assignment
The University of Sydney Page 4
Weekly Assignment 8
o We do not know in advance the answer to the graph objective
question and we must investigate the changing relation between
the two variables using a visual mining approach.
o Thus, you are required to use your knowledge from Week 9 to
analyse the graph objective using appropriate visual mining
methods.
Hint: not all visual methods are useful for this assignment.
o Do not use any transformations. The data must be analysed
exactly as provided by the World Bank links in their nominal
values
The University of Sydney Page 5
Weekly Assignment 8
o You are required to produce data just one graph that will show the
changing relation between the two variables over time. This data
graph must qualify as a high-quality data graph as discussed in
weeks 1-6.
o The graph objective is multidimensional involving observations on
jurisdictions, years, GDP per capita and life expectancy. It is up to
you how to design the graph, but you may want to consider using
interactive features or using the motion retinal variable
o You are not required to do any particular research on this
research question, but you may want to do so if it helps you
understand the question better
The University of Sydney Page 6
Weekly Assignment 8
o You will be evaluated on the quality of data management, data
validation, and the quality of the data graph
o You will be evaluated on the application of appropriate visual
data mining methods
o You need to submit the Tableau workbook (.twbx), a Word or PDF
report, and the managed Excel or CSV dataset