Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
How can I use Excel to solve an equation? titina Excel Worksheet Functions 4 April 11th 06 11:19 PM
memory? Excel Equation Function / Cond. Formatting Dropout nastech Excel Discussion (Misc queries) 2 January 25th 06 04:29 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"