I am trying to answer a fairly specific data question. I’ve gotten close, I think, but not exactly to the answer. I’m curious if anyone can help me. I’m using the 2009-2011 3 year ACS sample.
What I’m looking to answer is this: In Louisiana, what is the number of families with annual income of less than $25,000 (so $0-$24,999) who have at least 1 child under the age of 6 and the parents are in the labor force (1 parent if single parent household, 2 parents if married couple household)?
I think that I’ve narrowed down the number of families with at least 1 child under the age of 6 and income of less than $25,000, but I have not been able to sort out if there is a way to work in the employment or labor force status of the parents.
Here is how I have set it up so far:
Any suggestion on how to add the labor force status of parents by family type? Is this possible?