Hi,
I have a dataset with a column for different ranges of household income and i want to use an index (or dummy variable ) to represent each category of household income. How can i do it using excel ?
obs no household income need to created this index
1 less than $20,000 1
2 $20,000 - $29,000 2
3 $30,000 - $39,000 3
4 less than $20,000 1
and so on .....
Thanks in advance,
Pat
Bookmarks