Wednesday, September 24, 2014

NHS Variable Label Confusion

Question
A sharp-eyed student found 2 variables in NHS with labels meaning same thing but different counts (on shelter costs section). As far as I checked, this problem is affecting all NHS profiles files (included the FSA level - custom tab), English and French. Statcan's website shows the same labels for all the products I looked at.

The 2 labels are:
Spending 30% or more of household total income on shelter costs
and
Spending 30% to less than 100% of household total income on shelter costs

We suspect the second label is wrong, perhaps the 100% must be 50%, based on the data dictionary (see attached a photo from the student) and the counts. Or it could be the data for 50% to 100%.

To reproduce the problem, please visit this website at Statcan:
<http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/page.cfm?Lang=E&Geo1=CMA&Code1=932&Data=Count&SearchText=932&SearchType=Begins&SearchPR=01&A1=All&B1=All&Custom=&TABID=3>
Search for "shelter costs" in the page and find the labels and data:
Spending 30% or more of household total income on shelter costs: 16,925
Spending 30% to less than 100% of household total income on shelter costs: 14,115 

Please confirm with the census division the correct label of the second variable and let us know.

Answer

Both labels are correct.

The first one is greater or equal to 30%

The second one is greater or equal to 30% but less than 100%.

For some households the shelter-cost-to-income ratio is greater or equal to 100%.