Forecasting Professor Ahmadi 1 Learning Objectives

Understand when to use various types of forecasting models and the time horizon. Understand qualitative and quantitative tools of forecasting. Compute moving averages and exponential smoothing models. Analyze trends and seasonality in time-series data. Compute variety of forecasting error measures. Use variables in linear regression model. Use Excel to analyze variety of forecasting models 2 Eight Steps to Forecasting 1. Determine use of forecast - what objective are we trying to obtain? 2. Select items or quantities to be forecasted. 3. Determine time horizon of forecast:

Short-range (less than three months) Medium-range (3 months to 3 years) Long-range (3+ years) 4. Select forecasting model or models. 5. Gather data needed to make forecast. 6. Validate forecasting model. 7. Make forecast. 8. Implement results. 3 Types of Forecasts 4 Qualitative Models Qualitative models attempt to incorporate judgmental or subjective factors into forecasting

model. Opinions by experts, individual experiences and judgments, and other subjective factors may be considered. Qualitative models are especially useful when subjective factors are expected to be very important or when accurate quantitative data are difficult to obtain. Qualitative models are also useful for long-term forecasting.

5 Measuring Forecast Error Mean Absolute Deviation (MAD): MAD = |forecast error| / forecast error|forecast error| / / T = |forecast error| / At - Ft|forecast error| / /T Mean Squared Error (MSE): MSE = (forecast error)2 / T = (At Ft)2 / T Mean Absolute Percent Error (MAPE): MAPE = 100 (|forecast error| / At - Ft|forecast error| / / At) / T

6 Time - Series and Causal (Associative) Models Time-series Models: Time-series models attempt to predict future by using historical data. Models make assumption that what happens in future is a function of what has happened in past. 2. Causal Models: As with time-series models, causal models also rely on quantitative data. Bivariate and multivariate regression models are examples of associative models. 1. 7

Moving Average MA is a series of arithmetic means Used if little or no trend Used often for smoothing Provides overall impression of data over time Equation: MA = (Actual value in previous Actual value in previous k periods) / k

8 Weighted Moving Averages Used when trend is present Older data usually less important Weights based on intuition Equation: k-period weighted moving average =

(weight for period i) (actual value in period i) (weights) 9 Exponential Smoothing A form of weighted moving average Weights decline exponentially Most recent data weighted most Requires smoothing constant () ranges from 0 to 1 is subjectively chosen

Equation: Ft= Ft-1 + (Actual value in previous At-1 - Ft-1 ) 10 Time series Components The four Components of Time Series are: 1. Trend 2. Seasonal 3. Cyclical 4. Random The time series can be decomposed into its four components.

11 General Forms of Time-series Models There are two general forms of time-series models: Most widely used is multiplicative model, which assumes forecasted value is product of four components. Forecast = (Trend) . (Seasonality) . (Cycles) . ( Random) Additive model adds components together to provide an estimate is also available. It is stated as:

Forecast = Trend + Seasonality + Cycles + Random 12 Causal Models Goal of causal forecasting model is to develop best statistical relationship between dependent variable and independent variables. Most common model used in practice is regression analysis. In causal forecasting models, when one tries to predict dependent variable using single

independent variable it is called a simple regression model. When one uses more than one independent variable to forecast dependent variable, it is called a multiple regression model. 13

Recently Viewed Presentations

  • Body Systems  Part II Chemical Signals  CH 45

    Body Systems Part II Chemical Signals CH 45

    Thyroid Stimulating Hormone (TSH) stimulates the thyroid gland (releases thyroid hormone which increases metabolic rate, raising body temp) Adrenocorticotropic Hormone (ACTH) stimulates the production and secretion of steroid hormones by the adrenal cortex (part of the adrenal gland) Melanocyte-stimulating Hormone...
  • The Victorian Era

    The Victorian Era

    The Victorian Era Finding a representative poem difficult, because: Romantic/Victorian distinction not sharp long era--lots of poetry and it varied "representative" implies a unified entity, but the Victorian era was the one which called unity into question Era of exposure...
  • Excite-Making a Time Scale of Your Year

    Excite-Making a Time Scale of Your Year

    Geologic Time Scale Helps us study Earth's past- which is really old (estimated 4.6 billion years old) Divides Earth's history into intervals of time determined by --major events/changes in the rock layers, and --the appearance/disappearance of fossils/life Slow Changes on...
  • MITOSIS 10X Magnification of Stained Human Cheek Cells

    MITOSIS 10X Magnification of Stained Human Cheek Cells

    The spindle has now formed and the nuclear membrane has broken down. The chromosomes are lined up along the cell's center and are attached to the spindle fibers. When the individual chromatids (½ of the "X") are separated from the...
  • Lesson 2 eKiDs PowerChart Features

    Lesson 2 eKiDs PowerChart Features

    Let's Put It All Together Try thinking of the Electronic Medical Record (EMR) as an assembly line. Assembling the EMR Each software package behaves like a station along that assembly line inspecting the product and adding or modifying parts along...

    The Welsh Government also provide for a Third Sector Partnership Council (TSPC) chaired by the Cabinet Secretary with responsibility for the sector. The TSPC has a seat for each section of the third sector and the AWNW holds the seat...
  • The Role of Preclinical Models to Identify Novel

    The Role of Preclinical Models to Identify Novel

    The Role of Preclinical Models to Identify Novel Therapeutics in Rare Cancers Peter J. Houghton, Ph.D. St. Jude Children's Research Hospital Why Do Preclinical Cancer Models Fail?
  • Ace personal trainer manual

    Ace personal trainer manual

    Parascapular muscles (i.e., serratus anterior, rhomboids, and lower trapezius) cause movement of the scapulae, and maintain stability against the rib cage A lack of thoracic spine mobility compromises stability of the scapulothoracic region, which affects mobility of the glenohumeral joint...