help with creating function and figuring out formula
 

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, whe
(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.

help with creating function and figuring out formula
 

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.
--
David Biddulph

"monkeytrader" wrote in message
...
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, whe
(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.

help with creating function and figuring out formula
 

thanks for your help.

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



"David Biddulph" wrote:

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.
--
David Biddulph

"monkeytrader" wrote in message
...
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, whe
(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.

help with creating function and figuring out formula
 

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

"monkeytrader" wrote in message
...
thanks for your help.

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

"David Biddulph" wrote:

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.
--
David Biddulph

"monkeytrader" wrote in message
...
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, whe
(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.