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