In ArcGIS we were asked:

Determine the number of stores per 100,000 people in each state, using the POP2014 field. Which state has the most stores per capita? Which has the least? (Hint: In a joined table, only the target table fields may be calculated.)

This step has been completed. After joining the tables and compiling the data successfully, we were then asked to:

Capture a map showing the number of stores in each state; include a legend in the map. Also capture a map showing the number of stores per capita in each state. Compare the two maps and discuss what they could mean.

I have not been able to figure out how to take the data from the new table and create a working layer. The tool creates a layer with unusable numbers as shown in the image. Please advise on what I'm doing incorrectly.

Thanks

 

Transcribed Image Text:

Print Layout Geoprocessing Contents Make Feature Layer + Search Parameters Environments Input Features State Population Output Layer Stores ? Drawing Order Stores Per State Map Stores Stores Per State Map X Layout2 Expression FREQUENCY -1.797693e+308 - 1.797693e+308 Load Save Remove D State Population 1:41,088,038 124.4323942W 44.1947019N SQL Topographic Stores PerState X Where Select a... + Add Clause X Standalone Tables Field: Selection: Rows: store openings.csv OBJECTID * STATE_ABBR FREQUENCY COUNT_storenum STATE ABBR Openings Table 1 4 CA 159 159 CA Workspace or Feature Dataset StoresPerState 2 32 NY 83 83 NY 3 29 NJ 41 41 NJ Field Info 4 45 WA 40 40 WA Run 5 44 VT 4 4 VT Make Feature Layer completed. View Details Open History 0 of 48 selected Filters: Filters: $ Print Layout Geoprocessing Contents Make Feature Layer + Search Parameters Environments Input Features State Population Output Layer Stores ? Drawing Order Stores Per State Map Stores Stores Per State Map X Layout2 Expression FREQUENCY -1.797693e+308 - 1.797693e+308 Load Save Remove D State Population 1:41,088,038 124.4323942W 44.1947019N SQL Topographic Stores PerState X Where Select a... + Add Clause X Standalone Tables Field: Selection: Rows: store openings.csv OBJECTID * STATE_ABBR FREQUENCY COUNT_storenum STATE ABBR Openings Table 1 4 CA 159 159 CA Workspace or Feature Dataset StoresPerState 2 32 NY 83 83 NY 3 29 NJ 41 41 NJ Field Info 4 45 WA 40 40 WA Run 5 44 VT 4 4 VT Make Feature Layer completed. View Details Open History 0 of 48 selected Filters: Filters: $