+ Reply to Thread
Results 1 to 1 of 1

Getting rid of data outliers

  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010 64-bit
    Posts
    14

    Getting rid of data outliers

    I have some mostly good data with some extreme outliers on the high side. My goal is to find the maximum value of the good data. My idea is to use a function similar to the MEDIAN function that will pick out the 90th percentile member of the population. MEDIAN does a great job for the 50th percentile member and PERCENTILE appears to give a percentile fractional number of the inferred distribution. Any way that I could get these two functions to get together and make a new function that picks the highest non-outlier member from my data?

    Thanks in advance!
    Last edited by mwwoodm; 05-10-2012 at 08:48 PM. Reason: clarity

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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