Making Numerical Predictions for Time Series Data: Part 1 of 3

Learn how to use Microsoft Excel to make numerical predictions on time series data.

Making Numerical Predictions for Time Series Data: Part 1 of 3

Learn how to use Microsoft Excel to make numerical predictions on time series data.
144
views
Share the link to this page
Copied

About the Class

Predictive analytics is the branch of advanced analytics, which is used to make predictions about unknown future events. Predictive analytics uses many techniques from data mining, statistics, modeling, machine learning, and artificial intelligence to analyze current data to make predictions about the future.

One class of Predictive Analytics is to make a prediction on time series data. Studying historical data, collected over a period of time, can help in building models using which the future can be predicted. For example, from historical data on temperatures in a city, we can make decent predictions of what the temperature could be in a future date. Or for that matter, from data collected over a reasonably long period of time regarding various lifestyle aspects of a Diabetic patient, we can predict what should be the volume of Insulin to inject on a given date in the future. One example to consider from the Business world could be to predict the Volume of In-Roamers in a telecom network in any given period of time in the future from the historical details of In-Roamers in the network.

The applications are just innumerable as these are applicable in every sphere of business and life.

In this course, we go through various aspects of building Predictive Analytics Models. We start with simple techniques and gradually study very advanced and contemporary techniques. We cover using Descriptive Statistics, Moving Averages, Regression, Machine Learning, and Neural Networks.

This course is a series of 3 parts.

  • In Part 1, we use Microsoft Excel to make Numerical Predictions from Time Series Data.

We start by using Microsoft Excel for 2 reasons.

  1. Excel is easy to use and thus we can understand complex concepts through exercises that are easy to replicate and thus become easy to understand.
  2. Excel is expected to be available with everyone taking this course.
  • In Part 2, we use R Programming to make Numerical Predictions from Time Series Data.
  • In Part 3, we use Python Programming to make Numerical Predictions from Time Series Data.

The course uses simple data sets to explain the concepts and theory aspects. As we go through the various techniques, we compare the various techniques. We also understand the circumstances where a particular technique should be applied. We will also use some publicly available data sets to apply the techniques that we will discuss in the course.

Author

Partha Majumdar

Just a Programmer
Partha started his career in 1989 as a programmer. In his first assignment, he was involved in development of a Cricket Tournament management system as a part of the team from Centre for Development of Telematics (C-DOT) requested by the Prime Minister of India, Mr. Rajiv Gandhi. Since then Partha has developed Tea Garden automation solution,...

School

Partha Majumdar's School

Requirements

  • You should have a basic knowledge of Statistics.
  • You should have a basic knowledge of Algebra.
  • You should have a basic knowledge of Logarithm.
  • You should have a basic knowledge of Microsoft Excel.

Class Contents

One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.93
List Price:  €92.76
You save:  €27.83
£53.99
List Price:  £77.13
You save:  £23.14
CA$97.22
List Price:  CA$138.90
You save:  CA$41.67
A$105.43
List Price:  A$150.62
You save:  A$45.19
S$92.47
List Price:  S$132.11
You save:  S$39.63
HK$544.12
List Price:  HK$777.35
You save:  HK$233.22
CHF 60.91
List Price:  CHF 87.02
You save:  CHF 26.11
NOK kr763.93
List Price:  NOK kr1,091.38
You save:  NOK kr327.44
DKK kr484.20
List Price:  DKK kr691.75
You save:  DKK kr207.54
NZ$116.54
List Price:  NZ$166.49
You save:  NZ$49.95
د.إ257.07
List Price:  د.إ367.25
You save:  د.إ110.18
৳8,342.01
List Price:  ৳11,917.67
You save:  ৳3,575.65
₹5,905.60
List Price:  ₹8,436.93
You save:  ₹2,531.33
RM306.80
List Price:  RM438.30
You save:  RM131.50
₦117,690.28
List Price:  ₦168,136.18
You save:  ₦50,445.90
₨19,401.12
List Price:  ₨27,717.08
You save:  ₨8,315.95
฿2,383.57
List Price:  ฿3,405.25
You save:  ฿1,021.68
₺2,404.89
List Price:  ₺3,435.70
You save:  ₺1,030.81
B$398.48
List Price:  B$569.28
You save:  B$170.80
R1,224.40
List Price:  R1,749.21
You save:  R524.81
Лв126.98
List Price:  Лв181.41
You save:  Лв54.43
₩97,065.96
List Price:  ₩138,671.61
You save:  ₩41,605.64
₪260.93
List Price:  ₪372.77
You save:  ₪111.84
₱4,079.82
List Price:  ₱5,828.56
You save:  ₱1,748.74
¥10,651.14
List Price:  ¥15,216.57
You save:  ¥4,565.43
MX$1,389.48
List Price:  MX$1,985.06
You save:  MX$595.57
QR254.42
List Price:  QR363.48
You save:  QR109.05
P932.03
List Price:  P1,331.53
You save:  P399.50
KSh9,028.71
List Price:  KSh12,898.71
You save:  KSh3,870
E£3,450.40
List Price:  E£4,929.36
You save:  E£1,478.95
ብር8,593.22
List Price:  ብር12,276.56
You save:  ብር3,683.33
Kz63,785.40
List Price:  Kz91,125.91
You save:  Kz27,340.50
CLP$67,067.21
List Price:  CLP$95,814.41
You save:  CLP$28,747.20
CN¥501.07
List Price:  CN¥715.84
You save:  CN¥214.77
RD$4,196.59
List Price:  RD$5,995.39
You save:  RD$1,798.79
DA9,345.90
List Price:  DA13,351.85
You save:  DA4,005.95
FJ$158.38
List Price:  FJ$226.27
You save:  FJ$67.89
Q539.99
List Price:  Q771.44
You save:  Q231.45
GY$14,604.65
List Price:  GY$20,864.69
You save:  GY$6,260.03
ISK kr9,655.82
List Price:  ISK kr13,794.62
You save:  ISK kr4,138.80
DH690.36
List Price:  DH986.28
You save:  DH295.91
L1,255.31
List Price:  L1,793.39
You save:  L538.07
ден3,995.33
List Price:  ден5,707.86
You save:  ден1,712.53
MOP$560.14
List Price:  MOP$800.23
You save:  MOP$240.09
N$1,220.30
List Price:  N$1,743.36
You save:  N$523.06
C$2,568.69
List Price:  C$3,669.72
You save:  C$1,101.02
रु9,424.24
List Price:  रु13,463.77
You save:  रु4,039.53
S/263.85
List Price:  S/376.95
You save:  S/113.09
K280.16
List Price:  K400.24
You save:  K120.08
SAR262.89
List Price:  SAR375.57
You save:  SAR112.68
ZK1,891.77
List Price:  ZK2,702.65
You save:  ZK810.87
L323.06
List Price:  L461.54
You save:  L138.47
Kč1,638.32
List Price:  Kč2,340.56
You save:  Kč702.23
Ft26,373.60
List Price:  Ft37,678.19
You save:  Ft11,304.58
SEK kr750.79
List Price:  SEK kr1,072.60
You save:  SEK kr321.81
ARS$69,550.94
List Price:  ARS$99,362.75
You save:  ARS$29,811.80
Bs484.09
List Price:  Bs691.59
You save:  Bs207.49
COP$308,434.77
List Price:  COP$440,639.99
You save:  COP$132,205.21
₡35,749.40
List Price:  ₡51,072.77
You save:  ₡15,323.36
L1,761.10
List Price:  L2,515.97
You save:  L754.86
₲541,831.22
List Price:  ₲774,077.78
You save:  ₲232,246.56
$U2,924.58
List Price:  $U4,178.15
You save:  $U1,253.57
zł280.93
List Price:  zł401.35
You save:  zł120.41

What's Included

Language: English
Level: All levels
Skills: Data Analysis Toolkit, Data Analysis, Microsoft Excel, Analytics, Regression, Predictive Analytics
Age groups: 18-65 years
Duration: 6 hours 11 minutes
36 Videos
21 Documents
0
Saves
144
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.