# Is it correct to make a conclusion as to whether a model is best for weekly or daily forecasting by comparing the root mean square errors?

by Stoner   Last Updated September 12, 2019 01:19 AM

I am performing daily and weekly forecasts for 28 days and 4 weeks respectively.

Once I have used the same model to obtain the respective forecasts an root mean square errors (RMSE), I will like to make a conclusion based on just these results, as to whether the model is more suited for daily or weekly forecasting.

Denote the daily forecasts RMSE to be $$RMSE_d$$ and weekly forecasts RMSE to be $$RMSE_w$$. I then arrived at the following formulas and proposition:

$$RMSE_d = \sqrt{\frac{1}{n_i} \sum_j (y_{ij} - \hat{y}_{ij})^2}$$

$$RMSE_w = \sqrt{\frac{1}{n} \sum_i (y_i - \hat{y}_i )^2}$$

where $$n = \sum_i n_i , y_i = \sum_j y_{ij}$$, for weeks $$i = 1, \dots , n$$ and days $$j=1,\dots,7$$.

Then for comparing both metrics, I suppose that $$y_i \approx 7 y_{ij}$$ for each $$i$$. Am I right to conclude that $$RMSE_w \approx 7^2 RMSE_d$$?

I can't seem to find any related online literature nor on this site, but I apologize if there has indeed been a post like this before..

Some insights will be deeply appreciated!

Tags :