If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
To find equation for two sets of non contiguous data
If you want function that relates Q and C, it would appear to be
C = 10*Q or Q = C/10 If you are asking whether those coefficients could be calculated by an Excel function with more general data, then it depends on whether your model can be expressed as a simple straight line using either the original or transformed data; otherwise, no. Assuming that your data are in A1:F2, you could array enter (Ctrl-Shift-Enter) the following formulas =SLOPE(IF(MOD(COLUMN(B1:G2),2)=0,B1:G2),IF(MOD(COL UMN(A1:F2),2)=1,A1:F2)) =INTERCEPT(IF(MOD(COLUMN(B1:G2),2)=0,B1:G2),IF(MOD (COLUMN(A1:F2),2)=1,A1:F2)) If your question is entirely different than the above, then you need to be much more specific about what you are wanting to do. Jerry vijaya wrote: 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 |
#3
|
|||
|
|||
To find equation for two sets of non contiguous data
Jerry neglected to point out that this data arrangement is very
inefficient for the task at hand. A better arrangement would look like this: a b Q C Q C 1 10 4 40 2 20 5 50 3 30 6 60 This way each X range and Y range pairing are in adjacent columns, much easier to write formulas and select ranges. So many difficulties in Excel are eliminated by using a proper data layout. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jerry W. Lewis wrote: If you want function that relates Q and C, it would appear to be C = 10*Q or Q = C/10 If you are asking whether those coefficients could be calculated by an Excel function with more general data, then it depends on whether your model can be expressed as a simple straight line using either the original or transformed data; otherwise, no. Assuming that your data are in A1:F2, you could array enter (Ctrl-Shift-Enter) the following formulas =SLOPE(IF(MOD(COLUMN(B1:G2),2)=0,B1:G2),IF(MOD(COL UMN(A1:F2),2)=1,A1:F2)) =INTERCEPT(IF(MOD(COLUMN(B1:G2),2)=0,B1:G2),IF(MOD (COLUMN(A1:F2),2)=1,A1:F2)) If your question is entirely different than the above, then you need to be much more specific about what you are wanting to do. Jerry vijaya wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 03:54 PM |
Chart w/two different data sets | [email protected] | Charts and Charting | 1 | October 25th, 2004 02:40 AM |