outlier

  1. R

    Outlier detection and removal from ranges

    Good day, I have a two ranges (for X and Y data) that I graph on a userform using the traditional method of graphing, exporting to image, and loading the image into a picture control. Oftentimes, the data in the Y data has a few errors in terms of outliers (X data is just dates). I'd like to...
  2. L

    Interquartile Outliers - Removing anomalies from data

    Hi All, I have wrote the following function from what i have read online to mark all the data that is outside the "normal" values of the range. Data source on google docs sheet here - https://drive.google.com/file/d/0B6BOCseXW1yZMEdELXpIazd5OFk/view Only problem is that it doesn't seem to...
  3. T

    Removing outliers from being counted in Average/Standard deviation functions??

    Hi, As a sciences undergrad, I have a number of massive lists of data that I need to sort through... Some of the averages and standard deviations are getting massively skewed as a result of outlier data.. Is there a way I can exclude these from my =St.dev or =avg function without having to...
  4. B

    excluding data from a formula

    I have a set of data containing outliers based on a median and mean. The data is all in one column and the median and mean are each calculated in one cell via the average and mean formulas. in another column, if a value is an outlier i have it marked as "high" "low" or "" depending on whether...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top