outliers

Hello, I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects. I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal...

Hello, I am working on a project and told to remove all outliers by using the ? +- 3? approach. I am wondering how i should go about this? do i need to calculate the mean and all quartiles to remove the outliers or is there a single excel function that can remove the data outside 3 standard...

Hello, This on has me baffled and I tried everything I could think of. Longstory short, I'm working with an old windows program that extracts data into anexcel worksheet. There are a ton of rows,but many are useless (like headers, totals, other stuff) Anyway, I did discover that the data I...

I want to do formula for an average of L12W Sales without any outliers or peaks or bottom. What would the formula be? For example, here is last 12 weeks sales. I want it to average the sales in between 45-75 not taking 2,3,150,250 into the average. <tbody> 50 2 150 75 45 48 65 52 250 55 3 60...

<tbody> Organization month KPI1 KPI2 KPI3 KPI4 Org1 Jan-18 100% 0 3 4% Org1 Feb-18 99% 0 2 2% Org1 Mar-18 100% 0 3 1% Org2 Jan-18 86% 3 1 1% Org2 Feb-18 82% 0 1 6% Org2 Mar-18 90% 1 3 1% Org3 Jan-18 97% 9 4 2% Org3 Feb-18 99% 0...

Hi, I have a set of data that I would like to calculate the average excluding outliers (more than 800) and zeros. I am using the formula formula for excluding the outliers: =AVERAGEIF(C4:C21,"<"&800,C4:C21) Is there a way to modify to exclude zeros as well ? Appreciate all the help.

Greetings, I have two columns of data: A) Stock P/E B) Port Weight The data is susceptible to outliers so I'm using TRIMMEAN to calculate the average P/E. Now I'd like to calculate a weighted average that also excludes outlier values. Assuming I can't simply delete the outliers from the data...

This is my data: 300, 300, 300, 300, 300, 20300, 20300 Looking at it, I would say the last two values, 20300, are outliers. However, following this method...

I have been running this spreadsheet with the current macro "Outliers" for the last several months. I was using an older version of excel (1997 - 2003). The macro has worked fine. I just upgraded to Office 365 and saved the current workbook as an "Excel Macro-Enabled Workbook. Since I made...

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...

I'm attempting to establish trends and slopes that ignore outliers or inapplicable data. Here is my problem: 1. My data range is 16 columns wide, starting at row 6 (U6 to AJ6). Downward from there is more data in the same format, so we really only need to address one line, with the columns as...

I've investigated a whole lot of addins and other software (including stand alone) but have yet to find any that provide an easy (automated) way to remove outliers (say, above/below 2x std). I sure could use something very easy for an app I am building for general users. Anyone know of...

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...