Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Polynomial Trendline
Hello.
I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline there are Polynomial Approximations, Exponential Approximations etc... Which I couldn't find anywhere. Are they available? How can I create the dataset according to Excel approximation? Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least Squares, etc..)? I'm using Office 2007. Thanks. -- Royi Avital |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Polynomial Trendline
Start he
http://spreadsheetpage.com/index.php...line_formulas/ -- Gary''s Student - gsnu200853 "Royi Avital" wrote: Hello. I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline there are Polynomial Approximations, Exponential Approximations etc... Which I couldn't find anywhere. Are they available? How can I create the dataset according to Excel approximation? Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least Squares, etc..)? I'm using Office 2007. Thanks. -- Royi Avital |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Polynomial Trendline
As noted by example in the previous link, pretty much all of the chart
trendlines can be fit via LINEST using either array formulas or tranformation to linearity. A couple of comments are in order, though. For the transformed fit to be optimal, you must assume equal variance (across x values) on the transformed scale, not the original scale. Otherwise either a weighted or nonlinear fit is more appropriate; neither of which is natively available in Excel, though you could "roll you own" if you know what you are doing. Assuming north american regional settings, the polynomial fits shown at the link assume that the x and y values are given in columns. If they are given in rows, then the power separater would be a simicolon instead of a comma. Jerry "Royi Avital" wrote: Hello. I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline there are Polynomial Approximations, Exponential Approximations etc... Which I couldn't find anywhere. Are they available? How can I create the dataset according to Excel approximation? Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least Squares, etc..)? I'm using Office 2007. Thanks. -- Royi Avital |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Polynomial Trendline
Are those "Official" formulas by Microsoft?
I see they didn't let the user get the results as a data set. Thank you very much. -- Royi Avital "Gary''s Student" wrote: Start he http://spreadsheetpage.com/index.php...line_formulas/ -- Gary''s Student - gsnu200853 "Royi Avital" wrote: Hello. I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline there are Polynomial Approximations, Exponential Approximations etc... Which I couldn't find anywhere. Are they available? How can I create the dataset according to Excel approximation? Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least Squares, etc..)? I'm using Office 2007. Thanks. -- Royi Avital |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Polynomial Trendline
I didn't get your remark regarding the variance of the X values.
Thanks. -- Royi Avital "Jerry W. Lewis" wrote: As noted by example in the previous link, pretty much all of the chart trendlines can be fit via LINEST using either array formulas or tranformation to linearity. A couple of comments are in order, though. For the transformed fit to be optimal, you must assume equal variance (across x values) on the transformed scale, not the original scale. Otherwise either a weighted or nonlinear fit is more appropriate; neither of which is natively available in Excel, though you could "roll you own" if you know what you are doing. Assuming north american regional settings, the polynomial fits shown at the link assume that the x and y values are given in columns. If they are given in rows, then the power separater would be a simicolon instead of a comma. Jerry "Royi Avital" wrote: Hello. I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline there are Polynomial Approximations, Exponential Approximations etc... Which I couldn't find anywhere. Are they available? How can I create the dataset according to Excel approximation? Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least Squares, etc..)? I'm using Office 2007. Thanks. -- Royi Avital |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Polynomial Trendline
The formulas may not be "official", but they are supplied by a trusted member
of the user community. There is an additional reference you should examine: http://www.tushar-mehta.com/publish_...nalysis/16.htm -- Gary''s Student - gsnu200853 "Royi Avital" wrote: Are those "Official" formulas by Microsoft? I see they didn't let the user get the results as a data set. Thank you very much. -- Royi Avital "Gary''s Student" wrote: Start he http://spreadsheetpage.com/index.php...line_formulas/ -- Gary''s Student - gsnu200853 "Royi Avital" wrote: Hello. I found the Trendline function in Charts very useful. My question is: Are there equivalent functions? hat I mean, I know about "Trend" and "Linset" functions, yet in Trendline there are Polynomial Approximations, Exponential Approximations etc... Which I couldn't find anywhere. Are they available? How can I create the dataset according to Excel approximation? Are there anymore Approxiamtions / Interpolations in Excel (Splines, Least Squares, etc..)? I'm using Office 2007. Thanks. -- Royi Avital |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Polynomial trendline XL2007 | Excel Discussion (Misc queries) | |||
Polynomial trendline XL2007 | Charts and Charting in Excel | |||
using polynomial trendline equations | Charts and Charting in Excel | |||
polynomial trendline | Excel Worksheet Functions | |||
Polynomial trendline | Excel Worksheet Functions |