Hello Community,
I need help in interpreting the results generated by ARIMA and ETS in the following usecase.
Which is best and why ?
or
Both are not good.
I am attaching the flow for the same.
~Thank You
Rhitik Krishnani
Hello,
Suppose I have A,B,C and Sales Columns
ETS and ARIMA gave me forecasted sales for next year.
So how to add a new column to the exiting data in the below format
A B C Sales Forecasted Sales
Please help me out,
~Thank You
Rhitik Krishnani
1. ARIMA is the best model as it seemed to outperform ETS. When comparing your errors the one closer to 0 or with the lowest scores is your best model.
2. I created two Batch Macros - one to compare which model would work best for each item name, the second to forecast each item for the next 12 months (ARIMA)
Hope this helps!
Best,
Joslyn
Hello,
I am really grateful to you for you help.
I am attaching the flow which I have created.
Can you help me with
ARIMA
ETS
TS Forecast
TS Compare
in the flow which I am attaching because based on my data I dont know what configurations of the model need to be selected like sub period and all.
Please take a look and help me out
I really appreciate.
~Rhitik Krishnani
The output columns will be in any .xlsx / .csv file:
Date will be from Jan-22 to Dec-22 (Forecasting)
Item Name : For all Item Name in each Month of Year 2022
Quantity Forecasted : Upper and Lower Value
Please help me out as i am new to this tool.
I really appreciate your time and effortsl
Thank you