Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring daily average...function ??? | Excel Worksheet Functions | |||
Problem figuring formula | Excel Discussion (Misc queries) | |||
Figuring Out A formula to... | New Users to Excel | |||
I Need help figuring out a sports formula | Excel Discussion (Misc queries) | |||
I need help figuring out this formula in Excel | Excel Discussion (Misc queries) |