Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2013
    Thanked 0 Times in 0 Posts

    Pattern identification


    How can we identify patterns in numbers using excel formulas? I have also attached some numbers as sample and I am looking to find out the pattern of them.

    Appreciate your help.


    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    Some general thoughts:
    Plat the data. Since you only have one set I presume that they are regularly pulled and a line chart is sufficienct. If not taken at regular intervals, you need the pattern of intervals as the X and they plot as an XY

    After viewing the data, ask yourself if you see an obvious pattern [I do not in this data set].

    There may be trends and the data could be fit to some model. Look to see if there is a theotical model or if not try some curve fitting to interpolate (excel has many different types that can be used, all with plusses and minuses.

    I see nothing in the data that would give me any confidence in future predictions..

    If this were some kind of production output, I would be investigating what may have changed around the time of point 15-25 where the average increased and the variability between points increased.

    My interpretation is that you have 2 random distributions of data: points 1-around 21, have one average and 1 Std deviaiton and a second distribution after point 21 with a higher average and a much large std deviation...

    Last edited by sdckapr; 2013-12-01 at 07:14.

Posting Permissions

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