EDIT: I am using Armap 10 sp 5 I have found similar questions but they were either unanswered or somewhat different to what I am asking.
I have a raster with cell values 1-5 and a polygon shape file with regular grid of squares the same size.
All I need as output is a table with the polygon ID and the raster value. I tried to use the zonal tool but in the option it does not have a weighted average based on the area that each raster cell occupies in the polygon grid cell. For example in a grid cell I might have two raster cells, one of value 2 that occupies 30% of the area and one value 5 that occupies 70%. My result would be 2*.3+5*.7=4.1 instead of 3.5 that I get with zonal tools.