Challenge #24: ARIMA Time Series

[bjkay30]

Here is my take.  Pretty simple and similar to others posted here.

Spoiler

[BradWerner]

Spoiler

[KT2]

Spoiler

[Hjardine]

My forecast numbers are not matching the output and I'm not sure why. I replaced all nulls with the appropriate values, but still getting incorrect values. I even looked at other correct solutions and lined up my data with theirs, as well as the configuration of the Arima Model tool and they all match up, only thing that's different is the forecast numbers! Can someone help explain why I'm getting different results? Some of my forecasts are actually negative. Workflow is attached and below. 

[JonathanW]

All done. Minor difference in confidence values

[edgarl]

Spoiler

[edgarl]

Hi Hjardine,

Looks like you need to sort the records in chronological order after the union tool as ARIMA assumes that your records are in weekly chronological order.

Example as attached.

[johnemery]

I spent about 10 minutes searching for why my results differed from the output in the start file. Turns out others pointed it out, too.

Spoiler