Network Traffic Modeling: Constant Volatility

This post aims at explaining the usage of statistical modeling of time series data for the trending of network traffic data. The network traffic data being used for analysis has been obtained from here. These are basically logs of a busy web-server for a single day.

131.170.154.29 [30:00:00:05] "GET /logos/small_gopher.gif HTTP/1.0" 200 935
131.170.154.29 [30:00:00:06] "GET /logos/small_ftp.gif HTTP/1.0" 200 124
port11.annex1.naples.net [30:00:00:06] "GET /icons/ok2-0.gif HTTP/1.0" 200 231
131.170.154.29 [30:00:00:09] "GET /logos/us-flag.gif HTTP/1.0" 200 2788
131.170.154.29 [30:00:00:17] "GET /icons/ok2-0.gif HTTP/1.0" 200 231

This data is parsed using a python script to accumulate the number of bytes received in a 2 minute window and the following time series plot is obtained.There are no observable patterns evident to the naked eye, except a linear rising trend between 200 to 350 and similar linear decreasing trend after that.

There is an obvious outlier data, these outliers are important when we talking about simulating network traffic as the design under consideration should be able to handle the peak load. But as far as trending is concerned these outliers must be filtered out.

Here is a plot with the outliers filtered:

Before we try to fit the above series into a mathematical formula, we will discuss some of the basics required.

Autocorrelation

This is a measure of how much is a current value x_t correlated or similar with lagged values in time, x_{t-1}, x_{t-2}, x_{t-3} \hdots . In mathematical terms this autocorrelation can be expressed as (E is the expected value operator).

ACF(h,t) = \frac{E[(X_t - \mu)(X_{t -h} - \mu)]}{\sigma^2}

Note that this assumes that the series is weakly stationary:

  • Mean of the series E(x_t) stays constant with t
  • Variance remains constant with t
  • And the correlation between x_t and x_{t - h} does not vary with t

Autoregressive Models

This statistical model suggests that the present value of a variable x_t is a linear function of the previous values.

An AR(1) (Autoregressive model of order 1) can be represented as:

x_t = \delta + \phi_1x_{t-1} + w_t

A general auto-regressive model can be written as:

x_t = \delta + \sum_{i = 0}^{n}  \phi_ix_{t-i} + w_t

The constants \phi_1, \phi_2, \phi_3 \hdots are the autoregressive coefficients and $w_t &s=1$ is a random variable normally distributed with constant variance. This signifies that errors have no correlation with the value.

We will discuss some properties of the AR(1) model:

Mean:

The mean of the time series represented by the AR(1) model can be calculated as follows:

E(x_t) = E(\delta + \phi_1x_{t-1} + w_t)

E(w_t) = 0\ (random\ variable\ with\ \mu = 0)

With the assumption that the series is stationary we have:

E(x_t) = E(x_{t-1}) = \mu

On solving for μ we get:

\mu = \frac{\delta}{1 - \phi_1}

Variance:

Var(x_t) = Var(\delta) + Var(\phi_1x_{t-1}) + Var(w_t)

Var(x_t) = Var(\delta) +\phi_1^2Var(x_{t-1}) + Var(w_t)

Again we use the assumption that the series is stationary which gives:

Var(x_t) = Var(x_{t-1}) = \sigma_t

On solving we get:

\sigma_t = \frac{\sigma_w^2}{1 - \phi_1^2}

Autocorrelation function (ACF):

We assume the mean of the data to be 0. This happens when δ = 0. The value of variances, covariances and correlations are not affected by the specific value of the mean.

Let \gamma_h be the covariance with a lag of h. \rho_h be the corresponding correlation.

Covariance and correlations between observation 1 time period apart

\gamma_1 = E(x_tx_{t+1}) = E(x_t(\phi_1x_t + w_{t+1})) = E(\phi_1x_t^2 + x_tw_{t+1}) = \phi_1Var(x_t)

\rho_1 = \frac{Covar(x_tx_{t+1})}{Var(x)} = \frac{\phi_1Var(x_t)}{Var(x_t)} = \phi_1

Covariance of observations h time periods apart:

\gamma_h = E(x_{t-h}x_t)

E(x_{t - h}x_t) = E(x_tx_{t-h} + \phi_1x_{t-1}x_{t-h} + w_tx_{t-h})

E(x_{t - h}x_t) = E(\phi_1x_{t-1}x{t-h}) = \phi_1\gamma_{h-1}

So,  \rho_h = \phi^h, Thus the ACF function decreases exponentially when plotted versus the lag h.

Autocorrelation plot for an AR(1) model with \phi_1 = 0.6 . The graph tails off exponentially with the lag value but has some perturbations. These are due to sampling errors (number of samples for the current graph are 1000). The graph tends to the expected ideal when the number of samples are increased.

Moving Average Models.

In these models the shock/error from the previous observations is propagated as the series progresses.

1st order MA model or MA(1)

x_t = \mu + w_t +\theta_1w_{t-1}

General MA model

x_t = \mu + w_t +\theta_1w_{t-1}+\theta_2w_{t-2}+\dots + \theta_1w_{t-q}

We shall now discuss the properties of Moving average model of order 1

Mean

E(\mu + w_t +\theta_1w_{t-1}) = \mu

Variance

Var(\mu) + Var(w_t) + Var(\theta_1w_{t-1})

\sigma = \sigma_w(1 + \theta_1^2)

Autocorrelation function(ACF):

As previously defined, we first calculate the covariance value of observations h time period apart:

E[(w_t + \theta_1w_{t-1})(w_{t-h}+\theta_1w_{t-h-1})] =

E[w_tw_{t-h} + \theta_1w_{t-1}w_{t-h} +\theta_1w_tw_{t-h-1}+\theta^2_1 w_{t-1}w_{t-h-1}]

When h = 1, the above equations yields \theta_1\sigma_w^2, that is because the condition of an independent random variable is:

i\not=j ;\ E(w_jw_i) = 0

And also, as the mean of the random variable is zero the expected value E(w_i^2) = \sigma_w^2 .  Therefore the ACF shows peak = \theta_1 when h = 1 and is zero for other lags.

The ACF function for a Moving average model of order one
(\theta_1 = 0.7, samples = 10000) is shown below.

(Do not get confused by the unity value at lag 0. An observation is obviously expected to be perfectly correlated with itself)

Partial Autocorrelation Function (PACF)

This function is measures the conditional correlation between observations, given certain conditions and characteristics are accounted for. Think about how regression models are interpreted. Consider the two models:

y = \beta_0 + \beta_1x^2

y = \beta_0 + \beta_1x + \beta_2x^2

In the first model \beta_1 represents the linear dependency between y\ and x^2 . In the second model, \beta_2 represents the linear dependency between y and x² with the dependency for x already accounted for. We all know that these two coefficients will not be same.

In general a PACF of order h can be represented as a conditional correlation between x_t\ and\ x_{t-h} , conditional on the observations lying between t and t – h. This means that these observations have already been accounted for.

Consider a third order PACF:

\frac{Covariance(x_t, x_{t-3}| x_{t-1}, x_{t-2})}{\sqrt{Variance(x_t|x_{t-1},x_{t-2})Variance(x_{t-3}|x_{t-1},x_{t-2})}}

Statistical Implications of PACF

For an AR model, PACF negates or shuts off after the order of the function, It means that for an AR model of order two, the PACF will have two spikes and turn off after that (practically have small perturbations that are insignificant). This is evident in the PACF plot for the model:

x_t = 0.3x_{t-1} + 0.4x_{t-2} +w_t

The same is not the case for an MA model, instead of shutting off the PACF tapers to zero.  Consider the PACF for the model

x_t = 0.2w_{t-1} + 0.4w_{t-2}

Both ACF and PACF help us understand the nature of the series and also in choosing the correct model for the same.

Network Traffic Model

Now that  we have understood the basics, we can leverage the same in the modeling of network traffic data that was discussed in the beginning. The first step is to plot the autocorrelation function for the data.

The dotted red lines show a significance level for the correlation values. The above plot shows that all the values are correlated significantly. This hints at a trend in the series. The overall trend masks the correlations of the actual perturbations. For us to model the data correctly we need to de-trend it. The first step is to remove any linear trends by first difference of the series:

x_t = x_t - x_{t-1}

This is how the series looks after the first difference:

Now we Plot the ACF for the above series and see whether we have been successful in removing the trend component of the correlation.

This shows a very large peak for unity lag and below significance values for the rest of the lags. This hints at an MA(1) model for. But we should also look at the PACF function in order to detect any auto-regressive nature in the data. Here is an output of the PACF for the first difference series.

The PACF output shows positive conditional correlations till a lag value of 9, but the first two correlations are significantly larger than the rest by a factor of about 50%. Thus we will model our first difference series with ARMA(2,1).

    blue:     Actual series

orange :  Fitted data

The model can be written using the calculated coefficients as:

N_t = -0.0005N_{t-1} + 0.1116N_{t-2} - 0.9348w_{t-1} + w_t

After the data is fitted into the model, we should also investigate into the nature of the residuals. A residual is defined as the deviation of the fitted data from the actual data. For a model to be feasible, the residuals should not have any significant correlation. Here is the ACF plot for the residuals for our model:

In the above ACF plot we see that there is no significant correlation between the residuals, which is a sign of a good fit. The histogram of residuals show that they are lognormally distributed, this statistic is important from a future prediction perspective.

Possible improvements

  • Accounting for seasonal variations: The network traffic patterns tend to depend on various parameters like time of the day/year/month. For example a payroll website is more likely to receive data at the end of the month. These variations/characteristics can be accounted for by using seasonal models.
  • Variable Volatility: We have assumed constant volatility for our model, but due to the highly fluxed and spiked nature of the network traffic data, better results can be obtained by accounting for changes in the volatility.

The graphs and analysis has been done using R. Feel free to ask questions on how the same was implemented.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s