Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Was this using the Holt's method? The equations are different in your spreadsheet than the ones we are to use. I've attached a picture of

Was this using the Holt's method? The equations are different in your spreadsheet than the ones we are to use. I've attached a picture of the equations since the answers I have are different and I'm not sure why.

image text in transcribed
V F (Smooth Forecast) C D E F G H I K L M N 0.8 0.2 F (Smooth Forecast) T (Trend) FIT (Total) FIT, = FT. FIT,+ a(A,-1 - FIT,-;) TI-1 + B(F, - FIT,-1) Ft = FIT -1 + a(At-1 - FIT,-1) T. = Ti-1 + B(F, - FIT,-1) FIT, is the forecast including trend at period t (this period). F, is the forecast at period t (this period). T, is the trend estimate at period t (this period). FIT,-1 is the forecast including trend at period t-1 (perivous period). F-1 is the forecast at period t-1 (previous period). T,-1 is the trend estimate at period t-1 (previous period). A,-1 is the actual data at period t-1(previous period). a is exponential smoothing constant. B is trend smoothing constant

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Wisdom Of Crowds

Authors: James Surowiecki

1st Edition

0385721706, 9780385721707

More Books

Students also viewed these Economics questions

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago