+ Reply to Thread
Results 1 to 2 of 2

changing or removing unreliable data

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    Lithuania
    MS-Off Ver
    Excel 2003
    Posts
    1

    changing or removing unreliable data

    Hello

    I'v done scatter, but some of the used data values are jumping far away from the others, they are unreliable. You can see, that curves follows swinging pattern, so it is obvious that those (unstable) values can have negative effect for calculating accurate mean value. How can i change or remove those data values without doing it manually. grafikas.JPG

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: changing or removing unreliable data

    First you have to determine which data has to be excluded.

    After that you can use a helpcolumn to determine if the data has to be in- or excluded.

    After that make a graph of the data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. removing or changing data in a cell by inputting date in another cell
    By markac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2014, 09:39 AM
  2. Application.Calculate being unreliable
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2013, 04:06 AM
  3. Unreliable pivot table
    By amalfaro in forum Excel General
    Replies: 9
    Last Post: 07-16-2012, 10:25 AM
  4. Scrolling in Excel unreliable
    By Peter in forum Excel General
    Replies: 0
    Last Post: 06-20-2006, 09:35 PM
  5. [SOLVED] V Lookup w/ unreliable data
    By hshayh0rn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2006, 04: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