Working with data

Aims and objectives

This module will:

  • explain what data is
  • examine how data is used
  • explore ways to analyse data.

After completing this module, you will be able to:

  • find, clean and use data
  • evaluate and select tools to analyse and display data.

5. Analyse and display data

Data analysis is the process of examining data to find answers to questions. There are many ways that you can analyse and display data. This module will give an overview of some common analysis methods and tools. The data can be read through and manually organised by you, or processed using software.

Get an overview of your data

  1. Look through, or listen to, all the data you have gathered to get an overall idea of what you have gathered
  2. Transcribe any audio content so it is ready to be organised. You can record directly in Word for web or upload an audio file to get a transcription
  3. Think about how you can reveal patterns or meaning in the data
  4. You may be able to sort the qualitative data in a way that it can be measured.

Read the blog - How we helped our reporters learn to love spreadsheets.

You can access the Times data training program in Google Drive, including training information, datasets and tip sheets to learn skills for Google Sheets and using data to tell a story.

Descriptive data analysis

Descriptive analysis provides a summary of the data that has been gathered. For quantitative data this involves presenting the data visually in tables and charts, and measuring values such as the mean. For qualitative data the data is interpreted through grouping into categories or coding. Coding is the process of organising and sorting your data.

You can use one method or a mix of methods to do your analysis. Methods include:

  • Classification — sorting the data into different kinds of things
  • Statistical analysis — for qualitative data this could be counting different elements, such as keywords and phrases, to find out how often something is mentioned or has occured.
  • Thematic analysis — looking for recurring themes in the data.

Thematic analysis of qualitative data

Looking for patterns or themes in your data can help to answer your original question or may lead to new questions. Descriptive coding is a useful technique for thematic analysis. Coding can be done by hand or by using software, such as NVivo (Find information on accessing and using NVivo in the table on Data and text analysis software on this page).

Descriptive coding by hand

  What does coding look like? (YouTube, 4m42s)

Statistical analysis of quantitative data

Statistical analysis methods can range from simple to complex. Simple methods include:

  • Range — the difference between the highest and lowest value
  • Minimum — the smallest value
  • Maximum — the largest value
  • Frequency — the number of times a certain value appears
  • Mean — the total of the values divided by the number of values
  • Median — the middle value of any data after they are put in order
  • Mode — the most frequently occurring value.

Learn about:

You can use data analysis software to perform the statistical analysis.

See how to use features in Microsoft Excel to analyse data, including sort, filter, charts and pivot tables. It includes step-by-step tutorials on the different functions. 

Inferential data analysis

Inferential analysis involves using the information from the data to make judgements about a topic or issue. For example, the results from a small group could be used to infer something about a larger group, or the results could be used to predict what might happen. Inferential analysis of qualitative data usually requires more advanced statistical methods

  Choosing which statistical test to use (YouTube, 9m32s)

Which Stats Test is a question tool to help you narrow down the type of statistical test to use. (UQ login required).

Data visualisation

Tables, graphs, maps and charts are used to summarise and display data. Once you have done your analysis you need to think about the best way to present the data. Get tips on good and bad visualisations.

 Examples of data visualisations

The Tudor Networks visualisation brings together 123,850 letters connecting 20,424 people from the United Kingdom’s State Papers archive, dating from the accession of Henry VIII to the death of Elizabeth I (1509-1603).

The following visualisation shows the average years of schooling per country since 1950.

Choosing a chart

Displaying data

Misrepresenting data

Graphs can make data easier to understand but they can also be used to misrepresent data. Check graphs carefully. The graph creator can manipulate the design to innacurately reinforce their own agenda.

Read 5 ways writers use graphs to mislead you, including:

  • omitting baselines to make one group look better than another
  • manipulating the y-axis to blow out the scale
  • only including certain parts of the data
  • choosing a type of chart that does not fit the data
  • using colours, that alter long-held conventions or associations

Tools for analysing and visualising data

There are many tools available for analysing and visualising data. You may want to use a tool that you have some experience with already, like Excel or Google Sheets, or you may want to try using software that is specifically for data analysis.

Spreadsheet tools

These tools can be used to analyse and visualise data.

ToolFree account availableLicensed version available via UQGuidesTutorialsUQ Library Training
Microsoft ExcelNoYesExcel tables and chartsExcel tutorials from beginner to advanced (LinkedIn Learning pathway) Requires UQ loginYes
Google SheetsYesNoCreate and edit chartsGoogle Sheets Essential Training (LinkedIn Learning course) Require UQ loginNo

Data and text analysis software

These tools can be used to analyse and visualise data.

ToolFree account availableLicensed version available via UQAvailable on library computersGuidesTutorialsUQ Library training
RYesNoYesEssential R resourcesData Science with R and RStudio (LinkedIn Learning pathway) Requires UQ loginYes
NVivoNo (A reduced price student license is available)For UQ computers onlyYesGetting startedLearning NVivo (LinkedIn Learning course) Requires a UQ loginYes
LeximancerNoYesNoLeximancer guidesA First Leximancer 4.5 analysis (YouTube, 19m,17s)No
PythonYesNoYesPython for beginnersData Science with Python (LinkedIn Learning pathway) Requires a UQ loginYes
MATLABNo

Yes

YesAnalysing and visualising data with MATLABMATLAB 2018 Essential Training (LinkedIn Learning course) Requires a UQ loginNo
SPSSNo (A student license can be purchased) For UQ computers onlyYesSPSS Learning ModulesIntroduction to SPSS for data analysis (YouTube, 16m17s)No

Geographic information systems (GIS) tools

GIS tools are used to capture, analyse and present spatial or geographical data.

ToolFree accounts availableLicensed version available via UQGuides and tutorials
ESRI ArcGISNoYesLearning ArcGIS (LinkedIn Learning course) Requires a UQ login
CartoYesNoCarto tips and tricks
QGISYesNoLearning QGIS (LinkedIn Learning, 2h5m) Requires a UQ login

Our Geographic information systems (GIS) guide lists other tools and software to use with spatial or geographical data.

Visualisation tools

These tools are specifically for visualising data. You will need to do your analysis first before using these tools. 

ToolFree account availableLicensed version available via UQGuidesTutorialsUQ Library Training
PowerPointNoYesPowerPoint trainingCreate and format charts in PowerPoint (LinkedIn Learning, 4m24s) Requires a UQ loginYes
Tableau

Yes - a one year license for

No but the free account requires you to be a student or teacher at an accredited academic institutionLearning resources for studentsTableau essential training (LinkedIn Learning course) Requires a UQ loginNo
CanvaYes (Download as JPG, PNG or PDF)NoGetting started with CanvaCanva design YouTube videosNo
PiktochartYes (Download as JPG or PNG image)NoCreate a visual in 5 stepsPiktochart tutorialsNo
VenngageYes (but no download as PNG image or PDF available with a free account)NoVenngage Help CenterVenngage for beginners (YouTube, 24m34s)No

Our Data visualisation guide lists more tools for visualising data.

Duration:   Approximately 30 minutes


Graduate attributes

Knowledge and skills you can gain to contribute to your Graduate attributes:

 Independence and creativity

 Critical judgement

 Ethical and social understanding


Check your knowledge

Check what you know about this topic:

Take the quiz

Support at UQ

Access UQ services to assist you with personal or study-related issues.