| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate mean without outliers
I'm trying to assist a client with this. He needs to find the mean of numbers
with the exception of those that are very different from the rest - outliers. Can you give us some ideas of how to do this? He is trying to avoid adding extra helper columns to do this. Thanks. -- maryj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I identify statistical outliers with excel? | Excel Discussion (Misc queries) | |||
| Identifying Outliers | Excel Discussion (Misc queries) | |||
| Boxplots with outliers | Charts and Charting in Excel | |||
| outliers/histograms | Excel Discussion (Misc queries) | |||
| How do I calculate outliers in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
