# What time-series frequency should I use? Weekly, monthly, quarterly

First, I read the Q&As here, but it's not entirely clear for me what to do given my situation.

I have more than 1700 different time series, each expressed as weekly data. My objective is to produce "good enough" forecasts (in terms of accuracy) for the next season/quarter. The length of my longest time series is 117 weekly data points, which starts halfway 2016.

The models I am currently considering are the simplest models: naive, seasonal naive, mean, random walk + drift. I would also like to consider some exponential smoothing models and potentially an ARIMA model using auto.arima() from the forecast package in R. I wonder:

1. Can I just keep the data weekly and produce forecasts 13 steps (weeks) ahead?
2. I am interested in forecasting one season ahead, so would it be best to build my models in quarterly data or will my time series become much too 'short'? (in my dataset I have an indicator for which season / quarter the week belongs to). This would mean I have a maximum of 9 quarters and for most time series much less (this could be even only 2).
3. Follow up on 2: as a maximum of 9 data points in a time series seems (too) few, would it be good to aggregate my weekly data to monthly data and produce 3 months ahead forecasts based on this?

1. Yes, you can do that. If you are considering auto.arima(), then simply use forecast(..., h=13) and look at ?forecast.Arima (note the capitalization).
• Thanks for your quick help! I am using tsCV at the moment (instead of a holdout sample), which I will also use with the auto.arima function, if that's possible at least. For your 3rd answer: I would like to do the comparison based on the RMSE. So: weekly data forecasts --> RMSE, monthly or quarterly data forecasts --> RMSE. Can I simply use the average RMSE for the weekly data (i.e. sum of the 13 RMSEs and divide by 13) to compare it to the RMSE of the quarterly data (or average RMSE of the monthly data)? Commented Jan 31, 2019 at 15:51
• Re tsCV: I don't know that one, so I can't comment on it - sorry. Re RMSE: better to calculate the RMSE on quarterly forecasts: on the one hand, just aggregate weekly forecasts and compare the sum against the actual using RMSE, on the other hand, compare the quarterly forecast against the actual. Aggregating RMSEs (instead of forecasts) assumes independence to be meaningful, which is always dubious in time series. Commented Jan 31, 2019 at 15:54
• FYI: tsCV is also from the forecast package, that ensures cross validation (CV) is possible without having to come up with tedious code. CV is in case of the naive, snaive, and mean method pointless I believe, but will be useful for when I try out complexer models. Commented Jan 31, 2019 at 16:06