Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Finding Center of Data

This is a discussion on Finding Center of Data within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have zip codes with dollars spent in those zip codes. I woud like to map them out (which I ...

  1. #1
    kerleyp is offline Junior Member White Belt
    Join Date
    Aug 2005
    Posts
    1

    Finding Center of Data

    I have zip codes with dollars spent in those zip codes. I woud like to map them out (which I have done) I now have a request to find where the center point on the map so that a location in the middle could be used for a warehouse.

    As an Example. If half of the zip codes were in Chicago and Half were in Indianapolis but 70% of the money was spent in Chicago I would like to see so that I could determine maybe Gary Indiana as a Good "Center" of Dollars Spent.

    Any idea?

  2. #2
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    Hi,

    If you want to have a fast solution, you have to choose a pragmatic way:

    - As you have the information on the map, you can see in approximate way the best location for your warehouse or warehouses.

    Put 3 or 4 PushPins as assumptions in the map and for each one calculate a drivetimezone. Export the the Data on the map to Excel and you will see wich one has the best potential. You can make some balanced calculations with Population, Number of households, and so on...
    - Now if you want to have a sophisticated solution you need more information about Population, competitive area and Mappoint won't be sufficient.
    If you have some time look at this site. You can get more ideas:
    http://geography.about.com/cs/cities.../aa041403a.htm


    In my job, when we choose a location for a superstore we can garantee that the error of forecast will not exceed 5%. We don't use Mappoint, we go there and get precise information about distances, customers, competitors, and so on..


    Best Regards

  3. #3
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    Look especially at this:

    http://www.msac.com/pptm/images/img20.gif

    an this:

    http://geography.about.com/gi/dynami...s/gravity.html
    Section : Predictive Gravity Modeling for Marketing

    When I have enough time and when I control Mappoint better, I will try to apply this theory with Mappoint.

    Rgds

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Center Point
    By colin_turner99 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-14-2006, 02:38 PM
  2. Center Map to a pushpin?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 02-14-2005, 05:31 PM
  3. Finding USA Data
    By everblader in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-19-2005, 01:41 PM
  4. Finding the center of a group of pushpins
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-07-2004, 04:51 PM
  5. Finding which pins from two data sets are at same location
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-12-2004, 08:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27