I’m trying to continue some analysis that used the values of WKSWORK1 to create an approximation of labor supply. However WKSWORK2 is the available variable for the years in question, and it groups these values into 6 categoricals of #weeks worked. What is the best way to approximate the actual number of weeks worked from these 6 categories?
I have considered just taking the average of each category:
1 = avg(1, 13) = 7 weeks
2 = avg(14, 26) = 20 weeks etc.
But this seems innaccurate.
Is there a better way to approximate the actual values of the WKSWORK2 categories for a given sample?