duck908: Can someone help me create a formula with the following input/output table?
input (x)/output (y):
50/1.050
100/1.250
150/1.450
200/1.650
250/1.850
300/2.005
350/2.250
400/2.450
450/2.650
500/2.850
You start by looking at the xs and ys separately.
The xs are going up by 50 every time. The ys are going up by 0.2 every time.
This should be enough to tell you that it is the equation of a line. (The gradient will be the same between each pair of points)
---------------------------------------------------------------------
Once you recognise it as a line you could just use any 2 points and use the line between 2 points formula to get the equation.
That would probably be the most sensible thing to do.
----------------------------------------------------------------------
I usually do it a different way.
Now I am going to talk about a multiplying factor, which is the gradient.
and a number that is tacked on the end, which is the y intercept. (I'm going to call it b)
Since the xs go up by 50 each time, and the ys go up by 0.2 each time
50 * the multiplying factor =0.2
The multiplying factor (gradient) = 0.2 / 50 = 4 * 10
-3 = 0.004
so
y = 0.004x + b
Sub in one of the points say (50, 1.05)
1.05 = 0.004 * 50 + b
1.05 = 0.2 + b
b = 1.05 - 0.2
b = 0.85
so
y = 0.004x + 0.85
This is similar to what admin got only they forgot to divide by 1000
y = 4x/1000 + 850/1000
y= (4x + 850) / 1000
+3146 
+118652 
