Home

Need help with forecasting function

%3CLINGO-SUB%20id%3D%22lingo-sub-481587%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20forecasting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481587%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20apply%20the%20forecast%20function%20forecast.ETS%20or%20forecast.ETS.Seasonality%20to%20the%20data%20as%20it%20is%20set%20up%20in%20the%20attached%20file%3F%20If%20I%20need%20to%20do%20this%20manually%20as%20explained%20by%20Jalayer%20academy%20in%20the%20videos%2C%20feel%20free%20to%20add%20columns%20or%20set%20the%20data%20up%20differently.%20Thanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVideo%201%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DgHdYEZA50KE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DgHdYEZA50KE%3C%2FA%3E%3C%2FP%3E%3CP%3EVideo%202%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D5C012eMSeIU%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D5C012eMSeIU%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dkcfiu-f88JQ%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EVideo%203%3A%20https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dkcfiu-f88JQ%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-481587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Quinn Fung-A-Wing
Occasional Contributor

Hi,

Can anyone help me apply the forecast function forecast.ETS or forecast.ETS.Seasonality to the data as it is set up in the attached file? If I need to do this manually as explained by Jalayer academy in the videos, feel free to add columns or set the data up differently. Thanks in advance!

 

Video 1: https://www.youtube.com/watch?v=gHdYEZA50KE

Video 2: https://www.youtube.com/watch?v=5C012eMSeIU

Video 3: https://www.youtube.com/watch?v=kcfiu-f88JQ

 

Part 1: http://www.youtube.com/watch?v=gHdYEZA50KE&feature=youtu.be Part 3: http://www.youtube.com/watch?v=kcfiu-f88JQ&feature=youtu.be This is Part 2 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Part 1 before watching this part and Part 3 upon completing Part 1 ...
Part 1: http://www.youtube.com/watch?v=gHdYEZA50KE&feature=youtu.be Part 2: http://www.youtube.com/watch?v=5C012eMSeIU&feature=youtu.be This is Part 3 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Part 1 and 2 before watching this part. The links for Parts 1 and 2
Part 2: http://www.youtube.com/watch?v=5C012eMSeIU&feature=youtu.be Part 3: http://www.youtube.com/watch?v=kcfiu-f88JQ&feature=youtu.be This is Part 1 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Parts 2 and 3 upon completing Part 1. The links for 2 and 3 are in ...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies