| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you exclude outlayers in Excel?
I have a table with a bunch of figures and want to exclude the more extreme
figures from calculations... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you exclude outlayers in Excel?
The criteria for deciding what is extreme is key to answering your question.
However, 1 way:- =AVERAGE(IF((A1:A10=2)*(A1:A10<=8),A1:A10)) The above looks at the range A1 - A10 and averages the numbers in the range that are =2 and <=8. It's an array entered with CTRL + Shift + enter. The 'average' bit could simply be changed to whatever calculation you are trying to do. Mike "Dags17" wrote: I have a table with a bunch of figures and want to exclude the more extreme figures from calculations... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you exclude outlayers in Excel?
Well, the answer to that question depends on what your criteria is. So,
what's your criteria? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dags17" wrote: I have a table with a bunch of figures and want to exclude the more extreme figures from calculations... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you exclude outlayers in Excel?
Calculate the mean and standard deviation of your data. Then exclude points
more than 3 sigma ( or any sigma of your choice) away from the mean. Be very careful about excluding outliers. If they are real data points, they may indicate your variance is actually larger than you expected. -- Gary's Student gsnu200709 "Dags17" wrote: I have a table with a bunch of figures and want to exclude the more extreme figures from calculations... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you exclude outlayers in Excel?
Hi
Take a look at the TRIMMEAN function. -- Regards Roger Govier "Dags17" wrote in message ... I have a table with a bunch of figures and want to exclude the more extreme figures from calculations... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude cells that are the same as list in Excel 03 | Excel Discussion (Misc queries) | |||
| I wish to edit the calendar used in excel to exclude weekends | Excel Discussion (Misc queries) | |||
| exclude data already imported in excel | Excel Discussion (Misc queries) | |||
| Max Value in a column exclude selection - Excel VBA | Excel Discussion (Misc queries) | |||
| How do I exclude non-duplicates from an excel file? | Excel Worksheet Functions | |||
Linear Mode
