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

    Pattern identification

    Hello,

    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.


    Thanks

    Saeed
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    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...

    Steve
    Last edited by sdckapr; 2013-12-01 at 08: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
  •