Review Article
Time Series Modeling of Monthly Production of Eva Water in Nigerian Bottling Company, Owerri Plant
Imah Isaiah1*, Annastecia C Egwuekwe1, Kelechukwu CN Dozie1, Stephen O Ihekuna1 and Glory C Nwagwu2
11Department of Statistics, Imo State University, Owerri, Imo State, Nigeria
22Department of Statistics, Kingsley Ozumsba Mbadiwe University, Ideato, Imo State, Nigeria
Imah Isaiah, Department of Statistics, Imo State University, Owerri, Imo State, Nigeria
Received Date: February 17, 2026; Published Date: April 15, 2026
Abstract
This paper discusses time series modeling of monthly production of Eva water in Nigerian bottling company, Owerri plant. The method adopted is Buys-Ballot procedure for time series decomposition. The ultimate objective of this study is therefore is to choose the appropriate model for decomposition of the study data. Specific objectives are to: (1) review the Buys-Ballot procedure for this series decomposition. (2) estimate the trend parameters and seasonal indices. The method is developed to, among other things, choose of appropriate model for decomposition of study data based on row, column and overall means and variances. This research is restricted to time series with linear trend that admits the additive model using registered monthly production volume of Eva water in Nigerian bottling company over a period January, 2009 to December 2023. Result indicates that variance is constant and the transformed series admits additive model. This further confirmed that the appropriate model of original series is additive. There is need that the choice of appropriate model may be affected by violation of underlying assumptions, hence, it is recommended that a study data should be evaluated for the assumptions of time series model before choosing the suitable model.
Keywords:Buys-Ballot table; Time series decomposition; Choice of model; Linear trend; Modal structure
Introduction
Identification of pattern and choice of model in time series data is critical for forecasting purposes. Two patterns that may be presented are trend and seasonality and the two competing models are the additive and multiplicative models. Hence, Iwueze and Nwogu (2014) suggested in their framework for choice of model based on row, column and overall averages and variances of the data arranged in a Buys-Ballot table the test of the hypothesis that the column variances are constant for additive model otherwise multiplicative model or mixed model. In time series, it is assumed that the data consist of observations made sequentially in time; a systematic pattern (usually a set of identifiable components) and random noise (error). The systematic pattern includes the trend (denoted as), seasonal (denoted as) and the cyclical (denoted as) components. The random noise (or error, irregular component) is denoted as or, where t stands for the particular point in time. These four classes of time series components may or may not coexist in real-life data. These components can adopt different specific functional relationship. They can be combined in an additive (additive seasonality) or a multiplicative (multiplicative seasonality) fashion and can as well take other forms such as pseudo-additive/mixed (combining the elements of both the additive and multiplicative models) model.
The Additive model, Multiplicative model and Pseudo-Additive/ Mixed Model are given in Equations (1.1) -(1.3) respectively:



Cyclical variation which refers to the long-term oscillation or swings about the trend appears to an appreciable magnitude only in long period sets of data.
However, if short period of time is involved, the cyclical component is superimposed into the trend (Chatfield [1]). In this case Equations (1) - (3), can respectively, be written as:



Where Mt is the trend-cycle component, St is the seasonal
component with the property
and t I is
the irregular component? For equation (4), it is convenient to make
assumption that the sum of the seasonal component over a complete
period is zero, ie.,

Similarly, for equations (5) and (6), the convenient variant assumption is the sum of the seasonal component over a complete period is s .

It is equally assumed that the irregular component It is the
Gaussian
white noise for equations (4) and (6), while
for equation (5), t I is the Gaussian
white noise and that
.
On the most appropriate condition to use any of three models, many scholars have proposed different approaches. Chatfield [1] proposed the use of the time plot to choose between additive and multiplicative models. However, they did not provide any statistical test to justify the use. Iwueze and Nwogu [2] proposed the framework for choice of model and detection of seasonal indices in time series, showed that when the trend cycle component is linear, the seasonal indices for the multiplicative model. Therefore, choice between additive and multiplicative models reduces to test for constant variance which can be used to identify the additive model. Therefore, they suggested that any test of constant variance can be used to identify the test that admits the additive model. This is an improvement over what is in existence. However, this approach can only identify the additive model when the column variance is constant, but does not tell the analyst the alternative model when the variance is not constant.
Linde [3] stated that the seasonal variation is independent of the absolute level of the time series and its amplitude is relatively close for additive model. While in a multiplicative model, the amplitude of the seasonal factor varies with level of the time series. In an additive model, the seasonal effect is the same in the same period over different years. When the seasonal effect is a proportion of the underlying trend, the multiplicative model is used. No statistical test was provided for the choice. Nwogu, et al [4] and Dozie, et al [5] established Chi-Square test based on the seasonal variances of the Buys-Ballot table. The test has been theoretically verified to be quite successful and efficient for choice between mixed and multiplicative models in time series analysis. Iwueze et al [6] summarized the Buys-Ballot procedure called the Buys-Ballot table. A Buys-Ballot table summarizes data to show seasonal variations.
Each line in the table is one period (usually a year) and each
column is a season of the period/year (4 quarters, 12 months, etc).
A cell (i, j) , of this table contain the mean value of all observations
made during the period i at the season j . To analyze the data, it is
helpful to include the period and seasonal totals (Ti and Tj ) , period
and seasonal average
period and seasonal standard deviations
, as part of the Buys-Ballot table. Also included
for purposes of analysis are the grand total (T.. ), grand mean
.and pooled standard deviation
(see Table 1). According to Wei
[7], the arrangement of data in this manner in table is credited to
Buys-Ballot; hence, the table has been called the Buys-Ballot table
in the literature. Buys-Ballot is used to estimate the trend component
and seasonal indices from the chosen descriptive time series
model. According to Dozie [8], Buys Ballot procedure is computationally
simple when compared with other descriptive methods.
The values of the estimated trend parameters and seasonal indices
are easily computed in the mixed model in time series. Iwueze
and Nwogu [2] proposed the Buys-Ballot estimation procedure and
for the periodic means
and the overall mean
to estimate the trend component. Seasonal means
and the overall mean are used to estimate the seasonal indices. This
research is restricted to time series with linear trend that admits
the additive model using registered monthly production volume of
Eva water in Nigerian bottling company over a period January, 2009
to December 2023. Therefore, the ultimate objective of this study is
to identify the appropriate model for decomposition of the study
data. The specific objectives are to: (a) review the Buys-Ballot table
for seasonal time series. for in time series. (b) estimate the trend
parameter and seasonal indices. This work contributes to the many
existing solution of the problem of choosing the appropriate model
among the three time series models
Methodology
The methods adopted in this study is the Buys-Ballot procedure developed for choice of model for decomposition of any study series, estimation of trend parameters and seasonal indices and choice of appropriate transformation based on the row, column and overall means and variances, For details of Buys-Ballot procedure for time series decomposition see Wei [8], Iwueze and Nwogu [2], Nwogu et al [4], Dozie [8], Dozie and Uwaezuoke [9], Dozie et al [5], Dozie and Ijeoma [10], Dozie and Nwanya [11], Dozie and Ihekuna [12], Dozie and Ibebuogu [13], Dozie and Ibebuogu [14], Dozie and Uwaezuoke [15], Dozie and Ihekuna [16], Dozie and Ihekuna [17], Dozie [18], Dozie and Uwaezuoke [19] and Dozie [20]. Review of Buys-Ballot Procedure for Time Series Decomposition is contained in section 2.1. Section 2.2 contains Estimation of Trend Parameters and Seasonal Indices. While section 2.3 is Test for Constant Variance (Table 1).
Table 1:Collected country level data and sources.

Where s = number of seasons, m = number of periods and n = ms = number of observations.
Review of Buys-Ballot Procedure for Time Series Decomposition
Iwueze and Nwogu (2014) observed that the rows (periods) and column (seasons), with m and s representing the number of periods/years and seasons/columns respectively. This two-dimensional arrangement of a series is referred as the Buys-Ballot table.
Estimation of Trend Parameters and Seasonal Indices
Iwueze and Nwogu (2014) proposed the estimation of the trend parameters and seasonal indices for a linear trend and additive model as:




1.1. Levene’s Test for Constant Variance
The Levene’s test statistic for the null hypothesis

for at least one i ≠ j is defined as

where k is the number of different groups, Ni is the number of cases in the ith group, Yij is the value of the jth observation in the ith group.
zij may be defined as deviation of yij from the mean
or from the median (yi ) . That is


The test statistic W approximately follows the F-distribution with k −1 and N − K degree of freedom. To suit the Buys-Ballot procedure, the levene’s test statistic is modified with N = ms, k = s Ni = m as;

Empirical Example
The real-life example is based on monthly data on number of eva water production for a period of January, 2007 to December 2023 shown in appendix A. While the time plots of original and transformed series given Figure 1&2 respectively. As Figure 1&2 indicate, the time series is seasonal with no evidence of upward or downward trends. The yearly and seasonal standard deviations are both stable, suggesting that the seasonal indices may be additive. Results from Estimation of Trend Parameters and Seasonal Indices are discussed in Section 3.1. Section 3.2 presents the Choice of Appropriate Model. While Section 4 is the Concluding Remarks.


Results from Estimation of Trend Parameters and Seasonal Indices
Using (10), (11) and (12), we obtain


Table 2:Estimated Seasonal Indices.

Choice of Appropriate Model
To choose the appropriate model for decomposition of the study series. The first step is to check if the data admits additive model. The Levene’s test is used to test the null hypothesis ( Ho ) that all variances are equal (it admits additive model) against the alternative ( H1 ) that at least one differs. The null hypothesis is rejected if the calculated test statistic (W = 0.151) greater than the tabulated value (F0.05,11,168 =1.846 ) with α = 0.05 otherwise it wouldn’t be rejected.
Table 3:The absolute value of the difference between observed values and seasonal means of the actual data
.

Table 4:Calculation of

Table 5:Calculation of


When compared, the test statistic is less than the critical value, indicating that the model for decomposition is additive. Having confirmed that the decomposition model is additive. There is still need to transform data to meet the time series assumptions, that is, the constant variance and normality assumptions in the distribution. When the transformed data listed in 8 is subjected to test for constant variance, the test statistic (W = 0.351) is less than critical value (F0.05,11,168 =1.846 ) at 5% level of significant. Hence, transformed data accepts additive model.
From Appendix B and (Table 6-8): we have
.
Table 6:The absolute value of the difference between observed values and seasonal means of the transformed data

Table 7:Calculation of

Table 8:

Critical value:

Concluding Remarks
This paper has discussed time series modeling of monthly production of eva water in Nigerian bottling company, Owerri plant. The method adopted is Buys-Ballot procedure for time series decomposition. The method is developed to, among other things, choose of appropriate model for decomposition of study data bases row, column and overall means and variances. Therefore, the ultimate objective is to determine the appropriate model for decomposition of the study data. The specific objectives are to: (a) review the Buys-Ballot procedure for seasonal time series. (b) estimate trend parameters and seasonal indices. Result indicates that variance is constant and the transformed series admits additive model. This further confirmed that the appropriate model of original series is additive. There is need that the choice of appropriate model may be affected by violation of underlying assumptions, hence, it is recommended that a study data should be evaluated for the assumptions of time series model before choosing the suitable model.
References
- Chatfield C (2004) The Analysis of Time Series: An Introduction 6th Edition, Chapman and Hall London.
- Iwueze IS, Nwogu EC (2014) Frame Work for Choice of Models and Detection of Seasonal Effect in Time Series. Far East Journal of Theoretical Statistics 48(1): 45-66.
- Linde P (2005) Seasonal Adjustment, Statistics Denmark.
- Nwogu EC, Iwueze IS, Dozie KCN, Mbachu HI (2019) Choice between Mixed and Multiplicative Models in Time Series Decomposition. Asian Journal of Statistics and Application 9(5): 153-159.
- Dozie KCN, Nwogu EC, Ijomah MA (2020) Effect of Missing Observations on Buys-Ballot Estimates of Time Series Components. Asian Journal of Probability and Statistics 6(3): 13-24.
- Iwueze IS, Nwogu EC, Ohakwe J, Ajarogu JC (2011) Uses of the Buys-Ballot table in Time Series Analysis. Applied Mathematics.
- Wei WWS (1989) Time Series Analysis: Univariate and Multivariate Methods, Addison-Wesley, Redwood city 33(1).
- Dozie Kelechukwu CN (2020) Buys-Ballot Estimates for Mixed Model in Descriptive Time Series. International Journal of Theoretical and Mathematical Physics 10(1): 22-27.
- Dozie KCN, Uwaezuoke MU (2020) Properties of Buys-Ballot Estimates for Mixed Model in Time Series Decomposition. Galore International Journal of Applied Sciences and Humanities 4(2): 35-40.
- Dozie KCN, Ijomah MA (2020) A Comparative Study on Additive and Mixed Models in Descriptive Time Series. American Journal of Mathematical and Computer Modelling 5(1): 12-17.
- Dozie KCN, Nwanya JCN (2020) Comparison of Mixed and Multiplicative Models when Trend-Cycle Component is Linear. Asian Journal of Advanced Research and Reports 12(4): 32-42.
- Dozie KCN, Ihekuna SO (2020) Buys-Ballot Estimates of Quadratic Trend Component and Seasonal Indices and Effect of Incomplete Data in Time Series. International Journal of Science and Healthcare Research 5(2): 341-348.
- Dozie KCN, Ibebuogu CC (2020) Estimates of Time Series Components of Road Traffic Accidents and Effect of Incomplete Observations: Mixed Model CASE. International Journal of Research and Review 7(6): 343-351.
- Dozie KCN, Ibebuogu CC (2021) Road Traffic Offences in Nigeria: An Empirical Analysis using Buys-Ballot Approach. Asian Journal of Probability and Statistics 12(1): 68-78.
- Dozie KCN, Uwaezuoke MU (2021) Seasonal Analysis of Average Monthly Exchange Rate of Central Bank of Nigeria (CBN) when Trend Cycle Component is Quadratic. International Journal of Research and Innovation in Applied Science (IJRIAS) 6(2): 201-205.
- Dozie KCN, Ihekuna SO (2022) Additive Seasonality in Time Series using Row and Overall Sample Variances of the Buys-Ballot Table. Asian Journal of Probability and Statistics 18(3): 1-9.
- Dozie KCN, Ihekuna SO (2023) The Effect of Missing Data on Estimates of Exponential Trend-Cycle and Seasonal Components in Time Series: Additive Case. Asian Journal Probability and Statistics 24(1): 22-36.
- Dozie KCN (2023) Buys-Ballot Estimates for Overall Sample Variances and Their Statistical Properties. Asian Journal of Advanced Research and Reports 17(10): 213-223.
- Dozie KCN, Uwaezuoke MU (2023) The Proposed Buys-Ballot Estimates for Multiplicative Model with Error Variances. Journal of Engineering Research and Reports 25(8): 94-106.
- Dozie KCN (2024) Assessing Performance of Estimation Techniques in Time Series Analysis when Trend-Cycle Component is Linear. Asian Journal of Research in Computer Science 17(12): 18-29.
-
Imah Isaiah*, Annastecia C Egwuekwe, Kelechukwu CN Dozie, Stephen O Ihekuna and Glory C Nwagwu, Time Series Modeling of Monthly Production of Eva Water in Nigerian Bottling Company, Owerri Plant. Annal Biostat & Biomed Appli. 7(2): 2026. ABBA.MS.ID.000658/
Buys-Ballot table; Time series decomposition; Choice of model; Linear trend; Modal structure; iris publishers; iris publisher’s group
-

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.






