I have data looking like the following:
Latitude Longitude Class
35.773444 -78.6305752 0
38.82349688 -77.61919194 1
41.4985021 -81.7144364 1
39.9528 -75.2104 0
Longitude, latitude and classification columns. Attached is the simple map I have created in ArcGIS. But ultimately how I imagine to display the map includes the followings:
*** 1) States with more dots (red or green) will be enlarged in size comparing to States with less or no dots
*** 2) States with more green dots become more green, States with more red dots become more red
I have seen examples where the colors of each states are gradually different (for example: population size for each state), but the actual numbers (ie: State populations) are already recorded in the data file. As you can see in my original data file, it only has lat and lon data, I don't have numbers of dots per State in my data.