For the unbiased statistical analysis of data transformation is necessary to transform data for fit model assumptions. AFR package has default time-series dataset macroKZ of macroeconomic parameters for 2010-2021 period. Dataset is raw, not ordered, with missing values and etc.
AFR recommends:
Step 1. Check data for the format, missing values, outliers and summary statistics (min, max and etc).
Step 2. Check data for stationarity.
Step 3. In case of non-stationarity transform data to stationarity by transformation method.
Step 4. As data is transformed, choose regressors for a model.
As default dataset macroKZ is uploaded, check dataset by checkdata and summary functions. Depending on the outputs, apply necessary functions to eliminate inappropriate properties of the data. For instance, in case of missing values delete these missing values.
data(macroKZ)
checkdata(macroKZ)
#> There are 9 missing items in the dataset
#> There are 0 items in non-numeric format in the dataset
#> There are 0 outliers in the dataset
#> $Missing_items
#> real_gdp GDD_Agr_R GDD_Min_R
#> 0 0 0
#> GDD_Man_R GDD_Elc_R GDD_Con_R
#> 0 0 0
#> GDD_Trd_R GDD_Trn_R GDD_Inf_R
#> 0 0 0
#> GDD_R Rincpop_q Rexppop_q
#> 0 0 0
#> Rwage_q imp exp
#> 0 0 0
#> usdkzt eurkzt rurkzt
#> 0 0 0
#> poil GDP_DEF cpi
#> 0 0 0
#> realest_resed_prim realest_resed_sec realest_comm
#> 0 0 8
#> index_stock_weighted ntrade_Agr ntrade_Min
#> 0 0 0
#> ntrade_Man ntrade_Elc ntrade_Con
#> 0 0 0
#> ntrade_Trd ntrade_Trn ntrade_Inf
#> 0 0 0
#> fed_fund_rate govsec_rate_kzt_3m govsec_rate_kzt_1y
#> 0 0 0
#> govsec_rate_kzt_7y govsec_rate_kzt_10y tonia_rate
#> 0 0 0
#> rate_kzt_mort_0y_1y rate_kzt_mort_1y_iy rate_kzt_corp_0y_1y
#> 1 0 0
#> rate_usd_corp_0y_1y rate_kzt_corp_1y_iy rate_usd_corp_1y_iy
#> 0 0 0
#> rate_kzt_indv_0y_1y rate_kzt_indv_1y_iy realest_resed_prim_rus
#> 0 0 0
#> realest_resed_sec_rus coef_liq_k4 cred_portfolio
#> 0 0 0
#> coef_k1 coef_k3 provisions
#> 0 0 0
#> percent_margin com_inc com_exp
#> 0 0 0
#> oper_inc oth_inc DR
#> 0 0 0
#>
#> $Numeric_format
#> real_gdp GDD_Agr_R GDD_Min_R
#> TRUE TRUE TRUE
#> GDD_Man_R GDD_Elc_R GDD_Con_R
#> TRUE TRUE TRUE
#> GDD_Trd_R GDD_Trn_R GDD_Inf_R
#> TRUE TRUE TRUE
#> GDD_R Rincpop_q Rexppop_q
#> TRUE TRUE TRUE
#> Rwage_q imp exp
#> TRUE TRUE TRUE
#> usdkzt eurkzt rurkzt
#> TRUE TRUE TRUE
#> poil GDP_DEF cpi
#> TRUE TRUE TRUE
#> realest_resed_prim realest_resed_sec realest_comm
#> TRUE TRUE TRUE
#> index_stock_weighted ntrade_Agr ntrade_Min
#> TRUE TRUE TRUE
#> ntrade_Man ntrade_Elc ntrade_Con
#> TRUE TRUE TRUE
#> ntrade_Trd ntrade_Trn ntrade_Inf
#> TRUE TRUE TRUE
#> fed_fund_rate govsec_rate_kzt_3m govsec_rate_kzt_1y
#> TRUE TRUE TRUE
#> govsec_rate_kzt_7y govsec_rate_kzt_10y tonia_rate
#> TRUE TRUE TRUE
#> rate_kzt_mort_0y_1y rate_kzt_mort_1y_iy rate_kzt_corp_0y_1y
#> TRUE TRUE TRUE
#> rate_usd_corp_0y_1y rate_kzt_corp_1y_iy rate_usd_corp_1y_iy
#> TRUE TRUE TRUE
#> rate_kzt_indv_0y_1y rate_kzt_indv_1y_iy realest_resed_prim_rus
#> TRUE TRUE TRUE
#> realest_resed_sec_rus coef_liq_k4 cred_portfolio
#> TRUE TRUE TRUE
#> coef_k1 coef_k3 provisions
#> TRUE TRUE TRUE
#> percent_margin com_inc com_exp
#> TRUE TRUE TRUE
#> oper_inc oth_inc DR
#> TRUE TRUE TRUE
#>
#> $Outliers
#> real_gdp GDD_Agr_R GDD_Min_R
#> 0 0 0
#> GDD_Man_R GDD_Elc_R GDD_Con_R
#> 0 0 0
#> GDD_Trd_R GDD_Trn_R GDD_Inf_R
#> 0 0 0
#> GDD_R Rincpop_q Rexppop_q
#> 0 0 0
#> Rwage_q imp exp
#> 0 0 0
#> usdkzt eurkzt rurkzt
#> 0 0 0
#> poil GDP_DEF cpi
#> 0 0 0
#> realest_resed_prim realest_resed_sec realest_comm
#> 0 0 0
#> index_stock_weighted ntrade_Agr ntrade_Min
#> 0 0 0
#> ntrade_Man ntrade_Elc ntrade_Con
#> 0 0 0
#> ntrade_Trd ntrade_Trn ntrade_Inf
#> 0 0 0
#> fed_fund_rate govsec_rate_kzt_3m govsec_rate_kzt_1y
#> 0 0 0
#> govsec_rate_kzt_7y govsec_rate_kzt_10y tonia_rate
#> 0 0 0
#> rate_kzt_mort_0y_1y rate_kzt_mort_1y_iy rate_kzt_corp_0y_1y
#> 0 0 0
#> rate_usd_corp_0y_1y rate_kzt_corp_1y_iy rate_usd_corp_1y_iy
#> 0 0 0
#> rate_kzt_indv_0y_1y rate_kzt_indv_1y_iy realest_resed_prim_rus
#> 0 0 0
#> realest_resed_sec_rus coef_liq_k4 cred_portfolio
#> 0 0 0
#> coef_k1 coef_k3 provisions
#> 0 0 0
#> percent_margin com_inc com_exp
#> 0 0 0
#> oper_inc oth_inc DR
#> 0 0 0Depending on the outputs, apply necessary functions to eliminate inappropriate properties of the data. For instance, in case of missing values delete these missing values.
As dataset is preliminary cleaned, time-series data needs to be stationary. Stationarity is needed for the properties to be independent of time periods, i.e. mean, variance etc are constant over time. In R stationarity can be checked by Augmented-Dickey Fuller (adf) and/or Kwiatkowski-Phillips-Schmidt-Shin (kpss.test) tests.
In more details, macroKZ can use sapply function to view which parameter is stationary or not.
If dataset, as a whole, or individual parameters are non-stationary, it is recommended to apply transformation techniques to make data stationary. Most common transformation tools are differencing (first and second order), logarithming, difference of logarithms, detrending and etc. After transformation method(s) is applied, make sure that data is stationary.
To build the best regression model regressors/independent variables need to be independent of each other. If this condition is violated, multicollinearity presents and regression estimators are biased. AFR package offers corsel function that estimates correlation between regressors in the dataset given a threshold (set by the user). The result can be presented numerically or logically (TRUE/FALSE).
Once regressors are chosen, linear regression model can be built via lm function.