Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Business Analytics: Forecasting with Trended Baseline Smoothing

Business Analytics: Forecasting with Trended Baseline Smoothing

1h 1mAdvanced2018-10-05

Authors

Conrad Carlberg

Conrad Carlberg

Writer and Consultant in Quantitative and Statistical Analysis

Course details

Simple exponential smoothing (SES) incorporates most of the elements used in the smoothing approach to forecasting, such as a level smoothing constant, self-correction, and the gradual weakening of the influence of older observations on new forecasts. But SES works poorly with baselines that display either trends or seasonality. The trended time series is one step up in complexity from the stationary time series analyzed by SES—its baseline trends up or down. The use of exponential smoothing with a trended baseline is often called Holt's method, and this course was designed to equip you with this technique. Here, instructor Conrad Carlberg explains how to use Holt's method to create forecasts in R that deal with trends in a baseline.

Learning objectives
Assembling the forecast equation for a trended baseline
Simple exponential smoothing with a stationary baseline
Using R for simple exponential smoothing
Optimizing the level and trend constants via Solver
Using R to forecast a trended series

Skills covered

RBusiness IntelligenceMicrosoft ExcelData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

  • 01 - Why trended baseline smoothing will help your regression
  • 02 - Software setup

1. Simple Exponential Smoothing (SES) and Trend

  • 03 - A review of SES with a stationary baseline
  • 04 - Problems using SES with a trended baseline
  • 05 - Forecasting differences
  • 06 - Using R for SES
  • 07 - Using ARIMA(0,1,1) for SES

2. Understanding the Forecast Equation

  • 08 - Distinguish between a level component and a trend component
  • 09 - The trend constant compared to the level constant
  • 10 - Compare smoothing and error correction forms
  • 11 - Initialize the trend forecasts
  • 12 - Build the full worksheet and optimize with Solver

3. Running the Trend Forecast Analysis in R

  • 13 - Prepare for analysis with R
  • 14 - Run and interpret the analysis in R

Conclusion

  • 15 - Next steps

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal