Jan 7, 2007 · Often, "outliers" are merely indicative of extreme skew in the distribution. One way to graph the data in Excel is to select the data, then click on the Chart Wizard on the toolbar …

Nov 15, 2006 · I would like to use excel for outlier analysis removal - to calculate a mean of a range but not include or change values that are 2 or 3 standard deviations above or below the …

Oct 31, 2005 · Is there a way for excel to automatically determine outliers in a given data set and exclude them from future calculations?

Mar 12, 2007 · I am looking for a way to automate the Dixon Test for determining outliers in a data set in an Excel spreadsheet.

Sep 11, 2008 · There are a few mysterious Excel files in my network folder. I think it's accidentally dropped by someone on the network. I thought you can find the original creator's name based …

Aug 23, 2005 · Hi, I want to apply TRIMEAN to a filtered data set. TRIMEAN ignores a set percentage of outliers. I am currently using AVERAGE embedded in SUBTOTAL, but there is …

Oct 1, 2008 · I have 2 EXCEL files with the same amount of data but have different sizes in bytes. One file size is 50KB the other, 1.5MB. What could be contributing to this difference in size, …

Oct 11, 2006 · To find the last row used by the pivottable I used the Following expression: LastLine = UBound(ActiveSheet.PivotTables(1).RowRange.Value2) + …

Sep 17, 2009 · I enter a date in one column, in the second column i want the day for that date. If the day happens to be the 2nd or the 4th saturday in that month, it should get highlighted. How …

May 1, 2008 · I need to show the difference either plus or minus between two cells..i.e... Col.1 is 10.00, Col.2 is 20.00, Col.3 needs to say that Col.2 is 10.00 over...