Is there something like an "inverse weighted average"?

In my case, I have daily prices and daily units sold of a bunch of products and I would like to give prices with more units higher weights than prices with fewer units. How would I calculate the weights?

  • 1
    $\begingroup$ just weight by num of units $\endgroup$ – Aksakal Jun 13 '18 at 14:18
  • $\begingroup$ sorry I do not understand. I still want to end up with reasonable weighted prices $\endgroup$ – cs0815 Jun 13 '18 at 15:11
  • 1
    $\begingroup$ give an example of data and explain what you want $\endgroup$ – Aksakal Jun 13 '18 at 15:17
  • $\begingroup$ What @Aksakal suggested is mathematically the same thing as market capitalization weighting en.wikipedia.org/wiki/Capitalization-weighted_index , for instance as used in the S&P 500 index. $\endgroup$ – Mark L. Stone Jun 13 '18 at 15:19
  • $\begingroup$ @MarkL.Stone, market cap like weighting would be to weight by a product of units sold and prices, i.e. the sales amount. i think he needs to weight by units sold, not sales amount, but it's not really clear what's his problem $\endgroup$ – Aksakal Jun 13 '18 at 15:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.