Time Series Analysis | Time Series Forecasting | Time Series Analysis In Excel | Simplilearn
Vložit
- čas přidán 24. 07. 2024
- 🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-...
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-prof...
🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-anal...
🔥Data Analyst Masters Program (Discount Code - YTBE15): l.linklyhq.com/l/1yhwh
Time Series Analysis is a commonly used machine learning technique for making business predictions. This video on Time Series in Excel will help you understand what time series is and the time series components. You will get an introduction to ARIMA model, how Auto-correlation & partial auto-correlation works, and perform a use case to forecast air-tickets' sales using ARIMA.
⏩ Check out the Data Analytics Playlist: link: bit.ly/2SbDfuY
✅Subscribe to our Channel to learn more about the top Technologies: bit.ly/2VT4WtH
#TimeSeriesAnalysis #TimeSeriesAnalysisInExcel #TimeSeriesForcasting #Simplilearn
➡️ About Post Graduate Program In Data Analytics
This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.
✅ Key Features
- Post Graduate Program certificate and Alumni Association membership
- Exclusive hackathons and Ask me Anything sessions by IBM
- 8X higher live interaction in live online classes by industry experts
- Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc.
- Master Classes delivered by Purdue faculty and IBM experts
- Simplilearn's JobAssist helps you get noticed by top hiring companies
- Resume preparation and LinkedIn profile building
- 1:1 mock interview
- Career accelerator webinars
✅ Skills Covered
- Data Analytics
- Statistical Analysis using Excel
- Data Analysis Python and R
- Data Visualization Tableau and Power BI
- Linear and logistic regression modules
- Clustering using kmeans
- Supervised Learning
🔥Free Business Analytics with Excel Course: www.simplilearn.com/learn-bus...
👉Learn more at: bit.ly/2SECA5r
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
🔥Data Analytics Course for 3-8 Yrs Work Exp: l.linklyhq.com/l/1txBe
🔥Data Analytics Course for 0-3 Yrs Work Exp: l.linklyhq.com/l/1uhmi
🔥Data Analytics Course for 8+ Yrs Work Exp: l.linklyhq.com/l/1uhmj
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.
Thank You for the Time Series Analysis.
Greatly appreciated.
Thank You,
Natasha
You are so welcome!
Amazing video. Best among those I have watched on this topic.
Glad it was helpful!
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
Well explained/ presented. Thank you for sharing.
Glad it was helpful!
On the trend part, quite confused of the formula Trend = Intercept + slope * time code.
What is your formula for the predicted value(Yp)?
Amazing voice, it makes me listen quite interestingly. Of Course the subject is anyway will be good. So good work SimpliLearn
Many many thanks
How did you compute the Seasonal Component of the data please?
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.
I am facing the same issue
Yeah. Likewise me.
Kindly clarify.
Thanks.
How did you get the trend and predicted values?
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
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"".
Which formula is used in finding St? I'm not getting it by simply average of quarters.
Please refer to Excel Quartile Function
Good lecture to hear.
Glad you liked it
Can we predict lottery numbers with this?!
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
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 :)
Thanks!
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
good one
Thanks for the visit
Average of quarters is different when i am calculating or my excel and calculator is broken
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@@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
24:16 how did you calculate the 2nd St?
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