Equation connecting two data quantities

[vijaya]

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

[Bernard Liengme]

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" <vijaya@discussions.microsoft.com> wrote in message
news:7613A0B7-4C48-419D-AD0A-E225846957E5@microsoft.com...
> 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
>
>

[vijaya]

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" <vijaya@discussions.microsoft.com> wrote in message
> news:7613A0B7-4C48-419D-AD0A-E225846957E5@microsoft.com...
> > 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
> >
> >
>
>
>

[Jon Peltier]

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

[Tushar Mehta]

For ways of computing the trendline w/o creating a chart see
Trendline coefficients
http://www.tushar-mehta.com/excel/ti...efficients.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <5141B9DB-FC96-4648-9131-8FE62BBEA58A@microsoft.com>,
vijaya@discussions.microsoft.com says...
>
> 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" <vijaya@discussions.microsoft.com> wrote in message
> > news:7613A0B7-4C48-419D-AD0A-E225846957E5@microsoft.com...
> > > 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
> > >
> > >
> >
> >
> >
>