MIS770: Foundation Skills in Data Analysis - Annual Report Visuals

This report provides an analysis of data visualization techniques used in annual reports, with a specific focus on the Australia’s Health 2018 report published by the Australian Institute of Health and Welfare. The report is divided into two parts: Part A discusses the criteria for effective data visualization, including tabular charts and graphical presentations like vertical bar charts, stacked bar charts, and line charts. It highlights the importance of clear labeling, appropriate data selection, and avoiding misinterpretation. Part B applies these criteria to analyze the Australia’s Health 2018 report, examining the use of tables to present workforce summaries and alcohol consumption trends, as well as the use of graphs to illustrate life expectancy, funding arrangements, tax revenue spending, health expenditure, chronic conditions, cancer incidence trends, and mortality rates for people with diabetes. The report evaluates the effectiveness of these visualizations in conveying complex health information.

Running head: FOUNDATION SKILLS IN DATA SKILLS
Foundation Skills in Data Skills
Name of the Student:
Name of the University:
Author Note:

1FOUNDATION SKILLS IN DATA SKILLS
Table of Contents
Introduction:...............................................................................................................................2
Part-A.........................................................................................................................................2
Part B:.........................................................................................................................................5
Tabular Presentation:.................................................................................................................5
Graphical Presentation:..............................................................................................................6

2FOUNDATION SKILLS IN DATA SKILLS
Introduction:
The annual report of an organisation is published publicly by the particular
organisation. It contains a brief information about operations and financial conditions.
Different types of charts or graphs and tables are used to provide a visual presentation which
is easy to understand. The data is presented through proper charts and tables in the annual
report. Charts or graphs easily transform the data into visualization (Evergreen, 2016). There
are different types of charts or graphs which are used according to the type and nature of
information.
In this report, there are two parts: Part-A and Part-B. In Part-A, visualization criteria
is discussed. The visualisation criterions are important in data analysis. The study of annual
report, Australia’s Health 2018 published by Australian Institute of Health and welfare is
presented in Part-B using the tables and charts or graphs. Australia has ranked 2nd on the
United Nations Development Programme’s Human Development Index in 2011.
Part-A
The specialized representation of a data can help the user of the report to understand
the data more easily. To present any graph or chart there are some specific criteria which
needs to be followed. The criterions are discussed below:
1. Tabular Charts:
Tables usually presents raw data in an organized manner. It contains huge information
which can be extracted to understand the small parts easily. The norms for tabular
representation are mentioned bellow:
 Variables should be in the column when they are compared (Arcidiacono, Aucejo,
and Hotz, 2016).

3FOUNDATION SKILLS IN DATA SKILLS
 Categorical variables should be placed in the rows for the effective analysis
(Chevalier and Corp, 2014).
 The proper measurement units should be mentioned.
 Table does not contain explanation for the given information.
 It is useful for comparative analysis.
2. Graphical Presentation:
Graphical presentation is the visualization of data by using the charts and plots. There are
a number of charts and plots that are used in the graphical representation depending on the
nature of the data. Here some usual features of the graphical representation are described:
 The dependent variable placed on vertical axis and the independent variable on x-axis
gives better result (Tomak, Bek, and Cengiz, 2016).
 Interval should be equal for all two consecutive labels.
 Variables starts from zero.
These are the common features of graphs and charts. However, there are specific features
of each graphs and chart.
1. Vertical Bar Chart:
A vertical bar chart shows categorical data with specific heights of bar. Height of these
bar presenting a variable is proportional to the values of that variable. Basic features of this
chart are:
 Independent variable should be placed on x-axis from left to right.
 Heights of bar presents the value of dependent variable at various level of
independent variable.
 Use of various colours in bar for each year to easy identification.

4FOUNDATION SKILLS IN DATA SKILLS
2. Stacked Bar Chart:
Stacked bar charts have bars to compare between categorical data with segments. The
segments shows the different parts of the bar. The basic features are:
 Sub-segments are placed in bars horizontally.
 The bar compare the sub-segments.
 It compares total value of independent categorical variable.
 It compares the changes in the proportions of sub-segments (Heiberger and Robbins,
2014).
3. Line Chart:
Line Chart shows the information as series of points which is also called markers,
connected by straight line. The basic features of line chart are:
 The line depicts the dependent variable at each level of independent variable
(Harrison, Yang, Franconeri and Chang, 2014).
 It is used to present the trends of data.
 It is used when dependent variable is continuously changing.
Tables and graphs are very useful and easy to present any reports. Despite of these
usefulness, it has some limitations that needs to be considered before using in any report
(Frankfort-Nachmias, and Leon-Guerrero, 2017).
Tables and graphs should not include the irrelevant and huge data. The proper libelling in
both the axis is very important. Results are neat and clean when the number of dependent
variable is less (Pigou, 2016). The line chart should not be interpreted in the terms of
intermediate values between two markers.

5FOUNDATION SKILLS IN DATA SKILLS
Part B:
The Australian Institute of Health and Welfare (AIHW) which was established under
The Australian Institute of Health and Welfare Act 1987, is an agency for information and
statistics on health and welfare of Australia (Australia’s health 2018, 2018). The report
considered here for discussion of Australia’s Health 2018 published by AIHW in 2018.
This agency has presented many health issues in Australia by the tabular and
graphical presentation in its report from the year 2018 which are discussed below:
Tabular Presentation:
1. Workforce Summary:
Australian government employs nurses, medical practitioner psychologists and
dentists according to the need related to health. The above table contains the data for the year
2013, the year 2016 and the percentage change in the data. The rows of table contain the
different status of health professions and the column contains the health profession. From the
table one can easily see the positive and negative growth in the status of professionals. The
negative and positive growth is highlighted by two different colours and two arrows

6FOUNDATION SKILLS IN DATA SKILLS
indicating the rise and fall in growth (Cecchetti and Kharroubi, 2015). For an example, in
2016, there is a 66% fall in women physiotherapists from 2013.
2. Trends in Alcohol Consumption in Australia:
There is a trend in the alcohol consumption for the young age population in Australia.
To show this trend a table is used which contains the year in columns and drinking
behaviours in rows. From the table one can easily say that in which year drinking behaviour
of young people is better. The first row depicts that there is a fall in alcohol consumption for
the people aged of 14 years or over in the year 2016 than the year 2013 (Watkins,
Wulaningsih, Da Zhou, Marshall, Sylianteng, Rosa, Miguel, Raine, King, and Maruthappu,
2017). Similarly, one more result can be depicted that the people aged 14-24 are slowing
down to start drinking alcohol.
Graphical Presentation:
3. Life Expectancy of Birth by Sex:

7FOUNDATION SKILLS IN DATA SKILLS
Life expectancy is measured in terms of a person is expected to live based on the
current age or living with disease. To show the life expectancy at birth by sex, the report has
used the line chart. In this chart, vertical axis presents the life expectancy at birth in years and
the horizontal axis presents the year. The position of a trend line with respect to the other
trend line depicts the higher or lower life expectancy of the respective trend line than the
referred trend line (Ziuziański, Furmankiewicz, and Sołtysik-Piorunkiewicz, 2014). The slope
of each line shows the increase or decrease in the change of life expectancy. The comparison
of the slopes of trend line compares the change in life expectancy of both genders.
4. Funding Arrangements:

8FOUNDATION SKILLS IN DATA SKILLS
In Australia, funding arrangements is a complicated process for the health related
services. This report has used the stacked bar chart. In this chart, the vertical axis presents the
different services provided by the Australian government, the horizontal axis presents the
percentage of funding and the three colours presents three sources. This chart can compare
the different services with the ability to break down and compare parts of a whole service
(Veroniki, Straus, Fyraridis, and Tricco, 2016). The length of the bar shows the total
percentage of funding for the respective service. The length of the different colours represent
the percentage of the respective source for the respective service.
5. Spending from Tax Revenue:

9FOUNDATION SKILLS IN DATA SKILLS
The Australian government spends a certain proportion of its tax revenue on health
and the proportion varies over the year. To show the change in percentage of spending from
tax the report has used the vertical bar chart. The vertical axis of the chart presents the
percentage of tax revenue spend on health and the horizontal axis presents the year. The
height of the bar shows the percentage of spending. Difference among height of the bars
shows the difference among the percentage of spending from tax revenue in different years.
6. Health Expenditure in Different Services:

10FOUNDATION SKILLS IN DATA SKILLS
The total health expenditure is distributed in various health services. To show the
acquired percentage of expenditure by the services, the report has used the pie chart. The total
are of pie chart presents the total expenditure on the health services. Each colour presents a
service which shares the expenditure. The large area with a single colour implies the greater
percentage of expenditure and the colour of that area shows the expenditure on that particular
service (Bowers, 2014).
7. Health Expenditure per Person:

11FOUNDATION SKILLS IN DATA SKILLS
Along with Australian government private and state government spends a large
amount of money on the health of the Australians which later various depending on the
indigenous status. In the report, health expenditure per person according to the indigenous
status is shown by the use of combined bar diagram. In this diagram, horizontal axis presents
the source of fund, vertical axis presents the amount of fund per person in dollar and the two
bars for each source of fund presents the status indigenous and non-indigenous. This diagram
helps to compare between the per person expenditures of indigenous and non-indigenous
people of Australia funded by different sources (Wang and Regatte, 2015). As well as, one
can compare the funds from different sources.
8. Chronic Conditions:

12FOUNDATION SKILLS IN DATA SKILLS
Chronic conditions have substantial impact in Australia for the population, the
health system and individuals. The doughnut chart is used to show the chronic conditions.
There are three doughnut charts for hospitalisations in 2015-16, deaths in 2016 and burden of
disease in 2011. The doughnut chart in the report shows that the chronic conditions were
involved in 37% hospitalisation in the year 2015-16. The conditions were badly involved in
deaths in 2017. The percentage was 87 for deaths. There was an involvement of chronic
conditions in 61% burden of disease in 2011 (Juul, Izquierdo, Hurst, Dai, Wright, Kulesha,
Pettett, and Turner, 2015).
9. Trends of Combined Incidences of Cancer:

13FOUNDATION SKILLS IN DATA SKILLS
The report discusses about the incidence of all cancers combined from the year
1982 to 2018. Here, the report presents combined line and bar chart which is used to estimate
the trend of all combined cancer incidence for the year 2016 and 2108. In the horizontal axis,
year is plotted and in the left vertical axis the number of incidences is plotted and the right
vertical axis shows the rate that is number of incidence per 100000 population. The trend line
shows the ups and downs in the total number of incidence over the years. Bar shows the total
number of incidence for the respective year. In the year 2016 and 2018 the trend and bar are
estimated.
10. Mortality Rate for People with Type 1 and Type 2 Diabetes:

14FOUNDATION SKILLS IN DATA SKILLS
In 2016, diabetes was the cause of 4770 deaths. The report shows the mortality rate
associated with type 1 and type 2 diabetes by using the combined line and bar diagram. Here
in the left vertical axis death rate is plotted and the right vertical axis presents the mortality
rate ratio and the horizontal axis depicts the age group. In the left chart, there is a line which
is the mortality ration of people with type 1 diabetes and general population. The two bars for
each age group shows the mortality rate of people with type 1 diabetes and the mortality rate
for the general people. The chart in the right explains the same for the people with type 2
diabetes.
The discussion about the criteria of graphs and table for graphical representation
and tabular representation is very important as it may result in wrong interpretation of the
data if the criteria is not filled. There are various types of charts like pies chart and doughnut
chart, bar chart and histogram which are used for suitable and different purposes. The
Australia’s Health 2018 has used the charts and tables to present the health status of
Australia. From the report, table, bar chart, stacked bar chart, pie chart, doughnut chart and
combined chart is taken and well interpreted and explained the way of presentation.

15FOUNDATION SKILLS IN DATA SKILLS

16FOUNDATION SKILLS IN DATA SKILLS
Reference:
Arcidiacono, P., Aucejo, E.M. and Hotz, V.J., 2016. University differences in the graduation
of minorities in STEM fields: Evidence from California. American Economic Review, 106(3),
pp.525-62.
Australia’s health 2018 (2018). Australia’s health 2018. [ebook] Australian Institute of
Health and Welfare 2018. Available at: https://www.aihw.gov.au/getmedia/7c42913d-295f-
4bc9-9c24-4e44eff4a04a/aihw-aus-221.pdf.aspx?inline=true [Accessed 26 Mar. 2019].
Bowers, D. ed., 2014. Medical statistics from scratch: an introduction for health
professionals. John Wiley & Sons.
Cecchetti, S.G. and Kharroubi, E., 2015. Why does financial sector growth crowd out real
economic growth?
Chevalier, P.Y., EMC Corp, 2014. Customizable relevancy criteria. U.S. Patent 8,688,711.
Evergreen, S.D., 2016. Effective data visualization: The right chart for the right data. Sage
Publications.
Frankfort-Nachmias, C. and Leon-Guerrero, A., 2017. Social statistics for a diverse society.
Sage Publications.
Harrison, L., Yang, F., Franconeri, S. and Chang, R., 2014. Ranking visualizations of
correlation using weber's law. IEEE transactions on visualization and computer
graphics, 20(12), pp.1943-1952.
Heiberger, R.M. and Robbins, N.B., 2014. Design of diverging stacked bar charts for Likert
scales and other applications. Journal of Statistical Software, 57(5), pp.1-32.

17FOUNDATION SKILLS IN DATA SKILLS
Juul, S., Izquierdo, F., Hurst, A., Dai, X., Wright, A., Kulesha, E., Pettett, R. and Turner,
D.J., 2015. What's in my pot? Real-time species identification on the MinION. bioRxiv,
p.030742.
Pigou, A.C., 2016. Industrial fluctuations. Routledge.
Tomak, L., Bek, Y. and Cengiz, M.A., 2016. Graphical modeling for item difficulty in
medical faculty exams. Nigerian journal of clinical practice, 19(1), pp.58-65.
Veroniki, A.A., Straus, S.E., Fyraridis, A. and Tricco, A.C., 2016. The rank-heat plot is a
novel way to present the results from a network meta-analysis including multiple
outcomes. Journal of clinical epidemiology, 76, pp.193-199.
Wang, L. and Regatte, R.R., 2015. Investigation of regional influence of magic-angle effect
on T2 in human articular cartilage with osteoarthritis at 3 T. Academic radiology, 22(1),
pp.87-92.
Watkins, J., Wulaningsih, W., Da Zhou, C., Marshall, D.C., Sylianteng, G.D., Rosa, P.G.D.,
Miguel, V.A., Raine, R., King, L.P. and Maruthappu, M., 2017. Effects of health and social
care spending constraints on mortality in England: a time trend analysis. BMJ open, 7(11).
Ziuziański, P., Furmankiewicz, M. and Sołtysik-Piorunkiewicz, A., 2014. E-health artificial
intelligence system implementation: case study of knowledge management dashboard of
epidemiological data in Poland. International Journal of Biology and Biomedical
Engineering, 8, pp.164-171.