0

0

1772 days ago,
629 views

PowerPoint PPT Presentation
Time Series Forecasting. Part 11. Prologue to Time Series Analysis. A period arrangement is an arrangement of perceptions on a quantitative variable gathered over time.ExamplesDow Jones Industrial AveragesHistorical information on deals, stock, client checks, financing costs, costs, etcBusinesses are regularly extremely intrigued by guaging time arrangement variables.Often, free variables are not accessible t

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science 5 th release Cliff T. Ragsdale

Chapter 11 Time Series Forecasting

Introduction to Time Series Analysis A period arrangement is an arrangement of perceptions on a quantitative variable gathered after some time. Illustrations Dow Jones Industrial Averages Historical information on deals, stock, client numbers, loan costs, costs, and so forth Businesses are frequently exceptionally inspired by determining time arrangement factors. Regularly, free factors are not accessible to assemble a relapse model of a period arrangement variable. In time arrangement investigation, we dissect the past conduct of a variable with a specific end goal to anticipate its future conduct.

Some Time Series Terms Stationary Data - a period arrangement variable showing no critical upward or descending pattern after some time. Nonstationary Data - a period arrangement variable showing a huge upward or descending pattern after some time. Occasional Data - a period arrangement variable showing a rehashing designs at general interims after some time.

Approaching Time Series Analysis There are numerous, a wide range of time arrangement procedures. It is typically difficult to know which method will be best for a specific informational collection. It is standard to experiment with a few unique strategies and select the one that appears to work best. To be a powerful time arrangement modeler, you have to keep a few time arrangement strategies in your "tool kit."

Measuring Accuracy We require an approach to think about various time arrangement procedures for a given informational index. Four normal strategies are the: mean outright deviation, mean total percent blunder, the mean square mistake, root mean square blunder. We will concentrate on the MSE.

Extrapolation Models Extrapolation models attempt to represent the past conduct of a period arrangement variable with an end goal to anticipate the future conduct of the variable . We'll first discuss a few extrapolation methods that are suitable for stationary information.

An Example Electra-City is a retail location that offers sound and video gear for the home and auto. Every month the supervisor of the store must request stock from a far off distribution center. Right now, the chief is attempting to gauge what number of VCRs the store is probably going to offer in the following month. He has gathered 24 months of information. See document Fig11-1.xls

Moving Averages No broad strategy exists for deciding k . We should experiment with a few k qualities to perceive what works best.

Implementing the Model See record Fig11-2.xls

A Comment on Comparing MSE Values Care ought to be taken when looking at MSE estimations of two diverse guaging strategies. The most reduced MSE may come about because of a strategy that fits more seasoned values extremely well however fits late values inadequately. It is now and then shrewd to process the MSE utilizing just the latest qualities.

Forecasting With The Moving Average Model Forecasts for eras 25 and 26 at day and age 24:

The weighted moving normal system takes into account distinctive weights to be appointed to past perceptions. Weighted Moving Average The moving normal strategy doles out equivalent weight to every single past perception We should decide values for k and the w i

Implementing the Model See record Fig11-4.xls

Forecasting With The Weighted Moving Average Model Forecasts for eras 25 and 26 at day and age 24:

It can be demonstrated that the above condition is comparable to: Exponential Smoothing

Examples of Two Exponential Smoothing Functions

Implementing the Model See document Fig11-8.xls

Forecasting With The Exponential Smoothing Model Forecasts for eras 25 and 26 at day and age 24: Note that,

Seasonality is a standard, rehashing design in time arrangement information. May be added substance or multiplicative in nature...

Stationary Seasonal Effects

Stationary Data With Additive Seasonal Effects E t is the normal level at day and age t. S t is the regular element for day and age t. where p speaks to the quantity of occasional periods

Implementing the Model See document Fig11-13.xls

Forecasting With The Additive Seasonal Effects Model Forecasts for eras 25 to 28 at era 24:

Stationary Data With Multiplicative Seasonal Effects E t is the normal level at day and age t. S t is the regular variable for day and age t. where p speaks to the quantity of regular periods

Implementing the Model See record Fig11-16.xls

Forecasting With The Multiplicative Seasonal Effects Model Forecasts for eras 25 to 28 at era 24:

Trend Models Trend is the long haul range or general course of development in a period arrangement. We'll now think of some as nonstationary time arrangement procedures that are suitable for information displaying upward or descending patterns.

An Example WaterCraft Inc. is a producer of individual watercrafts (otherwise called stream skis). The organization has delighted in a genuinely enduring development in offers of its items. The officers of the organization are planning deals and assembling anticipates the coming year. Figures are required of the level of offers that the organization hopes to accomplish each quarter. See document Fig11-19.xls

Double Moving Average E t is the normal base level at day and age t. T is the normal pattern at day and age t. where

Implementing the Model See record Fig11-20.xls

Forecasting With The Double Moving Average Model Forecasts for eras 21 to 24 at day and age 20:

where E t = a Y t + (1-an )(E t - 1 + t - 1 ) T t = b (E t - E t - 1 ) + (1-b ) t - 1 Double Exponential Smoothing (Holt's Method) E t is the normal base level at day and age t. T is the normal pattern at era t.

Implementing the Model See record Fig11-22.xls

Forecasting With Holt's Model Forecasts for eras 21 to 24 at day and age 20:

Holt-Winter's Method For Additive Seasonal Effects where

Implementing the Model See document Fig11-25.xls

Forecasting With Holt-Winter's Additive Seasonal Effects Method Forecasts for eras 21 to 24 at era 20:

Holt-Winter's Method For Multiplicative Seasonal Effects where

Implementing the Model See record Fig11-28.xls

Forecasting With Holt-Winter's Multiplicative Seasonal Effects Method Forecasts for eras 21 to 24 at day and age 20:

The Linear Trend Model For instance:

Implementing the Model See record Fig11-31.xls

Forecasting With The Linear Trend Model Forecasts for eras 21 to 24 at day and age 20:

The TREND() Function TREND(Y-go, X-go, X-esteem for expectation) where: Y-range is the spreadsheet run containing the reliant Y variable, X-range is the spreadsheet run containing the autonomous X variable(s), X-esteem for forecast is a cell (or cells) containing the qualities for the free X variable(s) for which we need an expected estimation of Y. Take note of: The TREND( ) capacity is powerfully refreshed at whatever point any contributions to the capacity change. Notwithstanding, it doesn't give the measurable data gave by the relapse apparatus. It is best two utilize these two distinctive ways to deal with doing relapse in conjunction with each other.

The Quadratic Trend Model

Implementing the Model See document Fig11-34.xls

Forecasting With The Quadratic Trend Model Forecasts for eras 21 to 24 at day and age 20:

Computing Multiplicative Seasonal Indices We can register multiplicative occasional modification files for period p as takes after: The last figure for period i is then

Implementing the Model See record Fig11-37.xls

Forecasting With Seasonal Factors Applied To The Quadratic Trend Model Forecasts for eras 21 to 24 at era 20:

Summary of the Calculation and Use of Seasonal Indices 1. Make a pattern demonstrate and compute the assessed esteem ( ) for every perception in the specimen. 2. For every perception, figure the proportion of the real incentive to the anticipated pattern esteem: (For added substance impacts, register the distinction: 3. For each season, figure the normal of the proportions ascertained in step 2. These are the regular lists. 4. Duplicate any conjecture created by the pattern demonstrate by the suitable occasional file ascertained in step 3. (For added substance occasional impacts, add the suitable element to the conjecture.)

Refining the Seasonal Indices Note that Solver can be utilized to at the same time decide the ideal estimations of the regular lists and the parameters of the pattern model being utilized. There is no assurance that this will create a superior gauge, yet it ought to deliver a model that fits the information better as far as the MSE. See document Fig11-39.xls

Our case issue includes quarterly information, so p =4 and we characterize the accompanying 3 pointer factors: Seasonal Regression Models Indicator factors may likewise be utilized as a part of relapse models to speak to occasional impacts. On the off chance that there are p seasons, we require p - 1 marker factors.

Implementing the Model The relapse capacity is: See document Fig11-42.xls

Forecasting With The Seasonal Regression Model Forecasts for eras 21 to 24 at day and age 20:

Crystal Ball (CB) Predictor CB Predictor is an include that rearranges the way toward performing time arrangement investigation in Excel. A trial rendition of CB Predictor is accessible on the CD-ROM going with this book. For more data on CB Predictor see: http

SPONSORS

No comments found.

SPONSORS

SPONSORS