7 Replies Latest reply on Oct 14, 2016 12:06 PM by Shinichiro Murakami

    Weighted Average of Dimensions?

    Rajul Parekh

      Hi All -

       

      I have a few bar charts that I've created based on bins of data. For example, I've bucketed the year companies have been founded into "0-2 years, 3-5 years, 6-9 years, +10 years" to represent age of a company. Now, I need to figure out what the average age of a company is. When I pull in a reference line, it just shows me the average based on the y-axis but i actually need a vertical average that pulls from the bins. I tried writing a few variations of weighted average formulas I saw from other posts but I think the way my data is structured doesn't work with those solutions. Confusing to explain so I've attached a workbook to explain. Looking at the tab labeled "Age", but need similar formula for # Employees and Funding as well!

       

      Thanks so much,

       

      Rajul