+ Reply to Thread
Results 1 to 2 of 2

Pattern Recognition

  1. #1
    Registered User
    Join Date
    07-31-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    6

    Pattern Recognition

    Hi,
    Maybe I'm dreaming here, but I'm wondering if there is a way to have Excel identify patterns in multi-column data sets?
    I'm trying to predict volumes (of people) based on historical data. I have a year of data with a number of people for each date.

    I've manually identified day-of-the-week patterns (i.e. certain days are generally busier than others) and one other pattern based on week of the month (i.e. 4th wednesdays are busier than 2nd wednesdays). I did this essentially by hand; sorted then chopped data into day of the week chunks, and then which week (1st mondays, 2nd mondays, etc.) then ran basic distributions on those mini-chunks. So I have a nice table of:

    (Min)(Mean-SD)(Median)(Mean+SD)(Max) for each Day category (1Mon,2Mon,3Mon.....3Fri,4Fri,5Fri)


    Pattern-wise, nothing else jumps out at me, but I'm wondering if there are any built-in analytical tools that can cross-reference and help me spot anything else I'm missing.

    I'm looking for something that can tell me e.g. "Mondays in January are slower than average mondays, but Tuesdays in January are busier than average Tuesdays" so to speak.

    I'm already sorting it by day, by weekday, by week, by month and nothing else leaps out.

    Thanks in advance!
    Lenny
    Last edited by lennywatson; 08-01-2017 at 06:58 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Pattern Recognition

    You could upload an example workbook and show us what you have so far.
    Probably you will get some help then.
    Kind regards,
    Piet Bom

+ 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. Conditional Formatting: Pattern Recognition
    By Joeleol in forum Excel General
    Replies: 2
    Last Post: 06-15-2017, 09:22 AM
  2. Help with pattern recognition
    By micro7311 in forum Excel General
    Replies: 3
    Last Post: 10-09-2016, 06:31 PM
  3. Need coloured background columns in chart for easy pattern recognition
    By HitTheEXCELerator in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-18-2015, 11:35 AM
  4. [SOLVED] Formula pattern recognition
    By cjchris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2013, 12:08 PM
  5. String of characters recognition without a pattern ?
    By Phalanx_ in forum Excel General
    Replies: 3
    Last Post: 04-18-2013, 06:05 PM
  6. String manipulation and pattern recognition
    By TYork in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2010, 08:58 AM
  7. Pattern Recognition in numbers
    By Ahurdle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2008, 08:34 AM

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