Time Series Analysis | Time Series Forecasting | Time Series Analysis In Excel | Simplilearn

[@SimplilearnOfficial]

🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Ec320&Comments&KZbin 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Ec320&Comments&KZbin 🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Ec320&Comments&KZbin 🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Ec320&Comments&KZbin 🔥IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitg-generative-ai-data-analytics-program?Ec320&Comments&KZbin

[@reynaremotin2895]

Hi Simplilearn! Thank you for this video. But may I be clarified on how you get the St (average respective quarters) 22:41. I got lost there. Thank you.

[@natashasamuel9346]

Thank You for the Time Series Analysis. Greatly appreciated. Thank You, Natasha

[@SimplilearnOfficial]

You are so welcome!

[@malizganimhango]

I am glad I found the video it is very informative, I got lost when calculating the moving average why did you choose to put the first moving average on the 3rd quarter and

[@devakinadkarni3553]

Amazing video. Best among those I have watched on this topic.

[@SimplilearnOfficial]

Glad it was helpful!

[@JainmiahSk]

Amazing voice, it makes me listen quite interestingly. Of Course the subject is anyway will be good. So good work SimpliLearn

[@SimplilearnOfficial]

Many many thanks

[@md.roquibulalam332]

Good lecture to hear.

[@SimplilearnOfficial]

Glad you liked it

[@dadoll1660]

On the trend part, quite confused of the formula Trend = Intercept + slope * time code. What is your formula for the predicted value(Yp)?

[@kulandaisamynayagar9439]

Well explained/ presented. Thank you for sharing.

[@SimplilearnOfficial]

Glad it was helpful!

[@vasu5471]

Which formula is used in finding St? I'm not getting it by simply average of quarters.

[@SimplilearnOfficial]

Please refer to Excel Quartile Function

[@publicarena1513]

Hi Simplilearn, glad that I found this video. very understandable and well explained. I just wanted to know when calculating the coefficients using regression for trend, I am not getting the same result as in the video. what columns are actually used? I am using Y-original sale and X-de season values . but, getting diff coefficients. Please clarrify.

[@ashisharora4054]

I am facing the same issue

[@uchejames409]

Yeah. Likewise me. Kindly clarify. Thanks.

[@jiwenqiu72]

How did you get the trend and predicted values?

[@germanshepherd6638]

Can we predict lottery numbers with this?!

[@nancyzhou1200]

Thanks!

[@SimplilearnOfficial]

WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!v

[@holdyourpentie1973]

Hi, I really want to ask how can I deal with the data if it only has 3 quarters in the final years. I mean, I have data of 4 years from 2018-2021, but in 2021, I just have 3 quarters data. So, isn't it seasonal data? Can I apply the same method to deal with it? Can you reply me, thk you so muchhhh

[@yaman962]

Is it possible to do the calculation of ARIMA in excel if yes then please share the video on that as it will help more people to learn and understand it with more clearly

[@SimplilearnOfficial]

Hey Yaman, thank you for watching our video. We will definitely look into your suggestions. Do subscribe and stay tuned for updates on our channel. Cheers :)

[@ujjwalchauhan.in.]

Average of quarters is different when i am calculating or my excel and calculator is broken

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@ujjwalchauhan.in.]

@@SimplilearnOfficial It helped alot but can you help me to create a logic ( a single equation) which could be feeded into some software which autocalculates forecast on based of that logic

[@menukawijayarathne886]

good one

[@SimplilearnOfficial]

Thanks for the visit

[@marvinlomo5845]

How did you compute the Seasonal Component of the data please?

[@ektasrivastava6171]

Thanks a lot. It's a very informative video. But I got an error while using "plot(ddata)" function in R. The error is "Error in plotts(x = x, y = y, plot.type = plot.type, xy.labels = xy.labels, : cannot plot more than 10 series as "multiple"".

[@Matheo0518]

24:16 how did you calculate the 2nd St?

[@dadoll1660]

he calculated it based on the St It average per quarter. For example in Q1, there are only 3 since we are missing Q1 for Year 1. average for Q1 = (.96 + .88 + .87) /3