+ Reply to Thread
Results 1 to 4 of 4

Find peaks in irregular data

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Holland
    MS-Off Ver
    Office 365 ProPlus
    Posts
    11

    Find peaks in irregular data

    Dear all,

    I have a big data set of which a portion can be found in attached example. In general you can see reoccurring cycles of which I would like to count how many times a cycle has a max in the given time period.

    What I tried so far is counting peaks, I've currently used the following formula in column C; =IF(IF(AND(B4>B5;B4>B3);B4;NA())>1500;IF(AND(B4>B5;B4>B3);B4;NA());NA()) ; which picks up all peaks above 1500. How ever some peaks are duplicates (yellow circles). Is there a formula which only generates one peak per cycle in stead of multiple peaks due to noise in the data?

    In the end I would like to obtain the total amount of peaks (which is in the example 21), maybe above is not the smartest way to get this number because you still need to make a table and filter out the #NA(). Please let me know if there are any other suggestions to get the amount of peaks.

    Hope somebody can help out!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Find peaks in irregular data

    Use this formula in C13 and copy down. There are no maxima in C3:C12 so you can leave those blank.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This will ensure that the maximum is not just a local maximum, but a maximum within an interval of ±10 points.

    I hard-coded the interval as 10. If you need to tune it I can provide a more comprehensive formula that would allow it to be a variable.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Find peaks in irregular data

    Better formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-04-2012
    Location
    Holland
    MS-Off Ver
    Office 365 ProPlus
    Posts
    11

    Re: Find peaks in irregular data

    Thank you for your quick answer, this was exactly what I was looking for!

+ 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. How do Identify MAX and MIN Peaks in a Set of Data
    By claudioasn in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-26-2015, 11:01 AM
  2. Finding Multiple peaks, and duration of peaks
    By jav418 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2015, 03:05 PM
  3. How do I identify multiple max peaks in data set
    By jon2316 in forum Excel General
    Replies: 7
    Last Post: 10-08-2014, 05:42 AM
  4. [SOLVED] How to find multiple peaks in a data set
    By willevans in forum Excel General
    Replies: 9
    Last Post: 03-29-2012, 06:37 AM
  5. Replies: 1
    Last Post: 11-02-2009, 09:00 AM
  6. Identifying Peaks in Data
    By SportsScientist in forum Excel General
    Replies: 11
    Last Post: 05-06-2009, 07:25 AM
  7. Replies: 2
    Last Post: 06-01-2006, 03:55 PM

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