While Excel is useful for many applications, it is an indispensable tool for those managing statistics. Two common terms used in statistics are Standard Deviation and ...

The interquartile mean is a measure of central tendency. While all values in a data set are used to calculate the mean, only the interquartile range -- the central portion of a data set -- is used to ...

A trimmed mean is much like a standard mean, which you can derive in Excel using the AVERAGE function. However, instead of using all of the data points to create the mean, a trimmed mean will leave ...

Chris Gallant, CFA, is a senior manager of interest rate risk for ATB Financial with 10 years of experience in the financial markets. Vikki Velasquez is a researcher and writer who has managed, ...

Daniel McNulty began writing for Investopedia in 2012. His work includes articles on financial analysis, asset allocation, and trading strategies. Andy Smith is a Certified Financial Planner (CFP®), ...

How to average with and without the highest and lowest values in Excel Your email has been sent The article How to do more advanced averaging in Excel reviews Microsoft Excel’s many averaging ...