Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

how does one calculate value/price with several values but only one price and the values are incomparable between them and have different "weight" on the total value.


product A:

price=100 value of characteristics: x=10; y=100; z=1000;

product B:

price=105 value of characteristics: x=11; y=100; z=1000;

product C:

price=110 value of characteristics: x=12; y=100; z=1000;

And characteristic x is (I.E.) 2 times as important as the other characteristics so an increase of 10% in x doesn't make the total value go up by one third of 10% it would go up by 2 thirds if I'm not mistaken.

how do I calculate the correct value/price for each?

share|cite|improve this question

[Due to your phrasing, I'm not certain of what you're asking for.]

How about

$$ V = \left(\frac {a}{30} + \frac {b}{300} + \frac {c}{3000}\right) \times 100 ?$$

share|cite|improve this answer
no, definitely not x100. 100 is the price so it should be the value divided by price. but I don't know how to calculate the value. sorry for my phrasing. althuogh now I realise the price thing is unimportant I'll edit the question to make it simpler. – Jo Rijo Jan 28 '13 at 5:40

From your now-deleted comment (probably my fault for editing mine — sorry!), it seems that what you're looking for is a function such that increasing any of $x$, $y$, or $z$ by a fixed percentage always increases the value/price $v$ by a corresponding percentage, no matter what the relative magnitudes of $x$, $y$, and $z$. In that case, you can use a function of the form $$v=(x\cdot y\cdot z)^k$$ for some exponent $k$. For example, when $k=1$, increasing any of $x$, $y$, or $z$ by $10\%$ increases the value by the same $10\%$. When $k=\frac13$, if you increase all three of $x$, $y$, and $z$ by $10\%$, the value will increase by $10\%$. It's up to you to choose which $k$ makes sense for your purposes. The examples in your question, where the increase in $v$ is roughly half the increase in $x$, correspond to $k$ of about $\frac12$.

share|cite|improve this answer
thx but your answer would work if all x, y, z have same "weight" on value, by using k=1/3. but I want to be able to calculate at different "weights" or "importance" of x, y, z. IE: x is 2 times as important as y, or z. I'll edit the question again to make it clearer – Jo Rijo Jan 28 '13 at 17:22
forget my last comment (at least for now) the thing is using K=1/3 will give me the total value just like Calvin Lins answer, without the *100; although the *100 is irrelevant, can be to give percentage. but the just dividing that by the price I thought would give me the value/price ratio but as I tried it in the spreadsheet on the real problem I'm trying to solve I run into a inconsistency or flaw. check the my original question if your interested. this seems to me essential to calculate the value of a product with various components yet I haven't managed to find a solution anywhere. – Jo Rijo Jan 28 '13 at 17:58
@Jo Rijo: I'm sorry but asking people to debug your spreadsheet is asking too much. As Amzoti said on your other question, if you can distill the problem into a standalone math question, people would be happy to help. – Rahul Jan 28 '13 at 23:59
If you want different weights, you can do $v=x^i\cdot y^j\cdot z^k$ for different exponents $i$, $j$, and $k$. – Rahul Jan 29 '13 at 0:00
So could I have y and z have a tenth the weight of x by having i=1/3 j=1/30 k=1/30? – Jo Rijo Jan 31 '13 at 2:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.