J
john palmer
I have 30 data items in an excel spreadsheet. Is it possible to get the best
fit line for say items 2 to 13 and 15 to 25 separately?
fit line for say items 2 to 13 and 15 to 25 separately?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joseph Meehan
I have little idea of what you want. Could you explain it in a little
more detail and maybe show an example? What are you fitting to what?
more detail and maybe show an example? What are you fitting to what?
J
john palmer
I have a test graph but do not know how to send it it. Basically it shows
that If I draw a straight trendline through the first half of the data and a
second trendline through the second half of the data then the two lines are
different, suggesting that there are in fact two separate data sets. What I
would like to do is for excel to draw these lines for me.
John Palmer
that If I draw a straight trendline through the first half of the data and a
second trendline through the second half of the data then the two lines are
different, suggesting that there are in fact two separate data sets. What I
would like to do is for excel to draw these lines for me.
John Palmer
J
JoAnn Paules
Are they charts in Excel?
J
john palmer
Yes. In excel 2003
John Palmer
John Palmer
JoAnn Paules said:Are they charts in Excel?
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
john palmer said:I have a test graph but do not know how to send it it. Basically it shows
that If I draw a straight trendline through the first half of the data and
a
second trendline through the second half of the data then the two lines
are
different, suggesting that there are in fact two separate data sets. What
I
would like to do is for excel to draw these lines for me.
John Palmer
H
Harlan Grove
john palmer said:I have 30 data items in an excel spreadsheet. Is it possible to get the best
fit line for say items 2 to 13 and 15 to 25 separately?
You'd be much better off asking Excel-specific questions in Excel-
specific newsgroups rather than this one.
If your X values are in, say, A2:A31 and your Y values in B2:B31, you
could select A2:A13, run the menu command Insert > Chart, choose an XY
scatter plot, then add a second series with X range A15:A25 and Y
range B15:B25. Then choose the appropriate 'trend line'. Excel will
fit trend lines to each series separately.