I have some census data on income I would love to analyze. But income, in the data, is split into different income groups, each group is a column containing the number of people in an area that earns A to B. If my explanation doesn't make any seance please look at the table below. 

So basically I want to get the average income for an area. Can this even be done with data like this?

[![enter image description here][1]][1]


  [1]: https://i.sstatic.net/ZiZfG.jpg