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
|
|||
|
|||
Equation connecting two data quantities
Hi,
I have data like this: in an excel sheet. Q C Equation 1 2 3 4 ; 22 44 34 55 88; ? Is there anyway that I can get an equation connecting these two quantities Q and C, (data arranged in this manner only, as I have lot of data where in I cant put that in two separate rows because of some constraints) Can I get a formula connecting these two variables in the quation cell. Thanks |
#2
|
|||
|
|||
Equation connecting two data quantities
Assuming that the data fits a linear plot (and that you have a typo):
read help on SLOPE and INTERCEPT If not linear; find how to draw a trendline; find trendline type that gives best fit then look at www.cpearson.com to see how to use LINEST to get data to cells. Come back if I have been too terse best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "vijaya" wrote in message ... Hi, I have data like this: in an excel sheet. Q C Equation 1 2 3 4 ; 22 44 34 55 88; ? Is there anyway that I can get an equation connecting these two quantities Q and C, (data arranged in this manner only, as I have lot of data where in I cant put that in two separate rows because of some constraints) Can I get a formula connecting these two variables in the quation cell. Thanks |
#3
|
|||
|
|||
Equation connecting two data quantities
The relationship is not linear, I can draw a trendline using charts, add a trendline by right clicking on the data points, and can get the equation that best fits my data. But I have some other purpose of arranging the data like this, and was just wondering is there any way where in that trend equation could be got in the equation cell without going to charts add trendline, then get the best fit equation. I have still lot of data arranged in the above manner wherein I am trying to find some equation and copy paste it to the rest of the cells or something like that ..on which I am still experimenting. Thanks "Bernard Liengme" wrote: Assuming that the data fits a linear plot (and that you have a typo): read help on SLOPE and INTERCEPT If not linear; find how to draw a trendline; find trendline type that gives best fit then look at www.cpearson.com to see how to use LINEST to get data to cells. Come back if I have been too terse best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "vijaya" wrote in message ... Hi, I have data like this: in an excel sheet. Q C Equation 1 2 3 4 ; 22 44 34 55 88; ? Is there anyway that I can get an equation connecting these two quantities Q and C, (data arranged in this manner only, as I have lot of data where in I cant put that in two separate rows because of some constraints) Can I get a formula connecting these two variables in the quation cell. Thanks |
#4
|
|||
|
|||
Equation connecting two data quantities
Bernard -
The problem is that the OP can't/won't rearrange the data to make the work easier. Vijaya - If necessary, use another worksheet to hold the rearranged data. Copy alternate columns, then use Paste Link to paste into the new worksheet, with links to the original data. It does not cost much memory at all, and it will cost less time than struggling with the offsets and other manipulations needed to perform calculations on data which is not optimally arranged. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bernard Liengme wrote: Assuming that the data fits a linear plot (and that you have a typo): read help on SLOPE and INTERCEPT If not linear; find how to draw a trendline; find trendline type that gives best fit then look at www.cpearson.com to see how to use LINEST to get data to cells. Come back if I have been too terse best wishes |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
Data Source issues. ??data.access.pages | Phil | Database Design | 2 | October 11th, 2004 02:42 AM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |