Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of Ratio
I have data arranged like this: -----------Combo1---------Combo2 X-----------18-----------------15 Y-----------0------------------3 Value------5.44---------------7.63 So (18,0)-- 5.44 and (15,3)-- 7.63. Now different values of X and Y affect "Value". So it's two indepent variables affecting the depend variable, "Value". I need to figure out what the exchange rate of X and Y is. In other words, i need the Ratio X=kY where k is a constant of some sort. My first strategy was to generate 2 random pairs of values for (X,Y) that both give the same "Value". Then, i could deduce the ratio. E.g. If (10,0) and (15,10) give the same Value, then the ratio is 5X=10Y or X =2Y. But this has proven difficult because the values are difficult to generate! How could i determine the ratio strictly from the 2 columns above (keeping the Value(s) different)?! Is this possible?! -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=573898 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
EXCEL: FLOOR/SPACE RATIO CALCULATION | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |