Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




Function: Ignore Mimimum and Maximum Values
Is there a spreadsheet function to calculate the average, ignoring a single
minimum and maximum value. This is similar to what they use in the olympics to calculate a score. Example: for this list: A1: 10 A2: 10 A3: 8 A4: 7 A5: 6 A6: 6 A7: 6 I would need to average only cells A2 through A6, ignoring a single max and min value. The list is normally not sorted and the the number of values is not constant. Is there a statistical calulcation to do this? 
#2
Posted to microsoft.public.excel.worksheet.functions




Function: Ignore Mimimum and Maximum Values
=(SUM(range)MAX(range)MIN(range))/(COUNT(range)2)
"Michael J" wrote: Is there a spreadsheet function to calculate the average, ignoring a single minimum and maximum value. This is similar to what they use in the olympics to calculate a score. Example: for this list: A1: 10 A2: 10 A3: 8 A4: 7 A5: 6 A6: 6 A7: 6 I would need to average only cells A2 through A6, ignoring a single max and min value. The list is normally not sorted and the the number of values is not constant. Is there a statistical calulcation to do this? 
#3
Posted to microsoft.public.excel.worksheet.functions




Function: Ignore Mimimum and Maximum Values
One way:
=TRIMMEAN(A1:A7, 2/7)) For more or fewer numbers, this can be generalized as =TRIMMEAN(A:A,2/COUNT(A:A)) In article , Michael J <Michael wrote: Is there a spreadsheet function to calculate the average, ignoring a single minimum and maximum value. This is similar to what they use in the olympics to calculate a score. Example: for this list: A1: 10 A2: 10 A3: 8 A4: 7 A5: 6 A6: 6 A7: 6 I would need to average only cells A2 through A6, ignoring a single max and min value. The list is normally not sorted and the the number of values is not constant. Is there a statistical calulcation to do this? 
#4
Posted to microsoft.public.excel.worksheet.functions




Function: Ignore Mimimum and Maximum Values
Thanks JE. Your general works fine.
 "JE McGimpsey" wrote: One way: =TRIMMEAN(A1:A7, 2/7)) For more or fewer numbers, this can be generalized as =TRIMMEAN(A:A,2/COUNT(A:A)) In article , Michael J <Michael wrote: Is there a spreadsheet function to calculate the average, ignoring a single minimum and maximum value. This is similar to what they use in the olympics to calculate a score. Example: for this list: A1: 10 A2: 10 A3: 8 A4: 7 A5: 6 A6: 6 A7: 6 I would need to average only cells A2 through A6, ignoring a single max and min value. The list is normally not sorted and the the number of values is not constant. Is there a statistical calulcation to do this? 
#5
Posted to microsoft.public.excel.worksheet.functions




Function: Ignore Mimimum and Maximum Values
Thanks Duke. That does the trick.
 "Duke Carey" wrote: =(SUM(range)MAX(range)MIN(range))/(COUNT(range)2) "Michael J" wrote: Is there a spreadsheet function to calculate the average, ignoring a single minimum and maximum value. This is similar to what they use in the olympics to calculate a score. Example: for this list: A1: 10 A2: 10 A3: 8 A4: 7 A5: 6 A6: 6 A7: 6 I would need to average only cells A2 through A6, ignoring a single max and min value. The list is normally not sorted and the the number of values is not constant. Is there a statistical calulcation to do this? 
Reply 
Thread Tools  Search this Thread 
Display Modes  

