Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
curve fitting
I've a monthly data set starting from march 1995 to feb 2005. how could
I fit varios liner and non liner trend lines by SPSS10 and judg which one is the most appropriate statistically? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
curve fitting
somsankarsen -
You posted a message about SPSS in an Excel newsgroup. If you want to use Excel, the Add Trendline feature includes linear and several nonlinear options. If you want to examine seasonality, you could use Excel's Regression tool. For more guidance using Excel, my book, "Data Analysis Using Microsoft Excel: Updated for Office XP," has chapters on simple linear regression, nonlinear regression, multiple regression, and time series seasonality (including seasonal indicators, autoregression, and classical time series decomposition). And, Tushar Mehta's web site has instructions about using Excel for curve fitting at http://www.tushar-mehta.com/excel - Mike www.mikemiddleton.com wrote in message ups.com... I've a monthly data set starting from march 1995 to feb 2005. how could I fit varios liner and non liner trend lines by SPSS10 and judg which one is the most appropriate statistically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improved Excel functions curve fitting in sheet | Excel Worksheet Functions | |||
Curve fitting in Excel | Excel Discussion (Misc queries) | |||
Fitting a curve similar to capacitor charging current. | New Users to Excel | |||
curve fitting a charging capacitor type curve | Excel Discussion (Misc queries) | |||
trend for polynomial curve fitting by regressing | Excel Worksheet Functions |