About this Resource

Exploring Aggregate Data

This section on exploring aggregate data is split into four tasks. In order to complete these tasks you must download the following Excel spredsheet to your computer.

You may find it easier to work through these tasks with this PDF step-by-step guide.

You will use a basic statistical package, Excel to carry out some straightforward data analysis tasks on an international time series aggregate dataset. The data used here are from the OECD Factbook, an online resource that provides free data and commentary on world economic, social and environmental trends. By the end of these tasks, you will be able to:

  • produce summary statistics;
  • derive a variable;
  • produce a chart in Excel;
  • add trend lines and moving averages to an aggregate time series;

The University of Manchester; Mimas; ESRC; RDI

Countries and Citizens: Unit 1 Macro and Micro Data: The Basics by Celia Russell, University of Manchester is licensed under a Creative Commons Attribution-Non-Commercial-Share Alike 2.0 UK: England & Wales Licence.