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.(adsbygoogle = window.adsbygoogle || []).push({});

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.

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Regression with uncertain data

Loading...

Similar Threads - Regression uncertain data | Date |
---|---|

A Error estimation in linear regression | Mar 12, 2018 |

I ANOVA and Linear Regression Resource | Mar 2, 2018 |

A Linear regression with discrete independent variable | Feb 13, 2018 |

I Logistic Regression | Feb 9, 2018 |

B How to calculate the uncertainity errors | Mar 14, 2016 |

**Physics Forums - The Fusion of Science and Community**