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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
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) |