# Aggregating data to larger areas

This page includes information on how to calculate percentages, IRSD scores, age-standardised rates and total fertility rates for aggregated areas.

You can set up these calculations in a spreadsheet, yourself, or use the template (xls) provided.

##### Percentages

Data that are expressed as a numerator, denominator and percentage are simple to calculate - refer to the example in the table below.

 Area Numerator Denominator Per cent Constituent Area 1 51,485 858,490 6.0 Constituent Area 2 37,567 590,316 6.4 Constituent Area 3 63,124 887,873 7.1 Constituent Area 4 66,164 862,821 7.7 Aggregated Area 218,340= Sum of constituent areas above 3,199,500= Sum of constituent areas above 6.8= Aggregated Area Numerator/ Aggregated Area Denominator x 100

##### Index of Relative Socio-economic Disadvantage

Index of Relative Socio-economic Disadvantage (IRSD) scores for aggregated areas are slightly more complicated. For these you need the IRSD score and the Estimated Resident Population (ERP) or Usual Resident Population (URP) of the constituent areas. Note: If a constituent area does not have an IRSD score it should be excluded from all calculations.

To calculate the IRSD score for an aggregated area you need to multiply the ERP or URP by the IRSD score for each of the constituent areas and then sum these together. This summation is then divided by the ERP or URP of the aggregated area to give you the aggregated area's IRSD score - refer to the example in the table below.

 Area IRSD score ERP or URP IRSD x ERP or URP Constituent Area 1 1043 798,712 833,056,616 Constituent Area 2 1006 548,568 551,859,408 Constituent Area 3 939 840,623 789,344,997 Constituent Area 4 994 810,788 805,923,272 Aggregated Area 994 = Sum of (IRSD x ERP or URP)/ Sum of ERP or URP(i.e., 2,980,184,293/ 2,998,691) 2,998,691= Sum of constituent areas above 2,980,184,293= Sum of constituent areas above

##### Age-standardised rates

Age-standardised rates are a little more complicated to calculate. Without access to the raw data used to calculate the rates of the data you have, you will need to approximate the age-standardised rates for aggregated areas - refer to the example in the table below. Although not perfect, the rates calculated this way are very close to the actual rates that would be calculated from the raw data.

 Area Number Rate Number/ Rate Constituent Area 1 5,262 16.7 315.1 Constituent Area 2 2,717 16.8 161.7 Constituent Area 3 5,900 14.5 406.9 Constituent Area 4 13,320 12.9 1,032.6 Aggregated Area 27,199= Sum of constituent areas above 14.2= Sum of constituent areas/ Sum of Number/Rate (i.e., 27,199/1,917) 1,917= Sum of Number/Rate

Note: You can use either an actual rate or standardised ratio in the calculations above, depending on which you want to report on.

##### Total fertility rates

Total fertility rates can be produced using the same method as for age-standardised rates, where â€˜Numberâ€™ is the number of births and the 'Rate' is the total fertility rate.