Hi,
I am studying about the travel behaviour of working parents. How do I key in data about their children in SPSS? This is really important considering the factor of number of siblings and gender in a family influence the travel behaviour.
For example, a respondent have 4 children;
1. Female, Age 3
2, Female, Age 5
3. Female, Age 6
4. Male, Age 9
For now, I key in according to total number of children they have. For example:
Female=3
Male=0
Age < 1 month = 0
Age > 1 m – 1 y = 0
Age > 1 y - 2 y = 0
Age > 2 y - 5 y = 2
Age 6 y - 12 y = 2
Is this the right way? Because I have a hard time to analyse this kind of data. Really appreciate if anyone of you can help me. Thank you
Hi,
For each subject create separate columns for children and enter their actual ages.
S.No:1 Male_chld1 Fem_chld1 Male chld_2 Fem_chld2....MChld4 Fem Chld4
1 - 3 - 5 ..... 4
You can group them later for analysis.
Or
Convert ages into months .your choice.
This also gives you flexibility in analysis later.
You can code the empty spaces or just leave them.
You may use one-hot-encoding for each child. Creating a column for each variable and, giving each column 0-1 values.
Hi you should key in one row per person per time point in a spreadsheet. The columns will be age. Then have a family indicator that will help you identify the families. You should not be thinking about analysis at this point. The goal is to capture all the data that you have collected. Subsequent data wrangling can help you to get the dataset into the shape or state that will allow you to do the appropriate analysis.
- Badges
- Science topic
- Similar topics
- Medicine
- Epi
- Age Groups
- Children