+ Reply to Thread
Results 1 to 1 of 1

Skip periodic and noisy data point 4000 times

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Skip periodic and noisy data point 4000 times

    Hi all,

    To those of you who help me out with this task, thanks in advance!!

    Got a pretty big task set in front of me.

    I have a graph with 4000 repetitions of sinusoidal-like motion with a single outlying data point every downward sweep.

    Of course this ends up being 4000 data points which need to be skipped (Not deleted) as each data point is a minute(time) and by deleting i would lose 4000 minutes of data.

    Does anyone know of a way to "skip" these outliers and have the data remain continuous without breaks?

    I'd prefer not to manually delete 4000 points. Plus I have more than one graph that does this


    EDIT: I have added a pic to show my problem.4000 outliers.JPG


    Cheers

    Baz
    Last edited by baz0110; 05-17-2012 at 02:07 AM. Reason: Adding picture

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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