Time Series Analysis - 1 | Time Series in Excel | Time Series Forecasting | Data Science|Simplilearn

This Time Series Analysis (Part-1) tutorial will help you understand what is time series, why time series, components of time series, when not to use time series, why does a time series have to be stationary, how to make a time series stationary and at the end, you will also see a use case where we will forecast car sales for 5th year using the given data.

A time series is a sequence of data being recorded at specific time intervals. The past values are analyzed to forecast a future which is time-dependent. Compared to other forecast algorithms, with time series we deal with a single variable which is dependent on time. So, lets deep dive into this video and understand what is time series and how to implement time series using R.

Below topics are explained in this Time Series in R Tutorial -

1. Why time series?
2. What is time series?
3. Components of a time series
4. When not to use time series?
5. Why does a time series have to be stationary?
6. How to make a time series stationary?
7. Example: Forecast car sales for the 5th year

#DataScienceWithPython #DataScienceWithR #DataScienceCourse #DataScience #DataScientist #BusinessAnalytics #MachineLearning

➡️ 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

🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - [phone]

[SimplilearnOfficial]

Machine Learning is the Future and yours can begin today. Comment below with you email to get our latest Machine Learning Career Guide. Let your journey begin.


Do you have any questions on this topic? Please share your feedback in the comment section below and we'll have our experts answer it for you.

Thanks for watching the video. Cheers!

[yunus]

Hi, I believe the input range for regression is taken wrong. Check at 28:28. You need to consider time (t value from column A) on X axis and De-seasonlise sales in Y axis. Taking Yt in X axis will not give you the result.

[panzabamboo]

Thank you! I had to rewatch a few times but I understood this better than what I learned in class!

[srinivasanbalan]

Hi, thanks for the video. Some of the explanations are not clear. Please clarify. In column H, we need to calculate the avg of Q values for each period. I understand 0.9 is the avg of (G7, G11, G15). Then, how did you get values from H17 to H22? since all the values are zero from G17 to G22, it is not clear in terms of value calculations. Could you also give us the physical meaning of why this process is conducted? what is the significance?

[sojibulislam]

Alhamdulillah... that is very interesting and informative video. Thank u

[sojibulislam]

I love the Simplilearn videos. You make everything look so easy. Keep it up! Thanks

[AlexBorgesBBorg]

So very nice to see a real take-on of the real problem behind forecasting

[pratigyabaranwal]

This is really very helpful tutorial for a beginner.
Thank you sir!!

[MrStephen]

I'm only 9 minutes into this video & I like your approach and explanation.

[pavkalinowski]

Which value do you use for the x variable in the regression, and how much did you differ for decimals? I repeated this without reducing the decimals and got a very different regression slope

[gowthamchowdrylatentview]

how do you take for average of respective quarter (timing 22.03mins)?

[apekshakapoor]

Nice explanation. Waiting for part 2..

[kevaltiwari]

Very nicely Explained, but next time on wards, let the excel formulas in the individual cells be there. Do not copy and paste as values for the sake of the video. It would be much better. I and a few other guys who have commented here did not understand the important part of calculating St. Would have been good if we had seen the formulas in the individual cells. Thanks.

[bashiradelodun]

Thank you for the video. Can you please explain how you got the values of St? The average of first quarter can't give us 0.90. Thank you

[The_Pakistan_Perspective]

Great video! Could not understand the calculation behind column St (24:28) though.

[UpendraSingh-pcct]

This is really very helpful tutorial for a beginner.

[Vanessa_]

Great video for beginners like me! How did you calculate the Predicted value Yp?

[uzammohammed]

Thank you sir nice explanation... I have one doubt, what if the data we have is two time series??

[arjunbhasin]

Hi, Good Tutorial.
I did not get the St calculation part. I read comments but still it is not clear. Why you are taking G column in to consideration for calculating the St?
Would be thankful if you explain St part of it.

[yeshwanthbuggaveeti]

How you calculated st, st is same like ma; average means what we should take for st