+ Reply to Thread
Results 1 to 4 of 4

Finding patterns in a database

  1. #1
    Registered User
    Join Date
    05-04-2019
    Location
    Iceland
    MS-Off Ver
    2016
    Posts
    15

    Question Finding patterns in a database

    Screenshot_1.jpg


    Hello I have a very confusing problem for me that I am really struggling with



    Here is the problem:
    I have a database which includes 1500 cities. Each city has 3 type of characteristic and a value.

    My intention is to group cities together which have very similar values (around +-50), and to see the patterns behind values based on 3 characteristics. As you see, we can search for 7 possibilities (2&3, 1&2, 1, 1&2&3...)

    I want to infer something like this: "The cities which have very similar values (around +-50), show us that characteristic-2 and characteristic-3 of those cities are the same"


    What should I do?
    Attached Files Attached Files
    Last edited by neutral5; 11-30-2019 at 10:03 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,576

    Re: Finding patterns in a database

    What should I do?
    Post a sample sheet as described in the yellow banner?

  3. #3
    Registered User
    Join Date
    05-04-2019
    Location
    Iceland
    MS-Off Ver
    2016
    Posts
    15

    Re: Finding patterns in a database

    Quote Originally Posted by Pepe Le Mokko View Post
    Post a sample sheet as described in the yellow banner?
    I have attached the sample file in my first message

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,336

    Re: Finding patterns in a database

    Your sample file is the same as the picture. What patterns do you see in the 9 sample cities you have provided? How did you detect them? I can see that Helsinki (X, A, 1, 210) might be similar to Berlin (Y, A, 1, 213) because they are essentially the same in 3 of 4 columns, but I cannot say if that is the kind of pattern you are looking for.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding patterns in column
    By Jamesmc01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2019, 11:42 AM
  2. help finding patterns in columns?
    By HMexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2019, 01:54 PM
  3. [SOLVED] Excel finding patterns across data range
    By hazzaska in forum Excel General
    Replies: 5
    Last Post: 04-21-2017, 02:42 AM
  4. finding the frequency of patterns in data set
    By fatterthanelvis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2016, 08:28 AM
  5. [SOLVED] finding patterns in a range of cells
    By shart2k12 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2013, 11:07 AM
  6. Finding patterns
    By GaidenFocus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2012, 03:59 PM
  7. Finding same patterns in groupings of cells
    By modoud in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2007, 01:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1