help with creating function and figuring out formula

[Guest]

i hope someone can help. i am given two sets of data that i want to
graph a positive sloping straight line, but don't know how to set it
up, nor do i know what the equation is to figure out what any other
data point would be on the line.

the x values: the y values:

10 1
20 10 (1*10)
30 100 (10*10)
40 1000 (100*10)
50 10000 (1000*10)
etc... etc...

i need to graph these points so it makes a positive sloping straight
line, where:
(0,0) is the first point, (10,1) is the second point, (20,10) the
third point, (30,100) the next point, etc.

also, i need to know the equation to plot numbers that would fall in
between the points ( i.e.: what would the y value be for x = 27).

sorry, but this seems like a lot of work. i hope someone out there can
help. thanks again in advance.

 

[David Biddulph]

It looks like your formula for Y is 10^((X-10)/10)
Note also that your value for X=0 should presumably be 0.1, not 0.
If you want the graph as a straight line, use a log scale for the Y axis.

 

[Guest]

thanks for your help.

also, what would the formula look like to figure out "x" if y is given?
thanks again.

 

[David Biddulph]

These questions are not really Excel questions, but questions of algebra.
Why not try to work it out for yourself?