SOLVED

Time series regression on Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2593686%22%20slang%3D%22en-US%22%3ETime%20series%20regression%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593686%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20Excel%20able%20to%20do%20time%20series%20analysis%3F%20like%20fix%20the%20Autocorrelation%2C%20VARs%2C%20ARIMA%2C%20GARCH%2C%20and%20etc%3F%20I%20can't%20seem%20to%20find%20the%20options%20to%20do%20so.%20Or%20you%20have%20to%20pay%20for%20some%20add-ins%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2593686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2593753%22%20slang%3D%22de-DE%22%3ESubject%3A%20Time%20series%20regression%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593753%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1114425%22%20target%3D%22_blank%22%3E%40wirink%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20definitely%20not%20the%20right%20one%20for%20this%20topic%2C%20my%20knowledge%20is%20very%20limited.%3C%2FP%3E%3CP%3ENevertheless%2C%20I%20would%20like%20to%20pass%20this%20information%20on%20to%20you%2C%20which%20may%20help%20you%20in%20your%20project.%3C%2FP%3E%3CP%3EIf%20not%2C%20just%20ignore%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20know%2C%20that%20doesn't%20mean%20much%20%3A)).%3CBR%20%2F%3EIt%20is%20possible%20if%20paid%20for%20it.%3CBR%20%2F%3EHere%20is%20an%20%3CA%20href%3D%22https%3A%2F%2Fhelp.xlstat.com%2Fs%2Farticle%2Fstationre-zeitreihen-in-excel---anleitung%3Flanguage%3Dde%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eexample%20file%3C%2FA%3E%20from%20the%20Internet%2C%20that%20is%20also%20included%20as%20a%20file%20in%20this%20message.%3CBR%20%2F%3EDon't%20know%20the%20page%2C%20just%20noticed%20while%20looking.%3C%2FP%3E%3CP%3Ehere%20another%20one%20link%2C%20to%20the%20fast%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%20%3CA%20href%3D%22https%3A%2F%2Fwww.tableau.com%2Fde-de%2Fsolutions%2Ftime-series-analysis%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tableau.com%2Fde-de%2Fsolutions%2Ftime-series-analysis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20information%20without%20guarantee.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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/...