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