Adam Gladstone continues a series on using R in Excel:
We have already seen how to obtain descriptive statistics in Part I and how to use
lm()in Part II. In this part (Part III) of the series we will look at using R in Excel to perform forecasting and time series analysis.In the previous two parts we have seen different ways to handle the output from R function calls, unpacking and massaging the data as required. In this part we are going to focus on setting up and interacting with a number of models in the ‘forecast’ package (
fpp2).
Read on for the demo. This is getting into territory that is by no means trivial to do natively in Excel.