Time Series Analysis with MS Excel - Attrition Patterns

Focused View

EDUCBA Bridging the Gap

2:02:30

33 View

1 - Introduction

1 - Introduction to Project.mp4

05:11

2 - Data and Formula

2 - Employee Data.mp4

05:02

3 - Formula Part 1.mp4

08:09

4 - Formula Part 2.mp4

06:55

5 - Formula Part 3.mp4

05:30

3 - Attrition

6 - Overall Attrition.mp4

08:22

7 - Quarter Attrition.mp4

12:04

8 - Quarter Attrition Trend Line Chart.mp4

11:30

4 - Moving Average

9 - Moving Average.mp4

04:28

10 - Moving Average Continue.mp4

07:59

5 - Seasonality

11 - Seasonality Part 1.mp4

06:31

12 - Seasonality Part 2.mp4

04:29

13 - Seasonality Part 3.mp4

05:45

6 - Forecasting and Model

14 - Forecasting.mp4

13:00

15 - Department.mp4

07:39

16 - Level Model.mp4

09:56

Description

Learn to analyse attrition patterns of a company using time series analysis with MS Excel

What You'll Learn?

Get hands-on exposure to time series analysis using MS Excel
Implement applications of time series analysis in real life scenario
Learn basic excel formulas and visualization
Learn time series concept

Who is this for?

Students

Professionals

anyone who wants to learn time series concepts

What You Need to Know?

Analytical mindset

MS Excel basics

Basic mathematical skills

More details

Description
Time series data collected over different points in time breach the assumption of the conventional statistical model as correlation exists between the adjacent data points. This characteristic of the time series data breaches is one of the major assumptions that the adjacent data points are independent and identically distributed. This gives rise to the need of a systematic approach to study the time series data which can help us answer the statistical and mathematical questions that come into the picture due to the time correlation that exists.
Time series analysis holds a wide range of applications is it statistics, economics, geography, bioinformatics, neuroscience. The common link between all of them is to come up with a sophisticated technique that can be used to model data over a given period of time where the neighboring information is dependent.
In time series, Time is the independent variable and the goal is forecasting.
Time series analysis is a statistical method to analyse the past data within a given duration of time to forecast the future. It comprises of ordered sequence of data at equally spaced interval. To understand the time series data & the analysis let us consider an example. Consider an example of Airline Passenger data. It has the count of passenger over a period of time.
Ample of time series data is being generated from a variety of fields. And hence the study time series analysis holds a lot of applications. Let us try to understand the importance of time series analysis in different areas.
Field of Economics: Budget studies, census Analysis, etc.
Field of Finance: Widely used in the field of finance such as to understand the stock market fluctuations, yield management, understand the market volatility, etc.
Social ScientistÃ : Birth rates or death rates over a period of time and can come with the schemes in their interest.
Healthcare: An epidemiologist might be interested in knowing the number of people infected over the past years. Like in the current situation the researchers might be interested in knowing the people affected by the coronavirus over a period of time. Blood pressure traced over a period of time can be used in evaluating a drug.
Environmental Science: Environmental time series data can help us explain the rise in temperature over the past few years. Plot shows the temperature data over a period of time

Who this course is for:
Students
Professionals
anyone who wants to learn time series concepts

User Reviews

Rating

average 0

Total votes0

Focused display

EDUCBA is a leading global provider of skill based education addressing the needs of 1,000,000+ members across 70+ Countries. Our unique step-by-step, online learning model along with amazing 5000+ courses and 500+ Learning Paths prepared by top-notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At EDUCBA, it is a matter of pride for us to make job oriented hands-on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.