Linear Trendline

Excel has created a linear trendline with its equations from the following
points:
X Y
1 4
3 12
6 15

the equations are:
y = 2.1053x + 3.3158
R2 = 0.8681

I wonder if you can tell me how excel create this linear trendline from the
points shown.

Thanks in advance.
Maperalia

Maperalia -

Excel uses "ordinary least squares," i.e., matrix operations that yield
coefficients that minimize the sum of squared deviations.

For the simple linear case, the results are equivalent to the formulas in
Excel's Help for the INTERCEPT and SLOPE worksheet functions.

See Excel's Help for the LINEST function for more details.

For more discussion of numerical accuracy, see
"Description of the LINEST function in Excel 2003 and in Excel 2004 for Mac"
at
support.microsoft.com/kb/828533
and
"Description of improvements in the statistical functions in Excel 2003 and
in Excel 2004 for Mac" at
support.microsoft.com/default.aspx?kbid=828888&product=xl2003

- Mike
www.mikemiddleton.com

"maperalia" <maperalia@discussions.microsoft.com> wrote in message
news:C945651B-EDD8-4E72-8C15-E23513F0CAD1@microsoft.com...
> Excel has created a linear trendline with its equations from the following
> points:
> X Y
> 1 4
> 3 12
> 6 15
>
> the equations are:
> y = 2.1053x + 3.3158
> R2 = 0.8681
>
> I wonder if you can tell me how excel create this linear trendline from
> the
> points shown.
>
> Thanks in advance.
> Maperalia
>

Mike;
Thanks for your quick reponse.
I have read the information you adviced me. This information shows how the
formulas to create a linear trend from this points
However, what I am looking is the formulas where excel takes these point and
adjust them to make a linear trendline.

Wher do you think I can get this information?

Thanks in advance.
Maperalia

"Mike Middleton" wrote:

> Maperalia -
>
> Excel uses "ordinary least squares," i.e., matrix operations that yield
> coefficients that minimize the sum of squared deviations.
>
> For the simple linear case, the results are equivalent to the formulas in
> Excel's Help for the INTERCEPT and SLOPE worksheet functions.
>
> See Excel's Help for the LINEST function for more details.
>
> For more discussion of numerical accuracy, see
> "Description of the LINEST function in Excel 2003 and in Excel 2004 for Mac"
> at
> support.microsoft.com/kb/828533
> and
> "Description of improvements in the statistical functions in Excel 2003 and
> in Excel 2004 for Mac" at
> support.microsoft.com/default.aspx?kbid=828888&product=xl2003
>
> - Mike
> www.mikemiddleton.com
>
> "maperalia" <maperalia@discussions.microsoft.com> wrote in message
> news:C945651B-EDD8-4E72-8C15-E23513F0CAD1@microsoft.com...
> > Excel has created a linear trendline with its equations from the following
> > points:
> > X Y
> > 1 4
> > 3 12
> > 6 15
> >
> > the equations are:
> > y = 2.1053x + 3.3158
> > R2 = 0.8681
> >
> > I wonder if you can tell me how excel create this linear trendline from
> > the
> > points shown.
> >
> > Thanks in advance.
> > Maperalia
> >
>
>
>

Maperalia -

I don't understand what other "formulas" you are looking for.

For example, the XY data is used by the INTERCEPT and SLOPE functions (or by
the chart trendline feature), and the fitted Y values for the line are
determined using =INTERCEPT+SLOPE *X.

What more do you want?

- Mike

"maperalia" <maperalia@discussions.microsoft.com> wrote in message
news:52A494CE-7BE0-4F38-A186-ECAD86E5E76D@microsoft.com...
> Mike;
> Thanks for your quick reponse.
> I have read the information you adviced me. This information shows how the
> formulas to create a linear trend from this points
> However, what I am looking is the formulas where excel takes these point
> and
> adjust them to make a linear trendline.
>
> Wher do you think I can get this information?
>
> Thanks in advance.
> Maperalia
>
> "Mike Middleton" wrote:
>
>> Maperalia -
>>
>> Excel uses "ordinary least squares," i.e., matrix operations that yield
>> coefficients that minimize the sum of squared deviations.
>>
>> For the simple linear case, the results are equivalent to the formulas in
>> Excel's Help for the INTERCEPT and SLOPE worksheet functions.
>>
>> See Excel's Help for the LINEST function for more details.
>>
>> For more discussion of numerical accuracy, see
>> "Description of the LINEST function in Excel 2003 and in Excel 2004 for
>> Mac"
>> at
>> support.microsoft.com/kb/828533
>> and
>> "Description of improvements in the statistical functions in Excel 2003
>> and
>> in Excel 2004 for Mac" at
>> support.microsoft.com/default.aspx?kbid=828888&product=xl2003
>>
>> - Mike
>> www.mikemiddleton.com
>>
>> "maperalia" <maperalia@discussions.microsoft.com> wrote in message
>> news:C945651B-EDD8-4E72-8C15-E23513F0CAD1@microsoft.com...
>> > Excel has created a linear trendline with its equations from the
>> > following
>> > points:
>> > X Y
>> > 1 4
>> > 3 12
>> > 6 15
>> >
>> > the equations are:
>> > y = 2.1053x + 3.3158
>> > R2 = 0.8681
>> >
>> > I wonder if you can tell me how excel create this linear trendline from
>> > the
>> > points shown.
>> >
>> > Thanks in advance.
>> > Maperalia
>> >
>>
>>
>>

Mike wrote on Thu, 4 May 2006 10:40:00 -0700:

MM> I don't understand what other "formulas" you are looking
MM> for.

MM> For example, the XY data is used by the INTERCEPT and SLOPE
MM> functions (or by the chart trendline feature), and the
MM> fitted Y values for the line are determined using
MM> =INTERCEPT+SLOPE *X.

MM> What more do you want?

MM> - Mike

MM> "maperalia" <maperalia@discussions.microsoft.com> wrote in
MM> message
news:52A494CE-7BE0-4F38-A186-ECAD86E5E76D@microsoft.com...
??>> Mike;
??>> Thanks for your quick reponse.
??>> I have read the information you adviced me. This
??>> information shows how the formulas to create a linear
??>> trend from this points However, what I am looking is the
??>> formulas where excel takes these point and adjust them to
??>> make a linear trendline.
??>> ??>> Wher do you think I can get this information?

I woder if the OP wants the actual details of calculating the
slope and intercept? The equations are given in HELP, AFAIK.

James Silverton.

Mike;
Thanks you very much. I really appreciatte your supporting in this matter.

Kind regards.
Maperalia

"Mike Middleton" wrote:

> Maperalia -
>
> I don't understand what other "formulas" you are looking for.
>
> For example, the XY data is used by the INTERCEPT and SLOPE functions (or by
> the chart trendline feature), and the fitted Y values for the line are
> determined using =INTERCEPT+SLOPE *X.
>
> What more do you want?
>
> - Mike
>
> "maperalia" <maperalia@discussions.microsoft.com> wrote in message
> news:52A494CE-7BE0-4F38-A186-ECAD86E5E76D@microsoft.com...
> > Mike;
> > Thanks for your quick reponse.
> > I have read the information you adviced me. This information shows how the
> > formulas to create a linear trend from this points
> > However, what I am looking is the formulas where excel takes these point
> > and
> > adjust them to make a linear trendline.
> >
> > Wher do you think I can get this information?
> >
> > Thanks in advance.
> > Maperalia
> >
> > "Mike Middleton" wrote:
> >
> >> Maperalia -
> >>
> >> Excel uses "ordinary least squares," i.e., matrix operations that yield
> >> coefficients that minimize the sum of squared deviations.
> >>
> >> For the simple linear case, the results are equivalent to the formulas in
> >> Excel's Help for the INTERCEPT and SLOPE worksheet functions.
> >>
> >> See Excel's Help for the LINEST function for more details.
> >>
> >> For more discussion of numerical accuracy, see
> >> "Description of the LINEST function in Excel 2003 and in Excel 2004 for
> >> Mac"
> >> at
> >> support.microsoft.com/kb/828533
> >> and
> >> "Description of improvements in the statistical functions in Excel 2003
> >> and
> >> in Excel 2004 for Mac" at
> >> support.microsoft.com/default.aspx?kbid=828888&product=xl2003
> >>
> >> - Mike
> >> www.mikemiddleton.com
> >>
> >> "maperalia" <maperalia@discussions.microsoft.com> wrote in message
> >> news:C945651B-EDD8-4E72-8C15-E23513F0CAD1@microsoft.com...
> >> > Excel has created a linear trendline with its equations from the
> >> > following
> >> > points:
> >> > X Y
> >> > 1 4
> >> > 3 12
> >> > 6 15
> >> >
> >> > the equations are:
> >> > y = 2.1053x + 3.3158
> >> > R2 = 0.8681
> >> >
> >> > I wonder if you can tell me how excel create this linear trendline from
> >> > the
> >> > points shown.
> >> >
> >> > Thanks in advance.
> >> > Maperalia
> >> >
> >>
> >>
> >>
>
>
>