What's the relationship between these values?

[gravy834]

Hi,

I need your help to find the relationship in these values. Hopefully this is the right place for it.

So I'm trying to reverse engineer a formula and am stuck at the final hurdle. I'm determined to crack it. I've listed 10 numbers below (column A) and the associated figure that's returned (column B). I can't work out the relationship between these figures to reverse it. I'm looking for a formula so I could enter a random figure e.g. 0.015 to get it's column B figure.

Random Value	Returns
0.01	100.00000000000000
0.02	25.00000000000000
0.03	11.11111111111110
0.04	6.25000000000000
0.05	4.00000000000000
0.06	2.77777777777778
0.07	2.04081632653061
0.08	1.56250000000000
0.09	1.23456790123457
0.10	1.00000000000000

The graph for the above looks like this:

I imagine this doesn't make much sense so please ask for more details if needs be.

Thanks in advance you numerical legends!

 

[Dr.Peterson]

Have you ever seen a graph of a fairly basic function that looks somewhat like this (curved)? What is it?

Once you decide what type of function it might be, you can find an equation of that type and see how well it matches up.

(In general, what you want is impossible; but luckily, this one is pretty simple.)

 

[Deleted member 4993]

Hi,

I need your help to find the relationship in these values. Hopefully this is the right place for it.

So I'm trying to reverse engineer a formula and am stuck at the final hurdle. I'm determined to crack it. I've listed 10 numbers below (column A) and the associated figure that's returned (column B). I can't work out the relationship between these figures to reverse it. I'm looking for a formula so I could enter a random figure e.g. 0.015 to get it's column B figure.

Random Value	Returns
0.01	100.00000000000000
0.02	25.00000000000000
0.03	11.11111111111110
0.04	6.25000000000000
0.05	4.00000000000000
0.06	2.77777777777778
0.07	2.04081632653061
0.08	1.56250000000000
0.09	1.23456790123457
0.10	1.00000000000000

The graph for the above looks like this:

I imagine this doesn't make much sense so please ask for more details if needs be.

Thanks in advance you numerical legends!

If you use MS-Excel (or any other spreadsheet) - you can plot the data and inquire about best fit line (along with associated equation).

 

[Dr.Peterson]

Yes, one of the function types (options) for "trendlines" works. That's more or less what I meant by "pretty simple"; typically that wouldn't happen.