Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
memory? Excel Equation Function / Cond. Formatting Dropout | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |