If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 a 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 |
#2
|
|||
|
|||
Linear Trendline
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" wrote in message ... Excel has created a linear trendline with its equations from the following points: X Y 1 4 3 12 6 15 the equations a 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 |
#3
|
|||
|
|||
Linear Trendline
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" wrote in message ... Excel has created a linear trendline with its equations from the following points: X Y 1 4 3 12 6 15 the equations a 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 |
#4
|
|||
|
|||
Linear Trendline
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" wrote in message ... 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" wrote in message ... Excel has created a linear trendline with its equations from the following points: X Y 1 4 3 12 6 15 the equations a 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 |
#5
|
|||
|
|||
Linear Trendline
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" wrote in MM message ... ?? 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. |
#6
|
|||
|
|||
Linear Trendline
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" wrote in message ... 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" wrote in message ... Excel has created a linear trendline with its equations from the following points: X Y 1 4 3 12 6 15 the equations a 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel: Can I force a linear trendline through the origin? | Bill | Charts and Charting | 4 | October 3rd, 2005 12:34 AM |
Trendline Extract | Phil Hageman | Charts and Charting | 5 | July 6th, 2005 02:27 AM |
How do I get the trendline equation from Excel to script? | Mattias | Charts and Charting | 1 | December 7th, 2004 12:21 PM |
Trendline and its referencing / linking to a cell | Jerry W. Lewis | Charts and Charting | 4 | February 4th, 2004 03:13 AM |
trendline equations | kathy | Charts and Charting | 5 | October 2nd, 2003 10:12 PM |