Bundle B2 - Household Composition
Percentage calculation formulas for the variables in table KS106SC002 were omitted because they will not produce a correct universe denominator and may introduce the potential for double-counting. The explanation provided by the General Register Office for Scotland (GROS) states:
… the columns in table KS106 do not add up to the table population (All households), and therefore the percentages for all the columns will not sum to 100. It is possible in this table that a household will be counted more than once, for example, in the 'No adults in employment in household: With dependent children' as well as the 'Dependent children in household: All ages' columns. There will also be households which do not appear in any of the columns, e.g. one which doesn't include anyone with a long-term health problem or disability or dependent children or unemployed adults... [GROS; February, 2014].
Bundle B7 - Health
Variables KS301SCa005, KS301SCa006, and KS301SCa007 are counts of a subset of variable KS301SCa001 (All People). This subset is named All People Aged 16 to 64 and is not provided by GROS. We created this subset to facilitate the production of percentage variables by using the following formula for the denominator:
(KS301SCa005+KS301SCa006+KS301SCa007).
Bundle B11 - Economic Activity
Percentage calculations for variables KS601SC012 (Unemployed People Aged 16 to 74: Aged 16 to 24) and KS601SC013 (Unemployed People Aged 16 to 74: Aged 50 to 74) use variable KSC601SC005 (Economically Active: Unemployed) as the denominator. The percentages will not add up to 100 because GROS did not release counts for unemployed people aged 25 to 49. To calculate this number, GROS suggests the following:
… in order to calculate the proportion of unemployed people aged 16 to 24 or aged 50 to 74 out of all unemployed people, you would need to use the figure for 'Economically active: Unemployed' as your denominator. You can also calculate the percentage of people aged 25 to 49 who are unemployed by subtracting the totals from the 'Unemployed: 16 to 24' and 'Unemployed: 50 to 74' columns from the 'Economically active: Unemployed' figures, and then working out percentages for all three age bands. This will also give you percentages which sum to 100…
…the columns showing the Unemployed people aged 16 to 74 who have never worked or are long-term unemployed aren't meant to add to 100. You could use the 'Economically active: Unemployed' figure as a denominator and calculate the percentage of unemployed people who have never worked, or are long-term unemployed. The remaining percentage will show those who are unemployed but did work in either 2010 or 2011 (the definition for the 2011 Census for long-term unemployed is those who last worked in 2009 or earlier)… [GROS; February, 2014]