Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I plot an equation in Excel instead of plotting data? | Charts and Charting in Excel | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I create a graph from an equation and not a set of data? | Charts and Charting in Excel |