Introduction
The Generate tool allows you to create new columns and variables that are the result of combining two other columns by a mathematical function – allowing you to calculate proportions, sums, products or differences.
Set Up
For this worked example we will calculate the proportion total dwellings that are separate houses for SA2s across Melbourne
To do this:
- Select Greater Melbourne (gccsa_2016/2GMEL) as your area
- Select the following datasets and variables:
Dataset | Variables |
---|---|
SA2-G32 Dwelling Structure-Census 2016 | SA2 Code 2016 |
SA2 Name 2016 | |
Occupied private dwellings: Separate house, Dwellings | |
Occupied private Dwellings:Total Occupied private dwellings, Dwellings |
Once you have added these datasets, you are ready to use the Generate tool – click the Inputs tab above to see how to do this