So I have this set of statistical data, which is not completely relevant to what I want to model, and I would like to compensate for that somehow since I do not have the more precise data. I have about 500 observations of average wages in certain areas which are modeled as dependent on several other parameters (taxes in the area, education of people living in the area, age, etc). The problem is, for each one of those areas I know in percent (from about 5% up to 50%) amount of people travelling to other areas to work there (and ofc getting paid by that area's standard), while still living in home area (and ofc contributing to parameters in home area). Any ideas how to deal with this kind of problem? I was thinking about weighted regressions but I got kinda stuck since they use standard deviations which is different from what I have. PS I am working with regressions in Excel but any help would be appreciated.