Time Series Analysis | Time Series Forecasting | Time Series Analysis In Excel | Simplilearn
92,912
Published 2020-09-20
š„IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-professional-certificate-ā¦
š„Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-analytics-bootcamp?utm_caā¦
š„Data Analyst Masters Program (Discount Code - YTBE15): www.simplilearn.com/data-analyst-masters-certificaā¦
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-business-analytics-excelā¦
šLearn more at: bit.ly/2SECA5r
š„š„ Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +184
All Comments (21)
-
š„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
-
Amazing video. Best among those I have watched on this topic.
-
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.
-
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
-
Good lecture to hear.
-
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.
-
How did you compute the Seasonal Component of the data please?
-
How did you get the trend and predicted values?
-
Can we predict lottery numbers with this?!
-
Which formula is used in finding St? I'm not getting it by simply average of quarters.
-
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"".
-
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 <333
-
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
-
good one
-
24:16 how did you calculate the 2nd St?
-
Thanks!