» Excluding Exceptional Values when Calculating an Average
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
List1 (column A) contains 10 numbers, two of which (0 & 500) are significantly smaller or greater than the remainder.
If included in an average calculation, these exceptional values would disproportionately influence the result.
We, therefore, need a way of calculating an average that more accurately reflects the general spread of data.
Solution:
Use the TRIMMEAN function as shown in the following formula:
=TRIMMEAN(A2:A11,0.2)
Book Store:
Recommended Books:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft PowerPoint Version 2002 Step by Step
- Microsoft Outlook 2002 for Dummies
- Microsoft Excel Version 2002 Step by Step
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
