So I made a join of an excel file containing my data (fish counts, population density, water quality..ect) to a shapefile with area data (area, acres, hectares). In the attribute table, the join looks fine, all the data I wanted together is joined. The problem is when I try to do spatial stats analysis nothing from the exel file that was joined to the shapefile is available, only attributes from before the join. For example, when I want to use the High/Low Clustering Tool and use the shapefile with the join as the input, under "Input Field" I only have the potion to choose attributes from the shapefile before the join for analysis. I tried exporting the data into a new shapefile and am having the same problem.
Does anyone have any suggestions on what I possibly did wrong or forgot to do? Any help/suggestions will be appreciated. Thanks.
Ali