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

American jerk by todd schwartz - Gwen harwood writing style - Discussions - English file advanced answer key - Asa24 login - Social psychology definition paper psy 400 - Pavlovian Milestones - Can i import cosmetics to malaysia - Akbar shah khan najeebabadi wikipedia - What is a pcbu - Chemical and Engineering News - They say i say across disciplines 4th edition pdf - Ingredients in black salve - 2 4 5 triphenylimidazole wikipedia - How much does a chips ahoy cookie weigh - Nspa shower gel boots - Nsw lotteries corporation granville nsw 2142 - Capability statement template powerpoint - 93 little hobart street garbage pit - The stock of nogro corporation is currently - SQL ( fund of data systems) - 7 non price determinants of demand - Needle exchange delivery dandenong - Trait approach to leadership theory - How to take chally assessment - Dorothy johnson behavioral system model pdf - Powerpoint module 2 sam exam - Neighbor rosicky quotes - What is excel qm - Crow's foot notation guide - Wic 2a s modules - Iron carbon phase diagram - Review of bill - Cultural artifact paper - Create your own carbon cycle - Technology project proposal example - Chromium vi phosphide formula - Cengage brain coupon code august 2015 - Static and dynamic resistance of diode from graph - Cfa piling method statement - Omnibus leadership model - Discussion Question - Strategic points document preparation - Bangladesh high commission canberra passport - Math in the Bible - Hsn colin cowie beverage server - Shadow health neurological assessment documentation - Pacific cataract and laser institute case study - Criminal profiling cases solved - Discussion Question ONE TO TWO PARAGRAPHS - Compare and contrast autocratic and democratic leadership styles - Assume the role of HR manager. The HR director has requested a business report that details the ideal organizational culture, qualities and characteristics of the employees, and leadership attributes for cultivating a culture of creativity and innovation. - Normal and nonnormal cash flows - Wide gap joint fill - How strong are the competitive forces confronting lululemon - The managerial process of crafting and executing strategy - Hydrogen bond between thymine and adenine - Topo pcr cloning kit - Into thin air krakauer pdf - NEED DONE ASAP - Project management in manufacturing ppt - Sweet leaf bath co marketing report - Leadership roles and management functions in nursing apa citation - HR - When writing persuasive messages, one way to avoid faulty logic is to - Reading - How far is a million steps - Mis en scene elements - Concept mapping worksheet answers - Pericarditis bread and butter - Sociology - City of crest hill - Harvard project management simulation answers - Nursing intervention for abdominal pain - Cleanaway customer service centre - Tsum tsum auto heart sender group - Holy child school killiney - Leadership - Samuel by grace paley character analysis - Ergonomic risk assessment template - Gea 3600 uf syllabus - Anthraquinone contains only carbon hydrogen and oxygen - Principal component analysis python pandas - Woolworths demerger tax implications - 4-1 multiplexer truth table - How to enter charges in epic - Joined rome to capua - Punctuating Quotations - Co-Teaching Models and Paraeducator Action Plan - Guthrie method cost estimation - Character Evolution Thesis statement - Introduction to industrial organization luis m cabral pdf - Half subtractor using nor gates only - Sandtoft profile ridge system - Scribe barossa shiraz 2015 - Brave new world conformity quotes - The market for pizza has the following demand and supply schedules - Legal environment of business 8th edition pdf - Finite state machine testing example - Week 7 340b