LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
vijaya
 
Posts: n/a
Default To find equation for two sets of non contiguous data

Hi
I have data like this:

Q C Q C Q c Formula (or equation)
a 1 10 2 20 3 30
b 4 40 5 50 6 60

I want a relation like y =m x or y= 3*e 0.2 ., or somethign liek that,
like how we get aan equation when we add a trend line. Is it possible to get
the equation for the above arranged data, and when i drag it to the next row
of data can the equation be updated using some trend formula or something...
IS this possible
 
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
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
"Link to other data source" - How can I find out what is linked? Chicago D Excel Discussion (Misc queries) 2 August 24th 05 08:19 PM
How do I compare data from 2 worksheets to find duplicate entries Jack Excel Discussion (Misc queries) 2 August 16th 05 02:17 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM


All times are GMT +1. The time now is 02:06 PM.

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

About Us

"It's about Microsoft Excel"