![Page 1: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/1.jpg)
Datta Meghe Institute of
Management Studies
Quantitative Techniques
Unit No.:04
Unit Name: Time Series Analysis and Forecasting
1
![Page 2: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/2.jpg)
2
Datta Meghe Institute of
Management Studies
Time Series Analysis and Forecasting - Components of Time Series, Trend - Moving averages, semi-averages and least-squares, seasonal variation, cyclic variation and irregular variation, Index numbers, calculation of seasonal indices, Additive and multiplicative models, Forecasting, Non linear trend – second degree parabolic trends
SYLLABUS
![Page 3: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/3.jpg)
Datta Meghe Institute of
Management Studies
Learning ObjectivesLearning Objectives
• Describe what forecasting is• Explain time series & its components• Smooth a data series• Moving average• Exponential smoothing• Forecast using trend models• Measuring forecast error• The multiplicative time series model• Naïve extrapolation• The mean forecast model• Weighted moving average models
![Page 4: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/4.jpg)
What Is Forecasting?What Is Forecasting?
• Process of predicting a future event
• Underlying basis of all business decisions– Production– Inventory– Personnel– Facilities
![Page 5: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/5.jpg)
• Used when situation is vague & little data exist– New products– New technology
• Involve intuition, experience
• e.g., forecasting sales on Internet
Qualitative Methods
Forecasting ApproachesForecasting Approaches
Quantitative Methods
![Page 6: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/6.jpg)
• Used when situation is ‘stable’ & historical data exist– Existing products– Current technology
• Involve mathematical techniques
• e.g., forecasting sales of color televisions
Forecasting ApproachesForecasting Approaches
• Used when situation is vague & little data exist– New products– New technology
• Involve intuition, experience
• e.g., forecasting sales on Internet
Qualitative Methods Quantitative Methods
![Page 7: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/7.jpg)
Datta Meghe Institute of
Management Studies
Quantitative Forecasting Quantitative Forecasting
• Select several forecasting methods• ‘Forecast’ the past• Evaluate forecasts • Select best method• Forecast the future• Monitor continuously forecast accuracy
![Page 8: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/8.jpg)
Datta Meghe Institute of
Management Studies
Quantitative Forecasting MethodsQuantitative Forecasting Methods
![Page 9: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/9.jpg)
Datta Meghe Institute of
Management Studies
Quantitative Forecasting MethodsQuantitative Forecasting Methods
Quantitative
Forecasting
![Page 10: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/10.jpg)
Datta Meghe Institute of
Management Studies
Quantitative Forecasting MethodsQuantitative Forecasting Methods
Quantitative
Forecasting
Time Series
Models
![Page 11: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/11.jpg)
Datta Meghe Institute of
Management Studies
Causal
Models
Quantitative Forecasting Methods
Quantitative Forecasting Methods
Quantitative
Forecasting
Time Series
Models
![Page 12: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/12.jpg)
Datta Meghe Institute of
Management Studies
Causal
Models
Quantitative Forecasting Methods
Quantitative Forecasting Methods
Quantitative
Forecasting
Time Series
Models
Exponential
Smoothing
Trend
Models
Moving
Average
![Page 13: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/13.jpg)
Datta Meghe Institute of
Management Studies
Causal
Models
Quantitative Forecasting Methods
Quantitative Forecasting Methods
Quantitative
Forecasting
Time Series
Models
RegressionExponential
Smoothing
Trend
Models
Moving
Average
![Page 14: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/14.jpg)
Datta Meghe Institute of
Management Studies
Causal
Models
Quantitative Forecasting Methods
Quantitative Forecasting Methods
Quantitative
Forecasting
Time Series
Models
RegressionExponential
Smoothing
Trend
Models
Moving
Average
CasualModels
![Page 15: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/15.jpg)
Datta Meghe Institute of
Management Studies
What is a Time Series?What is a Time Series?
• Set of evenly spaced numerical data– Obtained by observing response variable at
regular time periods• Forecast based only on past values
– Assumes that factors influencing past, present, & future will continue
• Example– Year: 1995 1996 1997 1998 1999– Sales: 78.7 63.5 89.7 93.2 92.1
![Page 16: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/16.jpg)
Datta Meghe Institute of
Management Studies
Time Series vs. Cross Sectional Data
Time Series vs. Cross Sectional Data
Time series data is a sequence of observations
– collected from a process – with equally spaced periods of time.
![Page 17: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/17.jpg)
Datta Meghe Institute of
Management Studies
Time Series vs. Cross Sectional Data
Time Series vs. Cross Sectional Data
Contrary to restrictions placed on cross-sectional data, the major purpose of forecasting with time series is to extrapolate beyond the range of the explanatory variables.
![Page 18: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/18.jpg)
Time Series vs. Cross Sectional Data
Time Series vs. Cross Sectional Data
Time series is dynamic, it does change over time.
![Page 19: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/19.jpg)
Datta Meghe Institute of
Management Studies
Time Series vs. Cross Sectional Data
Time Series vs. Cross Sectional Data
When working with time series data, it is paramount that the data is plotted so the researcher can view the data.
![Page 20: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/20.jpg)
Datta Meghe Institute of
Management Studies
Time Series ComponentsTime Series Components
![Page 21: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/21.jpg)
Datta Meghe Institute of
Management Studies
Time Series ComponentsTime Series Components
Trend
![Page 22: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/22.jpg)
Datta Meghe Institute of
Management Studies
Time Series ComponentsTime Series Components
Trend Cyclical
![Page 23: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/23.jpg)
Datta Meghe Institute of
Management Studies
Time Series ComponentsTime Series Components
Trend
Seasonal
Cyclical
![Page 24: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/24.jpg)
Datta Meghe Institute of
Management Studies
Time Series ComponentsTime Series Components
Trend
Seasonal
Cyclical
Irregular
![Page 25: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/25.jpg)
Datta Meghe Institute of
Management Studies
Trend ComponentTrend Component
• Persistent, overall upward or downward pattern• Due to population, technology etc.• Several years duration
Mo., Qtr., Yr.
Response
© 1984-1994 T/Maker Co.
![Page 26: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/26.jpg)
Datta Meghe Institute of
Management Studies
Trend ComponentTrend Component
• Overall Upward or Downward Movement• Data Taken Over a Period of Years
Sales
Time
Upward trend
![Page 27: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/27.jpg)
Datta Meghe Institute of
Management Studies
Cyclical ComponentCyclical Component
• Repeating up & down movements• Due to interactions of factors influencing economy• Usually 2-10 years duration
Mo., Qtr., Yr.
Response Cycle
![Page 28: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/28.jpg)
Datta Meghe Institute of
Management Studies
Cyclical ComponentCyclical Component
• Upward or Downward Swings• May Vary in Length• Usually Lasts 2 - 10 Years
Sales
Time
Cycle
![Page 29: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/29.jpg)
Datta Meghe Institute of
Management Studies
• Regular pattern of up & down fluctuations• Due to weather, customs etc.• Occurs within one year
Seasonal ComponentSeasonal Component
Mo., Qtr.
Response
Summer
© 1984-1994 T/Maker Co.
![Page 30: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/30.jpg)
Datta Meghe Institute of
Management Studies
• Upward or Downward Swings• Regular Patterns• Observed Within One Year
Seasonal ComponentSeasonal Component
Sales
Time (Monthly or Quarterly)
Winter
![Page 31: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/31.jpg)
Datta Meghe Institute of
Management Studies
Irregular ComponentIrregular Component
• Erratic, unsystematic, ‘residual’ fluctuations• Due to random variation or unforeseen events
– Union strike– War
• Short duration & nonrepeating
© 1984-1994 T/Maker Co.
![Page 32: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/32.jpg)
Datta Meghe Institute of
Management Studies
Random or Irregular ComponentRandom or Irregular Component
• Erratic, Nonsystematic, Random, ‘Residual’
Fluctuations
• Due to Random Variations of
– Nature
– Accidents
• Short Duration and Non-repeating
![Page 33: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/33.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
![Page 34: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/34.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
TimeSeries
![Page 35: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/35.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
TimeSeries
Trend?
![Page 36: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/36.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
TimeSeries
Trend?Smoothing
Methods
NoNo
![Page 37: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/37.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
TimeSeries
Trend?Smoothing
MethodsTrend
Models
YesYesNoNo
![Page 38: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/38.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
TimeSeries
Trend?Smoothing
MethodsTrend
Models
YesYesNoNo
ExponentialSmoothing
MovingAverage
![Page 39: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/39.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 40: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/40.jpg)
Datta Meghe Institute of
Management Studies
Time Series Analysis
![Page 41: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/41.jpg)
Datta Meghe Institute of
Management Studies
Plotting Time Series Data
09/83 07/86 05/89 03/92 01/95
Month/Year
0
2
4
6
8
10
12
Number of Passengers
(X 1000)Intra-Campus Bus Passengers
Data collected by Coop Student (10/6/95)
![Page 42: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/42.jpg)
Datta Meghe Institute of
Management Studies
Moving Average MethodMoving Average Method
![Page 43: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/43.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 44: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/44.jpg)
Datta Meghe Institute of
Management Studies
Moving Average MethodMoving Average Method
• Series of arithmetic means • Used only for smoothing
– Provides overall impression of data over time
![Page 45: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/45.jpg)
Datta Meghe Institute of
Management Studies
Moving Average MethodMoving Average Method
• Series of arithmetic means • Used only for smoothing
– Provides overall impression of data over time
Used for elementary forecasting
![Page 46: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/46.jpg)
Datta Meghe Institute of
Management Studies
Moving Average GraphMoving Average Graph
0
2
4
6
8
93 94 95 96 97 98
Year
Sales Actual
![Page 47: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/47.jpg)
Datta Meghe Institute of
Management Studies
Moving Average [An Example]
Moving Average [An Example]
You work for Firestone Tire. You want to smooth random fluctuations using a 3-period moving average.
1995 20,0001996 24,0001997 22,0001998 26,0001999 25,000
![Page 48: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/48.jpg)
Datta Meghe Institute of
Management Studies
Moving Average [Solution]
Moving Average [Solution]
Year Sales MA(3) in 1,0001995 20,000 NA1996 24,000 (20+24+22)/3 = 221997 22,000 (24+22+26)/3 = 241998 26,000 (22+26+25)/3 = 241999 25,000 NA
![Page 49: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/49.jpg)
Datta Meghe Institute of
Management Studies
Moving Average
Year Response Moving Ave
1994 2 NA
1995 5 3
1996 2 3
1997 2 3.67
1998 7 5
1999 6 NA
94 95 96 97 98 99
8
6
4
2
0
Sales
![Page 50: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/50.jpg)
Datta Meghe Institute of
Management Studies
Exponential Smoothing MethodExponential Smoothing Method
![Page 51: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/51.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 52: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/52.jpg)
Datta Meghe Institute of
Management Studies
Exponential Smoothing MethodExponential Smoothing Method
• Form of weighted moving average– Weights decline exponentially– Most recent data weighted most
• Requires smoothing constant (W)– Ranges from 0 to 1– Subjectively chosen
• Involves little record keeping of past data
![Page 53: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/53.jpg)
Datta Meghe Institute of
Management Studies
Exponential Smoothing [An Example]
Exponential Smoothing [An Example]
You’re organizing a Kwanza meeting. You want to forecast attendance for 1998 using exponential smoothing ( = .20). Past attendance (00) is:
1995 41996 61997 51998 31999 7
© 1995 Corel Corp.
![Page 54: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/54.jpg)
Datta Meghe Institute of
Management Studies
Exponential SmoothingExponential Smoothing
Time YiSmoothed Value, Ei
(W = .2)Forecast
Yi + 1
1995 4 4.0 NA
1996 6 (.2)(6) + (1-.2)(4.0) = 4.4 4.0
1997 5 (.2)(5) + (1-.2)(4.4) = 4.5 4.4
1998 3 (.2)(3) + (1-.2)(4.5) = 4.2 4.5
1999 7 (.2)(7) + (1-.2)(4.2) = 4.8 4.2
2000 NA NA 4.8
Ei = W·Yi + (1 - W)·Ei-1Ei = W·Yi + (1 - W)·Ei-1
^
![Page 55: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/55.jpg)
Datta Meghe Institute of
Management Studies
Exponential Smoothing [Graph]Exponential Smoothing [Graph]
0
2
4
6
8
93 96 97 98 99Year
Attendance
Actual
![Page 56: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/56.jpg)
Datta Meghe Institute of
Management Studies
Forecast Effect of Smoothing Coefficient (W)
Forecast Effect of Smoothing Coefficient (W)
Weight
W is... Prior Period2 Periods
Ago3 Periods
Ago
W W(1-W) W(1-W)2
0.10 10% 9% 8.1%
0.90 90% 9% 0.9%
Yi+1 = W·Yi + W·(1-W)·Yi-1 + W·(1-W)2·Yi-2 +...^
![Page 57: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/57.jpg)
Datta Meghe Institute of
Management Studies
Linear Time-Series Forecasting Model
Linear Time-Series Forecasting Model
![Page 58: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/58.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 59: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/59.jpg)
Datta Meghe Institute of
Management Studies
Linear Time-Series Forecasting Model
Linear Time-Series Forecasting Model
• Used for forecasting trend• Relationship between response variable Y &
time X is a linear function• Coded X values used often
– Year X: 1995 1996 1997 19981999
– Coded year: 0 1 2 34
– Sales Y: 78.7 63.5 89.7 93.292.1
![Page 60: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/60.jpg)
Datta Meghe Institute of
Management Studies
Linear Time-Series ModelLinear Time-Series Model
Y
Time, X 1
Y b b Xi i 0 1 1
b1 > 0
b1 < 0
![Page 61: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/61.jpg)
Datta Meghe Institute of
Management Studies
Linear Time-Series Model [An Example]
Linear Time-Series Model [An Example]
You’re a marketing analyst for Hasbro Toys. Using coded years, you find Yi = .6 + .7Xi.
1995 11996 11997 21998 21999 4
Forecast 2000 sales.
^
![Page 62: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/62.jpg)
Datta Meghe Institute of
Management Studies
Linear Time-Series [Example]Linear Time-Series [Example]
Year Coded Year Sales (Units)1995 0 11996 1 11997 2 21998 3 21999 4 42000 5 ?
2000 forecast sales: Yi = .6 + .7·(5) = 4.1
The equation would be different if ‘Year’ used.
^
![Page 63: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/63.jpg)
Datta Meghe Institute of
Management Studies
The Linear Trend Model
iii X..XbbY 743143210 Year Coded Sales
94 0 2
95 1 5
96 2 2
97 3 2
98 4 7
99 5 6
0
1
2
3
4
5
6
7
8
1993 1994 1995 1996 1997 1998 1999 2000
Projected to year 2000
CoefficientsIntercept 2.14285714X Variable 1 0.74285714
Excel Output
![Page 64: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/64.jpg)
Datta Meghe Institute of
Management Studies
Time Series Plot
01/93 01/94 01/95 01/96 01/97
Month/Year
16
17
18
19
20
Number of Surgeries
(X 1000)
Surgery Data(Time Sequence Plot)
Source: General Hospital, Metropolis
![Page 65: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/65.jpg)
Datta Meghe Institute of
Management Studies
Time Series Plot [Revised]
01/93 01/94 01/95 01/96 01/97
Month/Year
183
185
187
189
191
193
Number of Surgeries
(X 100)
Revised Surgery Data(Time Sequence Plot)
Source: General Hospital, Metropolis
![Page 66: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/66.jpg)
Datta Meghe Institute of
Management Studies
Seasonality Plot
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month
99.7
99.9
100.1
100.3
100.5
Monthly Index
Revised Surgery Data
(Seasonal Decomposition)
Source: General Hospital, Metropolis
![Page 67: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/67.jpg)
Datta Meghe Institute of
Management Studies
Trend Analysis
12/92 10/93 8/94 6/95 9/96 2/97 12/97
Month/Year
18
18.3
18.6
18.9
19.2
19.5
Number of Surgeries
(X 1000)
Revised Surgery Data(Trend Analysis)
Source: General Hospital, Metropolis
![Page 68: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/68.jpg)
Datta Meghe Institute of
Management Studies
Quadratic Time-Series Forecasting Model
Quadratic Time-Series Forecasting Model
![Page 69: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/69.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 70: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/70.jpg)
Datta Meghe Institute of
Management Studies
Quadratic Time-Series Forecasting Model
Quadratic Time-Series Forecasting Model
• Used for forecasting trend• Relationship between response variable Y & time X
is a quadratic function• Coded years used
![Page 71: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/71.jpg)
Datta Meghe Institute of
Management Studies
Quadratic Time-Series Forecasting Model
Quadratic Time-Series Forecasting Model
• Used for forecasting trend
• Relationship between response variable Y & time X is a quadratic function
• Coded years used
• Quadratic model
Y b b X b Xi i i 0 1 1 11
21
![Page 72: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/72.jpg)
Datta Meghe Institute of
Management Studies
Y
Year, X 1
Y
Year, X 1
Y
Year, X 1
Quadratic Time-Series Model Relationships
Quadratic Time-Series Model Relationships
Y
Year, X 1
b11 > 0b11 > 0
b11 < 0b11 < 0
![Page 73: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/73.jpg)
Datta Meghe Institute of
Management Studies
Quadratic Trend Model
2210 iii XbXbbY
22143308572 iii X.X..Y
Excel Output
Year Coded Sales
94 0 2
95 1 5
96 2 2
97 3 2
98 4 7
99 5 6
CoefficientsIntercept 2.85714286X Variable 1 -0.3285714X Variable 2 0.21428571
![Page 74: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/74.jpg)
Datta Meghe Institute of
Management Studies
Exponential Time-Series ModelExponential Time-Series Model
![Page 75: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/75.jpg)
Datta Meghe Institute of
Management Studies
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 76: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/76.jpg)
Datta Meghe Institute of
Management Studies
Exponential Time-Series Forecasting Model
Exponential Time-Series Forecasting Model
• Used for forecasting trend• Relationship is an exponential function• Series increases (decreases) at increasing
(decreasing) rate
![Page 77: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/77.jpg)
Datta Meghe Institute of
Management Studies
Exponential Time-Series Forecasting Model
Exponential Time-Series Forecasting Model
• Used for forecasting trend• Relationship is an exponential function• Series increases (decreases) at increasing
(decreasing) rate
![Page 78: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/78.jpg)
Datta Meghe Institute of
Management Studies
Exponential Time-Series Model Relationships
Exponential Time-Series Model Relationships
Y
Year, X 1
b1 > 1
0 < b1 < 1
![Page 79: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/79.jpg)
Datta Meghe Institute of
Management Studies
Exponential Weight [Example Graph]
94 95 96 97 98 99
8
6
4
2
0
Sales
Year
Data
Smoothed
![Page 80: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/80.jpg)
Datta Meghe Institute of
Management Studies
CoefficientsIntercept 0.33583795X Variable 10.08068544
Exponential Trend Model
iXi bbY 10 or 110 blogXblogYlog i
Excel Output of Values in logs
iXi ).)(.(Y 21172
Year Coded Sales
94 0 2
95 1 5
96 2 2
97 3 2
98 4 7
99 5 6
antilog(.33583795) = 2.17antilog(.08068544) = 1.2
![Page 81: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/81.jpg)
81
Datta Meghe Institute of
Management Studies
• Described what forecasting is
• Explained time series & its components
• Smoothed a data series– Moving average– Exponential smoothing
• Forecasted using trend models
SUMMARY
![Page 82: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/82.jpg)
82
Datta Meghe Institute of
Management Studies
LONG & SHORT QUESTION
![Page 83: Datta Meghe Institute of Management Studies Quantitative Techniques Unit No.:04 Unit Name: Time Series Analysis and Forecasting 1](https://reader036.vdocuments.us/reader036/viewer/2022062423/56649e0f5503460f94afa63d/html5/thumbnails/83.jpg)
83
Datta Meghe Institute of
Management Studies
• Statistics : Theory and Practice
- R.S.N. Pillai & Bhagwati
Fundamentals of Statistics
- S.C. Gupta
BOOKS REFERRED