I have shapefiles representing a country, states of that country or towns etc... For each shapefile there is associated data with them.
The country shapefile has 100 rows and maps to .csv files with 100 rows, same goes for towns, states etc. Basically it gives me a flexibility at how much level I can experiment with.
Now, let's say I chose the states data and I wanted to find whether folks with education are more likely to get jobs than those who don't, the first and easy part was to join the shape file to its .csv file that contains data about employment.
After that I simply got confused.. the csv files contains raw data and how to use them confuses me, an example (fake data):
SID STYPE SNAME MALEP FEMALEP EMPLOYED UMEMPLOYED EDUCATION S1 STA Alabama 4345 1003 100000 2000 1000 S2 STA Alaska 1456 8343 8888 4000 S3 STA Arizona 90000 1247 1000 S4 STA Arkansas 18831 1213 0
How do I use the data above? I don't think a select by attributes will do me any good as it shows just a blue border, and I don't know how I could possible query that? It doesn't give me any specific data, it is just an aggregate.
I think my best option is to use either categories or quantities symbology.
However, I'm not sure how to get meaningful data. If I was to use quantities (I think quantities is the way to go), do I simply normalize people who are employed against people having education? How would I display the output.. density dots or gradient symbology/color?