Using the Esri Maps for Office Add-in for Microsoft Office to analyze patterns in a spreadsheet data. Esri Maps for Office Add-in will produce the Cluster map, Heat map and Hotspots map of the dataset.
The map of the spreadsheet data is created showing three categories of Point features. The Point features represent schools within the district while the symbols are the different ownership structure of the schools.
A Cluster map will show where the Points are most clustered on the map. To produce the Cluster map, Click on Cluster Points (cursor finger). A Cluster Points window appears on the Left pane. Switch the Clustering from the OFF position to ON position.
The Cluster map is created showing over half of the Point features (schools) are in the central part of the map. Another deduction from the pictographs on the map is that there are no Privately owned schools to the east of the map as that symbol colour is absent in the cluster ratios chart (red boxed).
Next we analyze for where the Point features are more concentrated, that is, analyze for their Hot spots. Click on Hot Spots Analysis and a Hot Spot Analysis window opens on the left pane. Select by Point densities or by attribute values (must be integer field) and name the results layer. Click RUN ANALYSIS.
The results in seen in the screenshot below. Hot spot with 99% confidence is in the central part of the map.
Next the Heat map. First revert back to the Point map and Simply Click on Heat map and the result will be generated as seen in the screenshot below.
From the post, we have shown how to produce three different maps from the spreadsheet data using Esri Maps for Office Add-in.
Thank you for the audience.