Hello,
Just had a question regarding statistical analysis.
I'm trying to calculate the average of 4 numbers from a data set of 6 numbers in excel without manually choosing to average only the 4 numbers.
e.g.
85 20 32 45 27 3 (total mean = 35.3 desired mean = 31)
100 30 27 40 21 1 (total mean = 21.5 desired mean = 29.5)
....etc
The middle 4 numbers represent a more realistic result whilst the two end numbers are irrelevant.
I've tried looking into weighted averages however I'm unsure how to apply this to an excel sheet.
I'd prefer to find a formula which would discount numbers which vary wildly from the average amount and focus only on the few that don't.
Any help would be greatly appreciated.
