| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find outlier among a group????
I have approximately 50,000 product records with descriptions and costs
however in each group of similar products there are some that have outlier costs assigned. for instance one group of like items may have costs ranging from $2-$3 with one or two of the items assigned a cost of $150. Is there a way of looking for these kind of outliers? Thanks in advance. -- Jeff C Live Well .. Be Happy In All You Do |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outlier analysis in excel - trimming means | Excel Worksheet Functions | |||
| Generating random numbers with the occasional outlier | Excel Worksheet Functions | |||
| How do I test outlier in Excel? | Excel Discussion (Misc queries) | |||
| Is there an easy way to "exclude" an outlier datum from calculatio | Excel Worksheet Functions | |||
Threaded Mode
