![Page 1: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/1.jpg)
Time SeriesTime Series
““The Art of Forecasting”The Art of Forecasting”
![Page 2: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/2.jpg)
What Is Forecasting?What Is Forecasting?What Is Forecasting?What Is Forecasting?• Process of predicting a
future event• Underlying basis of
all business decisions– Production
– Inventory
– Personnel
– Facilities
![Page 3: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/3.jpg)
• Used when situation is vague & little data exist– New products– New technology
• Involve intuition, experience
• e.g., forecasting sales on Internet
Qualitative MethodsQualitative Methods
Forecasting ApproachesForecasting ApproachesForecasting ApproachesForecasting Approaches
Quantitative MethodsQuantitative Methods
![Page 4: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/4.jpg)
• Used when situation is ‘stable’ & historical data exist– Existing products– Current technology
• Involve mathematical techniques
• e.g., forecasting sales of color televisions
Quantitative MethodsQuantitative Methods
Forecasting ApproachesForecasting ApproachesForecasting ApproachesForecasting Approaches
• Used when situation is vague & little data exist– New products– New technology
• Involve intuition, experience
• e.g., forecasting sales on Internet
Qualitative MethodsQualitative Methods
![Page 5: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/5.jpg)
Quantitative ForecastingQuantitative Forecasting Quantitative ForecastingQuantitative Forecasting
• Select several forecasting methods
• ‘Forecast’ the past
• Evaluate forecasts
• Select best method
• Forecast the future
• Monitor continuously forecast accuracy
![Page 6: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/6.jpg)
Quantitative Forecasting Methods
Quantitative Forecasting Methods
![Page 7: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/7.jpg)
Quantitative Forecasting Methods
Quantitative Forecasting Methods
QuantitativeForecasting
![Page 8: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/8.jpg)
Quantitative Forecasting Methods
Quantitative Forecasting Methods
QuantitativeForecasting
Time SeriesModels
![Page 9: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/9.jpg)
CausalModels
Quantitative Forecasting Methods
Quantitative Forecasting Methods
QuantitativeForecasting
Time SeriesModels
![Page 10: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/10.jpg)
CausalModels
Quantitative Forecasting Methods
Quantitative Forecasting Methods
QuantitativeForecasting
Time SeriesModels
ExponentialSmoothing
TrendModels
MovingAverage
![Page 11: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/11.jpg)
CausalModels
Quantitative Forecasting Methods
Quantitative Forecasting Methods
QuantitativeForecasting
Time SeriesModels
RegressionExponentialSmoothing
TrendModels
MovingAverage
![Page 12: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/12.jpg)
CausalModels
Quantitative Forecasting Methods
Quantitative Forecasting Methods
QuantitativeForecasting
Time SeriesModels
RegressionExponentialSmoothing
TrendModels
MovingAverage
![Page 13: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/13.jpg)
What is a Time Series?What is a Time Series?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 14: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/14.jpg)
Time Series vs. Time Series vs. Cross Sectional DataCross Sectional Data
Time series data is a sequence of observations
– collected from a collected from a process process
– with with equally spacedequally spaced periods of time periods of time.
![Page 15: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/15.jpg)
Time Series vs. Time Series vs. Cross Sectional DataCross 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 16: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/16.jpg)
Time Series vs. Time Series vs. Cross Sectional DataCross Sectional Data
Time series is dynamic, it does change over time.
![Page 17: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/17.jpg)
Time Series vs. Time Series vs. Cross Sectional DataCross Sectional Data
When working with time series data, it is paramount that the data is plotted so the researcher can view the data.
![Page 18: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/18.jpg)
Time Series ComponentsTime Series Components
![Page 19: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/19.jpg)
Time Series ComponentsTime Series Components
TrendTrend
![Page 20: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/20.jpg)
Time Series ComponentsTime Series Components
TrendTrend CyclicalCyclical
![Page 21: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/21.jpg)
Time Series ComponentsTime Series Components
TrendTrend
SeasonalSeasonal
CyclicalCyclical
![Page 22: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/22.jpg)
Time Series ComponentsTime Series Components
TrendTrend
SeasonalSeasonal
CyclicalCyclical
IrregularIrregular
![Page 23: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/23.jpg)
Trend ComponentTrend Component• Persistent, overall upward or downward
pattern
• Due to population, technology etc.
• Several years duration
Mo., Qtr., Yr.Mo., Qtr., Yr.
ResponseResponse
© 1984-1994 T/Maker Co.
![Page 24: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/24.jpg)
Trend ComponentTrend Component
• Overall Upward or Downward Movement
• Data Taken Over a Period of Years
Sales
Time
Upward trend
![Page 25: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/25.jpg)
Cyclical ComponentCyclical Component• Repeating up & down movements
• Due to interactions of factors influencing economy
• Usually 2-10 years duration
Mo., Qtr., Yr.Mo., Qtr., Yr.
ResponseResponseCycle
![Page 26: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/26.jpg)
Cyclical ComponentCyclical Component• Upward or Downward Swings
• May Vary in Length
• Usually Lasts 2 - 10 YearsSales
Time
Cycle
![Page 27: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/27.jpg)
Seasonal ComponentSeasonal Component
• Regular pattern of up & down fluctuations
• Due to weather, customs etc.
• Occurs within one year
Mo., Qtr.Mo., Qtr.
ResponseResponseSummerSummer
© 1984-1994 T/Maker Co.
![Page 28: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/28.jpg)
Seasonal ComponentSeasonal Component• Upward or Downward Swings
• Regular Patterns
• Observed Within One YearSales
Time (Monthly or Quarterly)
Winter
![Page 29: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/29.jpg)
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 30: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/30.jpg)
Random or Irregular Random or Irregular ComponentComponent
• Erratic, Nonsystematic, Random,
‘Residual’ Fluctuations
• Due to Random Variations of
– Nature
– Accidents
• Short Duration and Non-repeating
![Page 31: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/31.jpg)
Time Series ForecastingTime Series Forecasting
![Page 32: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/32.jpg)
Time Series ForecastingTime Series ForecastingTime
Series
![Page 33: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/33.jpg)
Time Series ForecastingTime Series ForecastingTime
Series
Trend?
![Page 34: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/34.jpg)
Time Series ForecastingTime Series ForecastingTime
Series
Trend?SmoothingMethods
NoNo
![Page 35: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/35.jpg)
Time Series ForecastingTime Series ForecastingTime
Series
Trend?SmoothingMethods
TrendModels
YesYesNoNo
![Page 36: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/36.jpg)
Time Series ForecastingTime Series ForecastingTime
Series
Trend?SmoothingMethods
TrendModels
YesYesNoNo
ExponentialSmoothing
MovingAverage
![Page 37: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/37.jpg)
Plotting Time Series DataPlotting 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 38: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/38.jpg)
Moving Average MethodMoving Average MethodMoving Average MethodMoving Average Method
![Page 39: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/39.jpg)
Moving Average MethodMoving Average Method
• Series of arithmetic means
• Used only for smoothing– Provides overall impression of data over time
![Page 40: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/40.jpg)
Moving Average MethodMoving Average MethodMoving Average MethodMoving Average Method
• Series of arithmetic means
• Used only for smoothing– Provides overall impression of data over time
Used for elementary forecasting Used for elementary forecasting
![Page 41: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/41.jpg)
Moving Average GraphMoving Average GraphMoving Average GraphMoving Average Graph
0
2
4
6
8
93 94 95 96 97 98
0
2
4
6
8
93 94 95 96 97 98
YearYear
SalesSalesActualActual
![Page 42: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/42.jpg)
Moving Average Moving Average [An Example]
Moving Average 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 43: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/43.jpg)
Moving Average [Solution]
Moving Average [Solution]
Year Sales MA(3) in 1,000
1995 20,000 NA
1996 24,000 (20+24+22)/3 = 22
1997 22,000 (24+22+26)/3 = 24
1998 26,000 (22+26+25)/3 = 24
1999 25,000 NA
![Page 44: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/44.jpg)
Moving Average 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 45: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/45.jpg)
Exponential Smoothing Exponential Smoothing MethodMethod
Exponential Smoothing Exponential Smoothing MethodMethod
![Page 46: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/46.jpg)
Time Series ForecastingTime Series ForecastingTime Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 47: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/47.jpg)
Exponential Smoothing Exponential Smoothing MethodMethod
Exponential Smoothing Exponential Smoothing MethodMethod
• 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 48: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/48.jpg)
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
Exponential SmoothingExponential Smoothing [An Example]
Exponential SmoothingExponential Smoothing [An Example]
© 1995 Corel Corp.
![Page 49: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/49.jpg)
Exponential SmoothingExponential Smoothing [Graph]
Exponential SmoothingExponential Smoothing [Graph]
0
2
4
6
8
93 96 97 98 99
0
2
4
6
8
93 96 97 98 99
YearYear
AttendanceAttendanceActualActual
![Page 50: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/50.jpg)
Linear Time-Series Linear Time-Series Forecasting ModelForecasting ModelLinear Time-Series Linear Time-Series Forecasting ModelForecasting Model
![Page 51: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/51.jpg)
Time Series ForecastingTime Series ForecastingTime Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 52: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/52.jpg)
Linear Time-Series Forecasting ModelLinear 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 1998 1999– Coded year: 0 1 2 3 4– Sales Y: 78.7 63.5 89.7 93.2 92.1
![Page 53: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/53.jpg)
Linear Time-Series Linear Time-Series ModelModelLinear Time-Series Linear Time-Series ModelModel
Y
Time, X1
Y
Time, X1
Y b b Xi i 0 1 1Y b b Xi i 0 1 1
bb11 > 0 > 0
bb11 < 0 < 0
![Page 54: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/54.jpg)
Quadratic Time-Series Quadratic Time-Series Forecasting ModelForecasting Model
Quadratic Time-Series Quadratic Time-Series Forecasting ModelForecasting Model
![Page 55: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/55.jpg)
Time Series ForecastingTime Series ForecastingTime Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 56: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/56.jpg)
Quadratic Time-Series Quadratic Time-Series Forecasting ModelForecasting Model
Quadratic Time-Series Quadratic Time-Series Forecasting ModelForecasting Model
• Used for forecasting trend
• Relationship between response variable Y & time X is a quadratic function
• Coded years used
![Page 57: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/57.jpg)
Exponential Time-Series Exponential Time-Series ModelModel
Exponential Time-Series Exponential Time-Series ModelModel
![Page 58: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/58.jpg)
Time Series ForecastingTime Series ForecastingTime Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 59: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/59.jpg)
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 60: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/60.jpg)
Autoregressive ModelingAutoregressive ModelingAutoregressive ModelingAutoregressive Modeling
![Page 61: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/61.jpg)
Time Series ForecastingTime Series Forecasting
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
Linear
TimeSeries
Trend?SmoothingMethods
TrendModels
YesNo
ExponentialSmoothing
Quadratic Exponential Auto-Regressive
MovingAverage
![Page 62: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/62.jpg)
Autoregressive ModelingAutoregressive Modeling• Used for forecasting trend
• Like regression model– Independent variables are lagged response
variables Yi-1, Yi-2, Yi-3 etc.
• Assumes data are correlated with past data values– 1st Order: Correlated with prior period
• Estimate with ordinary least squares
![Page 63: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/63.jpg)
Autoregressive Model Autoregressive Model [An Example][An Example]
The Office Concept Corp. has acquired a number of office units (in thousands of square feet) over the last 8 years.
Develop the 2nd order Autoregressive models.Year Units
92 4 93 3 94 2 95 3 96 2 97 2 98 4 99 6
![Page 64: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/64.jpg)
Autoregressive Model Autoregressive Model [Example Solution][Example Solution]
Year Yi Yi-1 Yi-2
92 4 --- --- 93 3 4 --- 94 2 3 4 95 3 2 3 96 2 3 2 97 2 2 3 98 4 2 2 99 6 4 2
CoefficientsIntercept 3.5X Variable 1 0.8125X Variable 2 -0.9375
Excel Output
21 9375812553 iii Y.Y..Y
•Develop the 2nd order table
•Use Excel to run a regression model
![Page 65: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/65.jpg)
Evaluating ForecastsEvaluating ForecastsEvaluating ForecastsEvaluating Forecasts
![Page 66: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/66.jpg)
Quantitative Forecasting Steps
Quantitative Forecasting Steps
• Select several forecasting methods
• ‘Forecast’ the past
• Evaluate forecasts • Select best method
• Forecast the future
• Monitor continuously forecast accuracy
![Page 67: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/67.jpg)
Questions?
![Page 68: Time Series “The Art of Forecasting”. What Is Forecasting? Process of predicting a future event Underlying basis of all business decisions –Production](https://reader036.vdocuments.us/reader036/viewer/2022062516/56649e0f5503460f94afa157/html5/thumbnails/68.jpg)
ANOVA