HARMEAN Function - Calculate the Harmonic Mean in Excel

Calculate the harmonic mean in Excel using the HARMEAN function. This function gives less significance to outliers in a range of values. Master more than 100 Excel Formulas - https://goo.gl/QBaF1m Find more great free tutorials at; http://www.computergaga.com The AVERAGE function of Excel calculates the arithmetic mean. It sums the values and then divides them by the count of the values. If there are outliers in the range it can distort the result. The HARMEAN function does not ignore these values, but it gives them less significance producing a result which is a better picture of the values. In this video tutorial there is one value which is much larger than the others. This is represented clearly in a column chart. The AVERAGE and HARMEAN functions are both used to show how different the results can be. Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1