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

Welcome to the Course

Course Trailer

Preview

Introduction

A look at Time Series Data

Preview

Moving Averages

Predicting using Descriptive Statistics

Predicting using Moving Averages

Practice Data

Centred Moving Averages

Preview

Weighted Moving Averages

Calculating Standard Deviation for Prediction made using Moving Averages

Predicting for Seasonal Data

Linear Regression

Calculating Correlations

Preview

Linear Regression

Linear Regression - Demonstration

Worked Out Example - Linear Regression

Linear Regression using LINEST() function

Worked Out Example - Linear Regression using LINEST()

Predicting using TREND() function

Worked Out Example - Predicting with TREND()

Linear Regression using Data Analysis ToolKit

Worked Out Example - Linear Regression using Data Analysis ToolKit

Linear Regression = Level-Level Regression

Multi-Variate Linear Regression

Worked Out Example - Multi-Variate Linear Regression

Exponential Regression

Exponential Regression using a Linear Model

Worked Out Example - Exponential Regression using a Linear Model

Optimising Exponential Regression using Solver

Worked Out Example - Optimising Exponential Regression using Solver

Exponential Regression using LOGEST()

Preview

Worked Out Example - Exponential Regression using LOGEST()

Multi-Variate Exponential Regression

Worked Out Example - Multi-Variate Exponential Regression

Power Regression

Power Regression using Linear Model

Worked Out Example - Power Regression using Linear Model

Multi-Variate Power Regression

Worked Out Example - Multi-Variate Power Regression

Logarithmic Regression

Logarithmic Regression using Linear Model

Worked Out Example - Logarithmic Regression using Linear Model

Non-Linear Regression

Quadratic Regression

Worked Out Example - Quadratic Regression

Polynomial Regression

Worked Out Example - Polynomial Regression

Selecting a Model through Experimentation

Worked Out Example - Selecting a Model with demonstration

Guidelines for Selecting Model

Worked Out Example - Normal Distribution

Standard Error of Mean

Preview

Worked Out Example - Standard Error of Mean

Confidence Interval

Worked Out Example - Confidence Interval

Course Closure

Project

Preview

Exercise File for Project Work

Practice Data

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

By: Partha Majumdar

Share the link to this page

Copied

Facebook

Twitter

Add the class to your calendar

Add to Google Calendar

Add to Apple Calendar

Add to Yahoo Calendar

Add to Outlook Calendar

Completed

You need to have access to the item to view this lesson.

One-time Fee

$69.99

List Price: $99.99

You save: $30

€67.24

List Price: €96.07

You save: €28.82

£55.68

List Price: £79.55

You save: £23.86

CA$100.66

List Price: CA$143.82

You save: CA$43.15

A$111.82

List Price: A$159.75

You save: A$47.93

S$94.88

List Price: S$135.55

You save: S$40.66

HK$543.79

List Price: HK$776.87

You save: HK$233.08

CHF 62.67

List Price: CHF 89.54

You save: CHF 26.86

NOK kr792.28

List Price: NOK kr1,131.89

You save: NOK kr339.60

DKK kr501.55

List Price: DKK kr716.53

You save: DKK kr214.98

NZ$123.71

List Price: NZ$176.74

You save: NZ$53.02

د.إ257.07

List Price: د.إ367.25

You save: د.إ110.18

৳8,328.16

List Price: ৳11,897.89

You save: ৳3,569.72

₹5,958.01

List Price: ₹8,511.81

You save: ₹2,553.80

RM314.25

List Price: RM448.95

You save: RM134.70

₦108,236.03

List Price: ₦154,629.53

You save: ₦46,393.50

₨19,398.69

List Price: ₨27,713.60

You save: ₨8,314.91

฿2,394.21

List Price: ฿3,420.45

You save: ฿1,026.24

₺2,465.01

List Price: ₺3,521.60

You save: ₺1,056.58

B$426.13

List Price: B$608.79

You save: B$182.65

R1,290

List Price: R1,842.93

You save: R552.93

Лв131.30

List Price: Лв187.58

You save: Лв56.28

₩101,582.03

List Price: ₩145,123.41

You save: ₩43,541.37

₪254.54

List Price: ₪363.65

You save: ₪109.10

₱4,098.92

List Price: ₱5,855.86

You save: ₱1,756.93

¥10,967.38

List Price: ¥15,668.35

You save: ¥4,700.97

MX$1,406.50

List Price: MX$2,009.38

You save: MX$602.87

QR254.06

List Price: QR362.96

You save: QR108.89

P963.25

List Price: P1,376.14

You save: P412.88

KSh9,053.20

List Price: KSh12,933.70

You save: KSh3,880.50

E£3,568.78

List Price: E£5,098.48

You save: E£1,529.69

ብር8,687.63

List Price: ብር12,411.43

You save: ብር3,723.80

Kz64,250.82

List Price: Kz91,790.82

You save: Kz27,540

CLP$69,297.02

List Price: CLP$99,000

You save: CLP$29,702.97

CN¥510.87

List Price: CN¥729.84

You save: CN¥218.97

RD$4,243.89

List Price: RD$6,062.96

You save: RD$1,819.07

DA9,435.69

List Price: DA13,480.14

You save: DA4,044.44

FJ$162.05

List Price: FJ$231.51

You save: FJ$69.46

Q536.99

List Price: Q767.16

You save: Q230.17

GY$14,580.66

List Price: GY$20,830.41

You save: GY$6,249.74

ISK kr9,757.30

List Price: ISK kr13,939.60

You save: ISK kr4,182.30

DH701.41

List Price: DH1,002.06

You save: DH300.64

L1,291.33

List Price: L1,844.84

You save: L553.50

ден4,135.36

List Price: ден5,907.91

You save: ден1,772.55

MOP$557.92

List Price: MOP$797.07

You save: MOP$239.14

N$1,283.07

List Price: N$1,833.03

You save: N$549.96

C$2,564.57

List Price: C$3,663.83

You save: C$1,099.26

रु9,479.94

List Price: रु13,543.35

You save: रु4,063.41

S/259.51

List Price: S/370.75

You save: S/111.23

K282.61

List Price: K403.75

You save: K121.13

SAR262.99

List Price: SAR375.71

You save: SAR112.72

ZK1,928.73

List Price: ZK2,755.44

You save: ZK826.71

L334.62

List Price: L478.06

You save: L143.43

Kč1,690.23

List Price: Kč2,414.72

You save: Kč724.49

Ft27,882.67

List Price: Ft39,834.10

You save: Ft11,951.42

SEK kr772.23

List Price: SEK kr1,103.23

You save: SEK kr331

ARS$71,547.27

List Price: ARS$102,214.77

You save: ARS$30,667.50

Bs481.59

List Price: Bs688.02

You save: Bs206.42

COP$305,890.51

List Price: COP$437,005.17

You save: COP$131,114.66

₡35,162.35

List Price: ₡50,234.08

You save: ₡15,071.73

L1,769.11

List Price: L2,527.41

You save: L758.30

₲543,432.39

List Price: ₲776,365.26

You save: ₲232,932.87

$U3,131.93

List Price: $U4,474.38

You save: $U1,342.44

zł286.59

List Price: zł409.44

You save: zł122.84

Already have an account? Log In

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

Practice Data

Sign Up

Sign Up

Share