+x sheilaaellis44 - 5/13/2012 10:00:53 PMStandard Excel will not have the ARIMA calculation. Default excel will not have features beyond regression.But you can add the Add on "NumXL" and get this feature.http://en.wikipedia.org/wiki/NumXL
Here's another site with a wealth of information:
SODA-POP (Pennsylvania State University)http://sodapop.pop.psu.edu/data-collections
Is there an excel function to determine the sample autocorrelations?
[We have posted an Excel template with the approprate functions in the discussion thread for the Time Series student project.]
Hi Everyone,
I had some difficulty finding good data sources, so I am posting the ones I have found. I hope this helps. I also found a free Excel Add-in for calculating ARIMA and Autocorrelation in the last site below.
Time Series Data Library
http://www-personal.buseco.monash.edu.au/~hyndman/TSDL/
University of Dayton - Daily Temperature Archive
http://www.engr.udayton.edu/weather/
Excel Add-in
http://www.web-reg.de/arma_addin.html#
Thanks,
Chris Johnson