Harmonic Averages
Posted in Automotive, Data analysis, Excel on Jul 4th, 2008 6 Comments »
This is a short note to talk about Harmonic Averages. Most people are familiar with Weighted Averages, as they are a valuable tool for aggregation. For instance, with the data below, the average profitability (~1735) can be easily calculated using weighted averages.
Avg_Profit = (1000*1200 + 200*300 + 500*2500 + 10*600 + 100*300) / [...]
![jcmendez [at] gmail [dot] com](http://jcandkimmita.info/jc/wp-content/themes/jc/img/jcaddr.gif)