- Thread Starter
- #1
Time Series Analysis With Ms Excel - Attrition Patterns
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.33 GB | Duration: 2h 1m
Learn to analyse attrition patterns of a company using time series analysis with MS Excel
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.33 GB | Duration: 2h 1m
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
Requirements
Analytical mindset
MS Excel basics
Basic mathematical skills
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
Overview
Section 1: Introduction
Lecture 1 Introduction to Project
Section 2: Data and Formula
Lecture 2 Employee Data
Lecture 3 Formula Part 1
Lecture 4 Formula Part 2
Lecture 5 Formula Part 3
Section 3: Attrition
Lecture 6 Overall Attrition
Lecture 7 Quarter Attrition
Lecture 8 Quarter Attrition Trend Line Chart
Section 4: Moving Average
Lecture 9 Moving Average
Lecture 10 Moving Average Continue
Section 5: Seasonality
Lecture 11 Seasonality Part 1
Lecture 12 Seasonality Part 2
Lecture 13 Seasonality Part 3
Section 6: Forecasting and Model
Lecture 14 Forecasting
Lecture 15 Department
Lecture 16 Level Model
Students,Professionals,anyone who wants to learn time series concepts
Screenshots
Download link
rapidgator.net:
You must reply in thread to view hidden text.
uploadgig.com:
You must reply in thread to view hidden text.
nitroflare.com:
You must reply in thread to view hidden text.
