SOLVED

Time series regression on Excel

New Contributor

Is Excel able to do time series analysis? like fix the Autocorrelation, VARs, ARIMA, GARCH, and etc? I can't seem to find the options to do so. Or you have to pay for some add-ins?

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@wirink 

I'm definitely not the right one for this topic, my knowledge is very limited.

Nevertheless, I would like to pass this information on to you, which may help you in your project.

If not, just ignore it.

 

As far as I know, that doesn't mean much :)).
It is possible if paid for it.
Here is an example file from the Internet, that is also included as a file in this message.
Don't know the page, just noticed while looking.

here another one link, to the fast  https://www.tableau.com/de-de/solutions/time-series-analysis

 

All information without guarantee.

 

Thank you for your patience and time.

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE thank you!

Yes you can do time series analysis in Excel. I do not know about ARIMA etc, however, I have custom developed a template that can do a form of time series analysis segmentation automatically. Here is a post I wrote on this forum describing it, and, let me know if this is a technique your are looking to apply: https://techcommunity.microsoft.com/t5/excel/automatically-create-time-series-segments-in-excel/m-p/...