6 reputation
2
bio website
location
age
visits member for 1 years, 2 months
seen Feb 15 '13 at 21:56

Jan
31
comment calculate value/price with multiple uncomparable values
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?
Jan
31
revised calculate value/price with multiple uncomparable values
added 55 characters in body
Jan
28
revised calculate value/price with multiple uncomparable values
deleted 208 characters in body
Jan
28
comment calculate value/price with multiple uncomparable values
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.
Jan
28
revised calculate value/price with multiple uncomparable values
added 129 characters in body
Jan
28
revised calculate value/price with multiple uncomparable values
added 63 characters in body
Jan
28
comment calculate value/price with multiple uncomparable values
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
Jan
28
revised calculate value/price with multiple uncomparable values
edited title
Jan
28
revised calculate value/price with multiple uncomparable values
deleted 74 characters in body
Jan
28
revised calculate value/price with multiple uncomparable values
deleted 35 characters in body; edited title
Jan
28
awarded  Student
Jan
28
comment calculate value/price with multiple uncomparable values
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.
Jan
28
asked calculate value/price with multiple uncomparable values
Jan
28
awarded  Editor