Last modified by Maptitude Support - 1 month ago
238 Views
4 min read

What kinds of Comparison Analysis can I do for two groups of locations?

The March 2020 Maptitude Newsletter contains a detailed analysis, comparing the types of areas that Kroger and Albertsons, both national US Grocery chains, have their locations in.

This article will walk through each step of this analysis to explain how it was done. This kind of analysis can be done on any two groups of locations.

Step 1: Add Layers to Map

The first step in the analysis is to add the layers you want to compare to the map. If you are looking to compare a list of addresses from Excel, you can geocode them into separate layers. To add two chains of business locations to the map:

  1. Open any map of the US
  2. Go to Map>Layers… and click Add Layer
  3. Navigate to where you have the Business Location data saved
    1. If you do not have the Business Location data installed, download them from our online store
  4. Highlight the chains you would like to compare and click Open
  5. Click Close and check that the layers have been added to the Display Manager

 Note that if you are far zoomed out, these layers may not appear in the map itself until you zoom in.

Step 2: Create the Density Grids

The first piece of analysis done in the Newsletter is simply to show where these two chains have a high density of locations. To do this we will create two Density Grids, and apply a different theme to each.

To create the Density Grid for the Kroger locations:

  1. Click in the main toolbar
  2. Under Layer, choose US Kroger
  3. Under Set, choose All Features
  4. Next to Radius, type 100
    • Note: This value entered for radius will depend on the data you are using. Larger values will mean that each individual location will "spread out" more in its contribution to the Density
    • You can repeat steps 1-6 using different values for Radius to find one that works well
  5. Next to Name, type Kroger Density
  6. Click OK
  7. Make Kroger Density the working layer
  8. Click in the main toolbar
  9. Go to the Styles tab
  10. Under Color Sets, choose From to be white and choose To to be a shade of red
  11. At the top, highlight Other and click Style
  12. Change Fill Style to None and click OK
  13. Highlight the first class after Other and click Style
  14. Change the Fill Opacity to 50 and click OK
  15. Click Copy Pattern and click OK

This will create and style the Density Grid for the Kroger locations:

Repeat the above steps for Albertsons, but change the name of the Density layer and use a shade of blue instead of red

Step 3: Tagging the Data

Next, we are going to use two of the free data products that come with Maptitude 2020 to analyze the types of area that these two chains tend to have their locations in. We will be using the Consumer Expenditure data to see how much is spent on Groceries per Household in the areas surrounding each location, and we will be using the Geodemographic Segmentation to see which segments each chain tends to target.

  1. Go to Map>Layers… and click Add Layer
  2. Navigate to where you have the Consumer Expenditure data saved
    1. If you don’t have this data installed, you can download it from our online store
  3. Highlight ccConsumerExpenditure.cdf and click Open
  4. Click Add Layer
  5. Navigate to where you have the Geodemographic Segmentation data saved
    1. If you don’t have this data installed, you can download it from our online store
  6. Highlight ccGeodemographicSegmentation.cdf and click Open
  7. Click Close
  8. Make US Kroger the working layer
  9. Go to Tools>Analysis>Tag Points by Area…
  10. Choose these settings and click OK:
  11. Go to Tools>Analysis>Overlay
  12. Use these settings and click OK:
    • Note: The value you choose for Buffer Size should reflect the size of the radius that you want to consider around each location
  13. We now want to save the resulting analysis. Go to File>Export>Table and save the analysis in an appropriate location with the name Kroger Analysis. You can now close the Dataview
  14. Repeat Steps 8-13 with the US Albertsons layer

This will save an Excel file for the analyzed layers that tells you:

  1. The Subsegment from the Caliper Geodemographic Segmentation that each location is in
  2. The Annual Average Expenditure per Household on a variety of different categories for the 1-mile radius surrounding each location

Step 4: Summarizing the Segmentation Data

To analyze the Segmentation data, we need to count up the number of locations in each Subsegment:

  1. Go to File>Open, change the File Type to Excel Worksheet and find the Excel file you saved as Kroger Analysis. Click Open
  2. Make sure Import is checked and click OK. Click No when prompted to create a new geographic file.
  3. Go to Dataview>Tools>Group By…
  4. Under Field, choose [Segmentation:Subsegment]
  5. Click Attributes, click Clear, click OK and then click OK

This will make a table showing you the count of each location In their respective Subsegment. For more information on what each subsegment means, see the Demographic Handbook

You can export the table out to Excel using File>Export>Table or you can simply Copy and Paste into Excel as well. Repeat for the Albertsons locations.

In the newsletter, we simply used these counts to find the Subsgements where a high percentage of each chain’s locations were found and examined if there was much overlap.

Step 5: Making a Box Plot

Box Plots are a data visualization option that we added in Maptitude 2020. They allow you to visualize how one field changes over a set of data, giving a clear representation of the median value as well as how spread out the values tend to be.

In this example we will be creating a box plot based on the Average Spending at Grocery Stores around each location. You can choose to use any of the Expenditure fields, depending on your needs.

To make the Box Plot:

  1. Right-click on Consumer Expenditure in the Display Manager and choose New Dataview
  2. Go to Dataview>Statistics>Box Plot
  3. For X, leave the Title blank and change the Angle to 0
  4. For Y, type Expenses at Grocery Stores ($) as the Title
  5. Click three times
  6. For the first row choose:
    1. Table: Kroger Analysis Table
    2. Field: [Avg Expenses at Grocery Stores]
    3. Selection: All Features
    4. Title: Kroger Locations
  7. For the second row, choose:
    1. Table: Albertsons Analysis Table
    2. Field: [Avg Expenses at Grocery Stores]
    3. Selection: All Features
    4. Title: Albertsons Locations
  8. For the third row, choose:
    1. Table: Consumer Expenditure
    2. Field: [Expenses at Grocery Stores]
    3. Selection: All Features
    4. Title: National
  9. Click OK

This will create a chart that can then be resized and printed. You can export to an image by right-clicking on the box plot and choosing Export, or you can print directly to PDF using the print icon.