## 11.4 Forecasting Australian domestic tourism

We will compute forecasts for the Australian tourism data that was described in Section 11.1. We use the data up to the end of 2015 as a training set, withholding the final two years (eight quarters, 2016Q1–2017Q4) as a test set for evaluation. The code below demonstrates the full workflow for generating coherent forecasts using the bottom-up, OLS and MinT methods.

```
tourism %>%
tourism_full <- aggregate_key((State / Region) * Purpose, Trips = sum(Trips))
tourism_full %>%
fit <- filter(year(Quarter) <= 2015) %>%
model(base = ETS(Trips)) %>%
reconcile(
bu = bottom_up(base),
ols = min_trace(base, method = "ols"),
mint = min_trace(base, method = "mint_shrink"),
)
```

Here, `fit`

contains the `base`

ETS model (discussed in Chapter 8) for each series in `tourism_full`

, along with the three methods for producing coherent forecasts as specified in the `reconcile()`

function.

` fit %>% forecast(h = "2 years") fc <-`

Passing `fit`

into `forecast()`

generates base and coherent forecasts across all the series in the aggregation structure. Figures 11.12 and 11.13 plot the four point forecasts for the overnight trips for the Australian total, the states, and the purposes of travel, along with the actual observations of the test set. To make it easier to see the differences, we have included only the last five years of the training data, and have omitted the prediction intervals. In most panels, the increase in overnight trips, especially in the second half of the test set, is higher than what is predicted by the point forecasts. This is particularly noticeable for the mainland eastern states of ACT, New South Wales, Queensland and Victoria, and across all purposes of travel.

```
%>%
fc filter(is_aggregated(Region), is_aggregated(Purpose)) %>%
autoplot(
%>% filter(year(Quarter) >= 2011),
tourism_full level = NULL
+
) ylab("Trips ('000)") +
facet_wrap(vars(State), scales = "free_y")
```

```
%>%
fc filter(is_aggregated(State), !is_aggregated(Purpose)) %>%
autoplot(
%>% filter(year(Quarter) >= 2011),
tourism_full level = NULL
+
) ylab("Trips ('000)") +
facet_wrap(vars(Purpose), scales = "free_y")
```

The accuracy of the forecasts over the test set can be evaluated using the `accuracy()`

function. We summarise some results in Table 11.2 using RMSE and MASE.

Base | Bottom-up | MinT | OLS | Base | Bottom-up | MinT | OLS | |
---|---|---|---|---|---|---|---|---|

Total | 1720.72 | 3070.41 | 2157.29 | 1803.52 | 1.53 | 3.16 | 2.09 | 1.63 |

Purpose | 533.02 | 802.46 | 586.35 | 513.18 | 1.33 | 2.32 | 1.51 | 1.25 |

State | 306.85 | 417.15 | 329.73 | 294.66 | 1.40 | 1.88 | 1.45 | 1.27 |

Regions | 52.64 | 55.12 | 47.39 | 46.95 | 1.13 | 1.18 | 1.02 | 1.00 |

Bottom | 19.38 | 19.38 | 17.97 | 18.32 | 0.98 | 0.98 | 0.94 | 1.02 |

All series | 45.96 | 55.27 | 45.61 | 43.20 | 1.04 | 1.08 | 0.98 | 1.03 |

The scales of the series at different levels of aggregation are quite different, due to aggregation. Hence, we need to be cautious when comparing or calculating scale dependent error measures, such as the RMSE, across levels as the aggregate series will dominate. Therefore, we compare error measures across each level of aggregation, before providing the error measures across all the series in the bottom-row. Notice, that the RMSE increases as we go from the bottom-level to the aggregate levels above.

The following code generates the accuracy measures for the aggregate top-level shown in the first row of the table. Similar code is used to evaluate forecasts for other levels.

```
%>%
fc filter(is_aggregated(State), is_aggregated(Purpose)) %>%
accuracy(
data = tourism_full,
measures = list(rmse = RMSE, mase = MASE)
%>%
) group_by(.model) %>%
summarise(rmse = mean(rmse), mase = mean(mase))
#> # A tibble: 4 x 3
#> .model rmse mase
#> <chr> <dbl> <dbl>
#> 1 base 1721. 1.53
#> 2 bu 3070. 3.16
#> 3 mint 2157. 2.09
#> 4 ols 1804. 1.63
```

Reconciling the base forecasts using OLS and MinT results in more accurate forecasts compared to the bottom-up approach. This result is commonly observed in applications as reconciliation approaches use information from all levels of the structure, resulting in more accurate coherent forecasts compared to the older methods which use limited information. Furthermore, reconciliation usually improves the incoherent base forecasts for almost all levels.