Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Trend adjusted exponential smoothing formula

20/10/2021 Client: muhammad11 Deadline: 2 Day

Forcasting Recurrence

IST 230 Exercise on Forecasting Recurrences

Use Excel or OpenOffice to forecast the Airline Sales and US Interest Rate data in the data spreadsheet (data.xls or data.ods). You'll see that I started this for you for the airline data. There's also a tutorial in the exercise directory which you may find helpful.

Smooth the data using exponential smoothing. If you think the time series does not have a long-term trend up or down, use simple exponential smoothing. If you think the time series does have a long-term trend up or down, use trend-adjusted exponential smoothing for each of these time series. Note that this requires that you first do the simple exponential smoothing, and then compute the trend as the smoothed difference between successive forecasts. Finally, compute the trend-adjusted forecast as the sum of these two. Your objective should be to get a fairly smooth (hence the term “smoothing”) curve that follows the trend and runs as closely as possible through the middle of the data. This will usually give an RMS error as small as possible without following the cycles.

Add some type of cyclical adjustment. My usual approach is to compute a ratio the actual data and the exponentially smoothed forecast – a so-called “cyclical index” (or if it follows a calendar-year pattern, it's called a “seasonal index”.) You'll find additional info in the tutorial.

For both time series (airline-sales and interest-rates), forecast 12 periods ahead (h=12), starting from the beginning of your data, and extrapolate your forecast 12 periods past where you have actual data, based on your latest trend estimate and your cyclical index. Note you won't be able to assess the forecast for these, since you don't have actual data.

Use the exponential smoothing formulae given below.

Compute the mean-squared error by summing the squared differences between the forecast values and the actual values.

Your deliverable a one or two page executive summary of your results in a PDF document entitled exercise8-flastname.pdf, where flastname is your first initial and last name (e.g., for me, dmudgett). In your summary, present

- A brief one-sentence statement of your problem plus an explanation of how you
selected alpha, beta, and figured out the cyclical pattern. (1 paragraph)

- Graphs of your forecast and actual data for your final choices of alpha and beta
(should be just 2 graphs)

- A table of RMS forecast error for at least 3 choices of alpha and beta, for each time
series.

Here are the exponential smoothing formulae (carefully read the explanation of n-periods ahead forecasting).

Simple Exponential Smoothing:

The simple exponential smoothing forecast is given by:

F(t+1) = F(t) + alpha*(A(t) - F(t)) = (1-alpha)*F(t) + alpha*A(t) (1)

where

F(t+1) = the one-period-ahead forecast for period t+1

F(t) = the forecast for period t

A(t) = the actual value in period t

alpha is known as the smoothing constant, a constant in the range (0,1)

Trend-Adjusted Exponential Smoothing:

The trend-adjusted exponentially smoothed forecast is given by:

FT(t+1) = F(t+1) + T(t) (2)

where F(t+1) = the one-period-ahead exponentially smoothed forecast for period t+1

T(t) = the trend correction in period t, which is given by:

T(t) = beta*(F(t)-F(t-1)) + (1-beta)*T(t-1) (3)

and beta is the smoothing constant for the trend estimation, also a constant in the range (0,1).

NOTE: Equation (2) is *not* a recurrence. Compute the recurrences (1) and (3) first, then use equation (2).

You can think of beta exactly the same way as you think about alpha for simple exponential smoothing. In fact, it's probably a good idea to set beta = alpha, unless you have a reason to think it should be different.

Comment: alpha and beta are usually determined by experimentation, to see what works best on the time-series you're forecasting. To give you some idea what the affect is, think about it this way:

alpha/beta equivalent n-period moving average

0.1 about 12 periods

0.2 about 6 periods

0.3 about 4 periods

0.5 about 3 periods

0.7 about 2 periods

These are just rough equivalences, but give you an idea how fast the smoother reacts to a major change in the data pattern.

Final point: Extrapolating the smoothed forecast more than one time-period ahead.

For simple exponential smoothing, forecasting more than one period ahead is no big deal. Just use the h-period-ahead formula (h is called the forecasting horizon):

F(t+h) = F(t+1) = (1-alpha)*F(t) + alpha*A(t) (4)

You also compute the trend exactly as before - use equation (3) completely unmodified. But equation (2) may change, depending on how many periods you want to extrapolate the trend. For example, if you want to forecast h-periods ahead and also extrapolate the trend h periods ahead, then change equation (2) to

FT(t+h) = F(t+h) + h*T(t) (5)

As a practical matter, a forecaster may not want to extrapolate the trend all the way through the forecast horizon. Let's say, for example that you want to forecast 6 periods ahead, and aren't sure the trend will continue all 6 periods. Let's say a retailer wants to use a forecast to decide how much of a product they needed 6 months down the line. If they extrapolate the trend all 6 months and it doesn't happen, they'll wind up with too much stock. In this case it may make sense to be more conservative and extrapolate the trend *less then* the total number of periods in the forecast horizon.

Either way - once you decide how many periods you want to extrapolate the forecast - call that integer m - then the trend-adjusted forecast is given by this slightly modified equation 5:

FT(t+k) = F(t+k) + min(k,m)*T(t) (6)

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Smart Accountants
Homework Guru
Smart Homework Helper
Homework Master
Financial Solutions Provider
Assignment Helper
Writer Writer Name Offer Chat
Smart Accountants

ONLINE

Smart Accountants

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$15 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$27 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$46 Chat With Writer
Homework Master

ONLINE

Homework Master

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$16 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$43 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$31 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Make a haiku generator - Charles knight finance reviews - Assignment 3 - Newspaper article - Intelligence and homeland security - Brain tumors with restricted diffusion - No saco nada de la escuela analytical essay - Precede proceed model steps - Reaction of magnesium with hydrochloric acid lab answers - SULA - Trader joe's talent pool - General healthcare technology trends particularly related to data information - Storeapps global tesco org - Social science inquiry - When is my baby due - Organizational behavior 13th edition 13th edition pdf - English 101 Essay 3 PG about - Ion boardroom theme powerpoint download - Dennis kozlowski net worth today - The Management And Human Resources  - What is precipitate chemistry - Formal Languages and Automata Theory - Cisco metro ethernet design and implementation guide - Truth table for gated sr latch - 111 antoine street rydalmere - Flinders university bachelor of arts - Westlake research hospital database - Calculate gdp as the value added in production pizzania - Rona goffen titian's venus of urbino - What is film techniques - Introduction science report example - Earth sun relations exercise 12 answers - Gledhill torrent re solar - Week 1 Responses - The aspiring thinker's guide to critical thinking pdf - Topic 1: Community/Public Health Nursing - Sam sneads early bird menu - Pristiq 25 mg chemist warehouse - Reframing organizations 5th edition summary - Prismaflex crrt return blood - Dis 2 - Molecular weight of red dye - Calculate the molecular mass - Hands on networking fundamentals 2nd edition answers - Staffordshire university term dates - Should preschool be mandatory - History extended essay structure - Forces in equilibrium lab - Virtualbox convert raw image to vdi - Mil g 81827 equivalent - Regency grand hotel case study analysis - ADAPTIVE LEADERSHIP - The complete cook's country tv show cookbook pdf - House purchase grant wandsworth - Rpm formula for turning - How to create a climate graph in excel - Exam 02.03 peer influence answers - Weight of 1 weetabix - Naadac code of ethics apa citation - Super's life career rainbow - Independent worksheet - Boeing 737 800 quick reference handbook - Power point Presentation - Journal article - Blood vessel, blood pressure and blood components. - MANAGEMENT - Unlock alice solution - Employees with negative affectivity are inclined to - Computer hardware study guide - CASES CASE 35 CIRQUE DU SOLEIL* The founder of Cirque du Soleil, Guy Laliberté, after see- ing the firm’s growth prospects wane in recent years, was thinking about expanding his firm in new directions. For three decades, the firm had reinvented and revolutionized the circus. From its beginning in 1984, Cirque de Soleil had thrilled over 150 million spectators with a novel show concept that was as original as it was nontraditional: an astonishing theatrical blend of circus acts and street enter- tainment, wrapped up in spectacular costumes and fairy- land sets and staged to spellbinding music and magical lighting. Cirque du Soleil’s business triumphs mirrored its high- flying aerial stunts, and it became a case study for business school journal articles on carving out unique markets. But following a recent bleak outlook report from a consultant, a spate of poorly received shows over the last few years, and a decline in profits, executives at Cirque said they were now restructuring a - A lesson before dying wiki - Symbolism in the second coming by william butler yeats - What is a theoretical orientation in counseling - Chandra mahadasha ketu antardasha - Mid Term Assignment - Https edu gcfglobal org en excel2016 - Email - ¿qué le vas a ____ a la quinceañera? - Is dream an abstract noun - 1000 milliliters to liters - Sex education in schools pros and cons essay - Dental annex thornlie wa - Classic vs contemporary literature - EBP - Sap solution manager test suite training - Order 2148040: immigration - Eric the tutor nas - Jake’s roof repair has provided the following data concerning its costs: - When did bank of america acquired merrill lynch - Superfast diamond golden wheat reviews - Chapter 3 rocks materials of the solid earth - Freight in and freight out normal balance - Edward scissorhands characters personalities - Philosophy - Cft meaning in construction - Fmea steps ihi - Midnight journal entry solution - Bhavika investments a group of financial advisors - Deer hunt catal huyuk - History rock n roll