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