Hello,(adsbygoogle = window.adsbygoogle || []).push({});

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

....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.

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Statistics - Standard Deviation, Standard Error and Mean

Loading...

Similar Threads - Statistics Standard Deviation | Date |
---|---|

B The Drunkard's Walk: A Discussion of the Text | Mar 8, 2018 |

I Standard deviation of data after data treatment | Oct 15, 2017 |

Two measurements from different sources - how to combine? | Nov 30, 2014 |

Can the standard deviation calculation be generalized for other statistics? | Feb 1, 2012 |

**Physics Forums - The Fusion of Science and Community**