ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is time series analysis available in Excel 2003? (https://www.excelbanter.com/excel-discussion-misc-queries/161419-time-series-analysis-available-excel-2003-a.html)

tquakenbush

Is time series analysis available in Excel 2003?
 
I would like to build a time series model on economic indices. Is time series
analysis available in the toolpak or by some other means?

Thank you in advance for your time and consideration.

Mike Middleton

Is time series analysis available in Excel 2003?
 
tquakenbush -

What happens if you browse to Google and search for "excel time series
analysis" (without the quotes) ?

Excel's Analysis ToolPak has tools for Regression and Moving Average.

Regression and worksheet formulas can be used for time series analysis.

Chapter 20 (Time Series Seasonality) of my book, Data Analysis Using
Microsoft Excel, has three methods for modeling seasonality: regression
using indicator variables, autoregression, and classical time series
decomposition.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"tquakenbush" wrote in message
...
I would like to build a time series model on economic indices. Is time
series
analysis available in the toolpak or by some other means?

Thank you in advance for your time and consideration.




tquakenbush

Is time series analysis available in Excel 2003?
 
Many of the 'hits' lead to websites with add-ins for sale or other types of
software similar to yours. Maybe a bit to ambitious but I was hoping that
Excel already had analysis tools that allowed you to designate the input data
and then model information (e.g. ARIMA(1,1), etc.). Analogous to the
Regression tool that allows you to input the range for the dependant and
independent variable and whether you want to force the regression thru the
origin or not.

It seems that which I'm describing is not already packaged in Excel and that
is why there is a market for this type of add-in. Is your book available as a
download?

"Mike Middleton" wrote:

tquakenbush -

What happens if you browse to Google and search for "excel time series
analysis" (without the quotes) ?

Excel's Analysis ToolPak has tools for Regression and Moving Average.

Regression and worksheet formulas can be used for time series analysis.

Chapter 20 (Time Series Seasonality) of my book, Data Analysis Using
Microsoft Excel, has three methods for modeling seasonality: regression
using indicator variables, autoregression, and classical time series
decomposition.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"tquakenbush" wrote in message
...
I would like to build a time series model on economic indices. Is time
series
analysis available in the toolpak or by some other means?

Thank you in advance for your time and consideration.





Mike Middleton

Is time series analysis available in Excel 2003?
 
tquakenbush -

As far as I know, my book is not available as a download. And, my book does
not cover ARIMA.

- Mike


"tquakenbush" wrote in message
...
Many of the 'hits' lead to websites with add-ins for sale or other types
of
software similar to yours. Maybe a bit to ambitious but I was hoping that
Excel already had analysis tools that allowed you to designate the input
data
and then model information (e.g. ARIMA(1,1), etc.). Analogous to the
Regression tool that allows you to input the range for the dependant and
independent variable and whether you want to force the regression thru the
origin or not.

It seems that which I'm describing is not already packaged in Excel and
that
is why there is a market for this type of add-in. Is your book available
as a
download?

"Mike Middleton" wrote:

tquakenbush -

What happens if you browse to Google and search for "excel time series
analysis" (without the quotes) ?

Excel's Analysis ToolPak has tools for Regression and Moving Average.

Regression and worksheet formulas can be used for time series analysis.

Chapter 20 (Time Series Seasonality) of my book, Data Analysis Using
Microsoft Excel, has three methods for modeling seasonality: regression
using indicator variables, autoregression, and classical time series
decomposition.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"tquakenbush" wrote in message
...
I would like to build a time series model on economic indices. Is time
series
analysis available in the toolpak or by some other means?

Thank you in advance for your time and consideration.








All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com