Okay so, last time I had a math fail I came here and asked and was given an answer and told that excel solver was likely used to solve it. But I cant for the life of me figure it out and I'm too tired to really spend 3 hours trying for something this simple. I need a formula to get these numbers can anyone please help me out real quick with this?
Okay so, last time I had a math fail I came here and asked and was given an answer and told that excel solver was likely used to solve it. But I cant for the life of me figure it out and I'm too tired to really spend 3 hours trying for something this simple. I need a formula to get these numbers can anyone please help me out real quick with this?
Edit: fixed numbers.
Edit2: I know its going to be something like =20-(input*x) or something :X
Edit3: the origin of the output numbers is val = prev val - prev val * 0.03 but i only show every 10 vals here.
edit4: I HATE MATH! But it seems as though the formula starts with 20-(input*.6) but by input of 100 the .6 is .1904895
http://en.wikipedia.org/wiki/Lagrange_polynomial
l1(x) = (x - 10) · (x - 20) · (x - 30) · (x - 40) · (x - 50) · (x - 60) · (x - 70) · (x - 80) · (x - 90) · (x - 100)
l1(0) = -10 - 20 - 30 - 40 - 50 - 60 - 70 - 80 - 90 - 100 = -550
L1(x) = -20/550 · (x - 10) · (x - 20) · (x - 30) · (x - 40) · (x - 50) · (x - 60) · (x - 70) · (x - 80) · (x - 90) · (x - 100)
l2(x) = x · (x - 20) · (x - 30) · (x - 40) · (x - 50) · (x - 60) · (x - 70) · (x - 80) · (x - 90) · (x - 100)
l2(10) = 10 - 10 - 20 - 30 - 40 - 50 - 60 - 70 - 80 - 90 = -440
L2(x) = -14.75/440 · x · (x - 20) · (x - 30) · (x - 40) · (x - 50) · (x - 60) · (x - 70) · (x - 80) · (x - 90) · (x - 100)
l3(x) = x · (x - 10) · (x - 30) · (x - 40) · (x - 50) · (x - 60) · (x - 70) · (x - 80) · (x - 90) · (x - 100)
l3(20) = 20 + 10 - 10 - 20 - 30 - 40 - 50 - 60 - 70 - 80 = -330
L3(x) = -10.88/330 · x · (x - 10) · (x - 30) · (x - 40) · (x - 50) · (x - 60) · (x - 70) · (x - 80) · (x - 90) · (x - 100)
...
P(x) = sum(Li(x))
@Sneakervek: Go
Not sure if I got this right but I came up with this formula:
T is your input. O is your output.
O = 20*0.97^T
Is that what you wanted?
@Moooyaah: Go
Exactly what I wanted thank you.