ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   need to figure out an equation / function (https://www.excelbanter.com/excel-worksheet-functions/130263-need-figure-out-equation-function.html)

monkeytrader

need to figure out an equation / function
 
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 and vise versa).

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



Martin Fishlock

need to figure out an equation / function
 
Try scatter graphs and exponential scales.

Look at the log10 function for a solution although you will have problems at
0,0.

Good luck with your homework.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"monkeytrader" wrote:

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 and vise versa).

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




All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com