# Greybox main vignette

#### Ivan Svetunkov

#### 2023-09-15

There are three well-known notions of “boxes” in modelling: 1. White box - the model that is completely transparent and does not have any randomness. One can see how the inputs are transformed into the specific outputs. 2. Black box - the model which does not have an apparent structure. One can only observe inputs and outputs but does not know what happens inside. 3. Grey box - the model that is in between the first two. We observe inputs and outputs plus have some information about the structure of the model, but there is still a part of unknown.

The white boxes are usually used in optimisations (e.g. linear programming), while black boxes are popular in machine learning. As for the grey box models, they are more often used in analysis and forecasting. So the package `greybox` contains models that are used for these purposes.

At the moment the package contains augmented linear model function and several basic functions that implement model selection and combinations using information criteria (IC). You won’t find statistical tests in this package - there’s plenty of them in the other packages. Here we try using the modern techniques and methods that do not rely on hypothesis testing. This is the main philosophical point of `greybox`.

## Main functions

The package includes the following functions for models construction:

1. alm() - Augmented Linear Model. This is something similar to GLM, but with a focus on forecasting and the information criteria usage for time series. It also supports mixture distribution models for the intermittent data and allows adding trend to the data via the formula.
2. stepwise() - select the linear model with the lowest IC from all the possible in the provided data. Uses partial correlations. Works fast;
3. lmCombine() - combine the linear models into one using IC weights;
4. lmDynamic() - produce model with dynamic weights and time varying parameters based on point IC weight.

See discussion of some of these functions in this vignette below.

## Models evaluation functions

1. ro() - produce forecasts with a specified function using rolling origin.
2. `measures()` - function, returning a bunch of error measures for the provided forecast and the holdout sample.
3. `rmcb()` - regression on ranks of forecasting methods. This is a fast alternative to the classical nemenyi / MCB test.

## Marketing analytics tools

1. `tableplot()` - creates a plot for two categorical variables based on table function with frequencies inside.
2. `cramer()` - Cramer’s V value.
3. `mcor()` - the multiple correlation coefficient.
4. `association()` - the matrix of measures of association.
5. `spread()` - function that plots scatter / boxplot / tableplot diagrams between variables depending on the their types.
6. `determination()` - coefficients of determination for the set of explanatory variables.

All these functions are discussed in a separate vignette on marketing analytics tools.

## Methods

The following methods can be applied to the models, produced by `alm()`, `stepwise()`, `lmCombine()` and `lmDynamic()`:

1. `logLik()` - extracts log-likelihood.
2. `AIC()`, `AICc()`, `BIC()`, `BICc()` - calculates the respective information criteria.
3. `pointLik()` - extracts the point likelihood.
4. `pAIC()`, `pAICc()`, `pBIC()`, `pBICc()` - calculates the respective point information criteria, based on pointLik.
5. `actuals()` - extracts the actual values of the response variable.
6. `coefbootstrap()` - produces bootstrapped values of parameters, taking `nsim` samples of the size `size` from the data and reapplying the model.
7. `coef()`, `coefficients()` - extract the parameters of the model.
8. `confint()` - extracts the confidence intervals for the parameters.
9. `vcov()` - extracts the variance-covariance matrix of the parameters.
10. `sigma()` - extracts the standard deviation of the residuals.
11. `nobs()` - the number of the in-sample observations of the model.
12. `nparam()` - the number of all the estimated parameters in the model.
13. `nvariate()` - the number of variates (columns / dimensions) of the resposne variable.
14. `summary()` - produces the summary of the model.
15. `predict()` - produces the predictions based on the model and the provided `newdata`. If the `newdata` is not provided, then it uses the already available data in the model. Can also produce `confidence` and `prediction` intervals.
16. `forecast()` - acts similarly to `predict()` with few differences. It has a parameter `h` - forecast horizon - which is `NULL` by default and is set to be equal to the number of rows in `newdata`. However, if the `newdata` is not provided, then it will produce forecasts of the explanatory variables to the horizon `h` and use them as `newdata`. Finally, if `h` and `newdata` are provided, then the number of rows to use will be regulated by `h`.
17. `plot()` - produces several plots for the analysis of the residuals. This includes: Fitted over time, Standardised residuals vs Fitted, Absolute residuals vs Fitted, Q-Q plot with the specified distribution, Squared residuals vs Fitted, ACF of the residuals and PACF of the residuals, which is regulated by `which` parameter. See documentation for more info: `?plot.greybox`.
18. `detectdst()` and `detectleap()` - methods that return the ids of the hour / date for the DST / Leap year change.
19. `extract()` method, needed in order to produce printable regression outputs using `texreg()` function from the `texreg` package.

## Exogenous variables transformation tools

1. xregExpander() - expand the provided data by including leads and lags of the variables. See details below.
2. `xregTransformer()` - produce non-linear transformations of the provided data (logs, inverse etc).
3. `xregMultiplier()` - produce cross-products of the variables in the provided matrix. Could be useful when exploring interaction effects of dummy variables.
4. `temporaldummy()` - the method that generates a matrix with dummy variables based on the provided object and selected `type` and `of`. Can be handy, when you want to construct a regression with dummies for a time series object (e.g. zoo).
5. `outlierdummy()` - the method that creates a matrix of dummy variables based on the residuals of an object, selected confidence level and type of residuals.

## Distribution functions

1. `qlaplace()`, `dlaplace()`, `rlaplace()`, `plaplace()` - functions for Laplace distribution.
2. `qalaplace()`, `dalaplace()`, `ralaplace()`, `palaplace()` - functions for Asymmetric Laplace distribution.
3. `qs()`, `ds()`, `rs()`, `ps()` - functions for S distribution.
4. `qgnorm()`, `dgnorm()`, `rgnorm()`, `pgnorm()` - functions for the Generalised normal distribution.
5. `qfnorm()`, `dfnorm()`, `rfnorm()`, `pfnorm()` - functions for folded normal distribution.
6. `qtplnorm()`, `dtplnorm()`, `rtplnorm()`, `ptplnorm()` - functions for three parameter log normal distribution.
7. `qbcnorm()`, `dbcnorm()`, `rbcnorm()`, `pbcnorm()` - functions for the Box-Cox normal distribution.
8. `qlogitnorm()`, `dlogitnorm()`, `rlogitnorm()`, `plogitnorm()` - functions for the Logit-normal distribution.

## Additional functions

1. `graphmaker()` - produces linear plots for the variable, its forecasts and fitted values.

## xregExpander

The function `xregExpander()` is useful in cases when the exogenous variable may influence the response variable either via some lags or leads. As an example, consider `BJsales.lead` series from the `datasets` package. Let’s assume that the `BJsales` variable is driven by the today’s value of the indicator, the value five and 10 days ago. This means that we need to produce lags of `BJsales.lead`. This can be done using `xregExpander()`:

    BJxreg <- xregExpander(BJsales.lead,lags=c(-5,-10))

The `BJxreg` is a matrix, which contains the original data, the data with the lag 5 and the data with the lag 10. However, if we just move the original data several observations ahead or backwards, we will have missing values in the beginning / end of series, so `xregExpander()` fills in those values with the forecasts using `es()` and `iss()` functions from `smooth` package (depending on the type of variable we are dealing with). This also means that in cases of binary variables you may have weird averaged values as forecasts (e.g. 0.7812), so beware and look at the produced matrix. Maybe in your case it makes sense to just substitute these weird numbers with zeroes…

You may also need leads instead of lags. This is regulated with the same `lags` parameter but with positive values:

    BJxreg <- xregExpander(BJsales.lead,lags=c(7,-5,-10))

Once again, the values are shifted, and now the first 7 values are backcasted. In order to simplify things we can produce all the values from 10 lags till 10 leads, which returns the matrix with 21 variables:

    BJxreg <- xregExpander(BJsales.lead,lags=c(-10:10))

## stepwise

The function stepwise() does the selection based on an information criterion (specified by user) and partial correlations. In order to run this function the response variable needs to be in the first column of the provided matrix. The idea of the function is simple, it works iteratively the following way:

1. The basic model of the first variable and the constant is constructed (this corresponds to simple mean). An information criterion is calculated;
2. The correlations of the residuals of the model with all the original exogenous variables are calculated;
3. The regression model of the response variable and all the variables in the previous model plus the new most correlated variable from (2) is constructed using `lm()` function;
4. An information criterion is calculated and is compared with the one from the previous model. If it is greater or equal to the previous one, then we stop and use the previous model. Otherwise we go to step 2.

This way we do not do a blind search, going forward or backwards, but we follow some sort of “trace” of a good model: if the residuals contain a significant part of variance that can be explained by one of the exogenous variables, then that variable is included in the model. Following partial correlations makes sure that we include only meaningful (from technical point of view) variables in the model. In general the function guarantees that you will have the model with the lowest information criterion. However this does not guarantee that you will end up with a meaningful model or with a model that produces the most accurate forecasts. So analyse what you get as a result.

Let’s see how the function works with the Box-Jenkins data. First we expand the data and form the matrix with all the variables:

    BJxreg <- as.data.frame(xregExpander(BJsales.lead,lags=c(-10:10)))
    BJxreg <- cbind(as.matrix(BJsales),BJxreg)
    colnames(BJxreg)[1] <- "y"
    ourModel <- stepwise(BJxreg)

This way we have a nice data frame with nice names, not something weird with strange long names. It is important to note that the response variable should be in the first column of the resulting matrix. After that we use stepwise function:

    ourModel <- stepwise(BJxreg)

And here’s what it returns (the object of class `lm`):

    ourModel
    #> Time elapsed: 0.27 seconds
    #> Call:
    #> alm(formula = y ~ xLag4 + xLag9 + xLag3 + xLag10 + xLag5 + xLag6 +
    #>     xLead9 + xLag7 + xLag8, data = data, distribution = "dnorm")
    #>
    #> Coefficients:
    #> (Intercept)       xLag4       xLag9       xLag3      xLag10       xLag5
    #>  17.6668913   3.3703773   1.3725674   4.6768101   1.5415708   2.3209845
    #>       xLag6      xLead9       xLag7       xLag8
    #>   1.7074084   0.3765307   1.4027852   1.3371727

The values in the function are listed in the order of most correlated with the response variable to the least correlated ones. The function works very fast because it does not need to go through all the variables and their combinations in the dataset.

All the basic methods can be used together with the final model (e.g. `predict()`, `forecast()`, `summary()` etc).

Furthermore, the `greybox` package implements `extract()` method from `texreg` package for the production of printable outputs from the regression, here is an example:

    texreg::htmlreg(ourModel)

Statistical models
| Model 1
--- | ---
(Intercept) | 17.67*
| [16.07; 19.26]
xLag4 | 3.37*
| [ 2.75; 3.99]
xLag9 | 1.37*
| [ 0.75; 1.99]
xLag3 | 4.68*
| [ 4.10; 5.25]
xLag10 | 1.54*
| [ 0.98; 2.11]
xLag5 | 2.32*
| [ 1.68; 2.96]
xLag6 | 1.71*
| [ 1.06; 2.35]
xLead9 | 0.38*
| [ 0.12; 0.63]
xLag7 | 1.40*
| [ 0.76; 2.05]
xLag8 | 1.34*
| [ 0.69; 1.98]
Num. obs. | 150.00
Num. param. | 11.00
Num. df | 139.00
AIC | 416.45
AICc | 418.36
BIC | 449.57
BICc | 454.36
* 0 outside the confidence interval.

Similarly, you can produce pdf tables via `texreg()` function from that package. Alternatively, you can use `kable()` function from `knitr` package on the summary to get a table for LaTeX / HTML.

## lmCombine

`lmCombine()` function creates a pool of linear models using `lm()`, writes down the parameters, standard errors and information criteria and then combines the models using IC weights. The resulting model is of the class “lm.combined”. The speed of the function deteriorates exponentially with the increase of the number of variables \(k\) in the dataset, because the number of combined models is equal to \(2^k\). The advanced mechanism that uses `stepwise()` and removes a large chunk of redundant models is also implemented in the function and can be switched using `bruteforce` parameter.

Here’s an example of the reduced data with combined model and the parameter `bruteforce=TRUE`:

    ourModel <- lmCombine(BJxreg[,-c(3:7,18:22)],bruteforce=TRUE)
    summary(ourModel)
    #> The AICc combined model
    #> Response variable: y
    #> Distribution used in the estimation: Normal
    #> Coefficients:
    #>             Estimate Std. Error Importance Lower 2.5% Upper 97.5%
    #> (Intercept)  20.9213     0.2326     1.0000    20.4616     21.3811 *
    #> x            -0.0432     0.0286     0.2591    -0.0998      0.0134
    #> xLag5         6.3977     0.0839     1.0000     6.2318      6.5636 *
    #> xLag4         5.8466     0.0899     1.0000     5.6688      6.0244 *
    #> xLag3         5.6854     0.0901     1.0000     5.5074      5.8635 *
    #> xLag2         0.1251     0.0382     0.2876     0.0496      0.2006 *
    #> xLag1        -0.0844     0.0342     0.2717    -0.1521     -0.0167 *
    #> xLead1       -0.0908     0.0324     0.2782    -0.1547     -0.0268 *
    #> xLead2       -0.0356     0.0257     0.2600    -0.0865      0.0152
    #> xLead3       -0.1200     0.0343     0.2971    -0.1877     -0.0523 *
    #> xLead4       -0.0068     0.0229     0.2585    -0.0520      0.0384
    #> xLead5        0.1159     0.0300     0.3030     0.0566      0.1751 *
    #>
    #> Error standard deviation: 2.2075
    #> Sample size: 150
    #> Number of estimated parameters: 7.2151
    #> Number of degrees of freedom: 142.7849
    #> Approximate combined information criteria:
    #>      AIC     AICc      BIC     BICc
    #> 670.6603 671.4964 692.3824 694.4770

`summary()` function provides the table with the parameters, their standard errors, their relative importance and the 95% confidence intervals. Relative importance indicates in how many cases the variable was included in the model with high weight. So, in the example above variables xLag5, xLag4, xLag3 were included in the models with the highest weights, while all the others were in the models with lower ones. This may indicate that only these variables are needed for the purposes of analysis and forecasting.

The more realistic situation is when the number of variables is high. In the following example we use the data with 21 variables. So if we use brute force and estimate every model in the dataset, we will end up with \(2^{21}\) = `2^21` combinations of models, which is not possible to estimate in the adequate time. That is why we use `bruteforce=FALSE`:

    ourModel <- lmCombine(BJxreg,bruteforce=FALSE)
    summary(ourModel)
    #> The AICc combined model
    #> Response variable: y
    #> Distribution used in the estimation: Normal
    #> Coefficients:
    #>             Estimate Std. Error Importance Lower 2.5% Upper 97.5%
    #> (Intercept)  17.6924     0.7760     1.0000    16.1580     19.2268 *
    #> xLag4         3.3747     0.3020     1.0000     2.7775      3.9719 *
    #> xLag9         1.3711     0.3029     0.9998     0.7723      1.9699 *
    #> xLag3         4.6846     0.2809     1.0000     4.1292      5.2400 *
    #> xLag10        1.5424     0.2749     1.0000     0.9989      2.0859 *
    #> xLag5         2.3222     0.3118     1.0000     1.7058      2.9386 *
    #> xLag6         1.7075     0.3145     1.0000     1.0858      2.3293 *
    #> xLead9        0.3638     0.1247     0.9663     0.1174      0.6103 *
    #> xLag7         1.4017     0.3152     0.9997     0.7786      2.0249 *
    #> xLag8         1.3363     0.3132     0.9994     0.7170      1.9556 *
    #>
    #> Error standard deviation: 0.936
    #> Sample size: 150
    #> Number of estimated parameters: 10.9652
    #> Number of degrees of freedom: 139.0348
    #> Approximate combined information criteria:
    #>      AIC     AICc      BIC     BICc
    #> 416.7030 418.6040 449.7152 454.4777

In this case first, the `stepwise()` function is used, which finds the best model in the pool. Then each variable that is not in the model is added to the model and then removed iteratively. IC, parameters values and standard errors are all written down for each of these expanded models. Finally, in a similar manner each variable is removed from the optimal model and then added back. As a result the pool of combined models becomes much smaller than it could be in case of the brute force, but it contains only meaningful models, that are close to the optimal. The rationale for this is that the marginal contribution of variables deteriorates with the increase of the number of parameters in case of the stepwise function, and the IC weights become close to each other around the optimal model. So, whenever the models are combined, there is a lot of redundant models with very low weights. By using the mechanism described above we remove those redundant models.

There are several methods for the `lm.combined` class, including:

1. `predict.greybox()` - returns the point and interval predictions.
2. `forecast.greybox()` - wrapper around `predict()` The forecast horizon is defined by the length of the provided sample of `newdata`.
3. `plot.lm.combined()` - plots actuals and fitted values.
4. `plot.predict.greybox()` - which uses `graphmaker()` function from `smooth` in order to produce graphs of actuals and forecasts.

As an example, let’s split the whole sample with Box-Jenkins data into in-sample and the holdout:

    BJInsample <- BJxreg[1:130,];
    BJHoldout <- BJxreg[-(1:130),];
    ourModel <- lmCombine(BJInsample,bruteforce=FALSE)

A summary and a plot of the model:

    summary(ourModel)
    #> The AICc combined model
    #> Response variable: y
    #> Distribution used in the estimation: Normal
    #> Coefficients:
    #>             Estimate Std. Error Importance Lower 2.5% Upper 97.5%
    #> (Intercept)  19.4134     0.8558     1.0000    17.7189     21.1079 *
    #> xLag4         3.3480     0.2966     1.0000     2.7607      3.9353 *
    #> xLag9         1.3340     0.2983     0.9990     0.7434      1.9247 *
    #> xLag3         4.7559     0.2787     1.0000     4.2040      5.3078 *
    #> xLag10        1.5364     0.2701     1.0000     1.0016      2.0713 *
    #> xLag5         2.3209     0.3063     1.0000     1.7144      2.9274 *
    #> xLag6         1.6611     0.3090     1.0000     1.0493      2.2730 *
    #> xLead9        0.2948     0.1260     0.8920     0.0454      0.5443 *
    #> xLag8         1.3692     0.3084     0.9989     0.7585      1.9799 *
    #> xLag7         1.3274     0.3093     0.9982     0.7150      1.9397 *
    #>
    #> Error standard deviation: 0.9541
    #> Sample size: 130
    #> Number of estimated parameters: 10.8881
    #> Number of degrees of freedom: 119.1119
    #> Approximate combined information criteria:
    #>      AIC     AICc      BIC     BICc
    #> 367.7981 369.9900 399.0203 404.3546
    plot(ourModel)

Importance tells us how important the respective variable is in the combination. 1 means 100% important, 0 means not important at all.

And the forecast using the holdout sample:

    ourForecast <- predict(ourModel,BJHoldout)
    plot(ourForecast)

These are the main functions implemented in the package for now. If you want to read more about IC model selection and combinations, I would recommend (Burnham and Anderson 2004) textbook.

## References

Burnham, Kenneth P, and David R Anderson. 2004. Model Selection and Multimodel Inference. Edited by Kenneth P Burnham and David R Anderson. Springer New York. https://doi.org/10.1007/b97636.