HELP NEEDED IN INTERPRETING THE RESULTS

[Rhitik_Krishnani]

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

[binuacs]

this video may help 

https://community.alteryx.com/t5/Interactive-Lessons/ETS-and-ARIMA/ta-p/610376

[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

[joslynzichawo]

Hi @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

[Rhitik_Krishnani]

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

[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