Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trimmean for limited array
Hi there,
What function would you use to determine an average on a limited array which should be evaluated? With a limited array I mean: just 5 to 8 values. The reason why: I might have a pos. or a neg outlier in this limited range which I would filter out. The probability to have 2 outliers is nearly inexistant. I thought =TRIMMEAN(B10:B17;40%) would be the best option. Do you have other suggestions? Best Regards Sige |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trimmean for limited array
If, for example, you have 5 values and you'd like to average the 4
highest ones, you can use the following formula... =AVERAGE(LARGE(A1:A5,{1,2,3,4})) Hope this helps! In article .com, "Sige" wrote: Hi there, What function would you use to determine an average on a limited array which should be evaluated? With a limited array I mean: just 5 to 8 values. The reason why: I might have a pos. or a neg outlier in this limited range which I would filter out. The probability to have 2 outliers is nearly inexistant. I thought =TRIMMEAN(B10:B17;40%) would be the best option. Do you have other suggestions? Best Regards Sige |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trimmean for limited array
Sige,
For a small sample with outliers, average (mean) may not be the best measure. Perhaps MEDIAN would be more appropriate, or using the STDEV as a measure before deciding. Personally, I would compare the results from some past data sets and see what function or combinations of functions returns the more useful number most of the time. HTH, Bernie MS Excel MVP "Sige" wrote in message oups.com... Hi there, What function would you use to determine an average on a limited array which should be evaluated? With a limited array I mean: just 5 to 8 values. The reason why: I might have a pos. or a neg outlier in this limited range which I would filter out. The probability to have 2 outliers is nearly inexistant. I thought =TRIMMEAN(B10:B17;40%) would be the best option. Do you have other suggestions? Best Regards Sige |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trimmean for limited array
Hi Domenic, Bernie,
Thanks for your suggestions! Sige |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Vlookup array selection | Excel Worksheet Functions | |||
Return Array with Array | Excel Worksheet Functions | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |