Next Article in Journal
Forecasting the Monkeypox Outbreak Using ARIMA, Prophet, NeuralProphet, and LSTM Models in the United States
Previous Article in Journal
Machine Learning Models and Intra-Daily Market Information for the Prediction of Italian Electricity Prices
 
 
Font Type:
Arial Georgia Verdana
Font Size:
Aa Aa Aa
Line Spacing:
Column Width:
Background:
Article

Spatial Dependence of Average Prices for Product Categories and Its Change over Time: Evidence from Daily Data

1
Institute of Economics, Finance and Business, Ufa University of Science and Technology, Ufa 450076, Russia
2
Institute of Business Ecosystems and Creative Industries, Ufa State Petroleum Technological University, Ufa 450064, Russia
*
Author to whom correspondence should be addressed.
Forecasting 2023, 5(1), 102-126; https://doi.org/10.3390/forecast5010004
Submission received: 16 November 2022 / Revised: 23 December 2022 / Accepted: 28 December 2022 / Published: 31 December 2022
(This article belongs to the Section Forecasting in Economics and Management)

Abstract

:
The price of market products is the result of the interaction of supply and demand. However, within the same country, prices can vary significantly, especially during crisis periods. The purpose of this study is to identify patterns in the changing spatial dependence of the prices of certain product categories, namely pasta, potatoes, sugar, candies, poultry and butter. We used daily data from 1 January 2019, to 31 March 2022, and analyzed two important indicators: spatial variation and spatial autocorrelation of average daily prices. The analysis showed that spatial dependency changes over time and follows its own pattern for each product category. We recognized cyclic changes in spatial autocorrelation and noticed the effect of legislative restrictions on spatial correlations. It has been shown that the spatial variation of prices and spatial autocorrelation can change in different directions.

1. Introduction

The increasing availability of Big Data changes the current approach for estimating price indexes [1,2]. New technologies affect the growing expectations of users in relation to price statistics [3]. New types of data come to replace the survey and census responses: scanner data on purchases, credit card transaction records, the prices of various goods scraped from the websites, etc. [4,5]. The current trend is Big Data. On the one hand, the high potential importance of Big Data is obvious [6]; on the other hand, there are always certain risks and limitations [7]. The relevance of further research is determined by the need to unveil the thus far hidden patterns to predict price changes and determine ways to eliminate restrictions and limitations. The measurement of prices is an important area of research in economics, since prices play a central role in welfare analysis and macroeconomic comparisons across time and space [8].
An important aspect of the Big Data is its geographical structure, which allows studying price changes in time and space simultaneously. Already in the middle of the last century, the concept of the spatial price equilibrium was proposed [9]. The interest in studying spatial price relationships, including territorial price differentiation and territorial convergence, has been growing since then. Currently, the spatial price relationships are actual relationships and are studied all over the world: in Africa [10], India [11], China [12], USA [3], EU countries [13,14,15], etc. In Russia, researchers are also studying the spatial distribution of prices and regional price differentiation [16,17] and spatial autocorrelation of prices [18,19,20,21].
This interest in the analysis of spatial dependencies has obvious origins: spatial analysis allows identifying the limitations of regional cohesion [22,23] to assess shock propagations [24] and to ensure the targeting of measures to ensure public food security [25,26]. We believe the understanding of regional price differences is essential for basket-of-goods comparability, more accurate estimation of regional price parities (RPPs) and studies of regional differences in standards of living [3,27]. Researchers underline the importance of account for price differences when assessing regional economic disparities [8]. When neglecting these issues, one may obtain misleading results [23].
In recent years, analysis of the spatial dependence of prices is carried out more and more often on microdata, readily available from a range of sources. Some researchers use scanner data referring to products sold to construct sub-national spatial price indexes [2] and analyze spatial differences in price levels between regions and cities [15]. The others collect online prices from the websites of selected retailers to determine differences between cities in one country [3]. Georeferenced price data may be available from specialized databases [23,28] or collected from active volunteers through mobile phone data collection apps [26]. We can only derive precise and effective economical solutions for separate territories at a specific time when the primary data are well detailed and georeferenced. The data aggregated monthly and at national or sub-national levels only can not guide rapid and context-specific intervention(s) to shocks, since they provide time-lagged information already from the beginning [26]. Microdata have no such limitations and might be used for near real-time monitoring of local areas.
The studies of spatial dependencies show different patterns In different parts of the country with various statistical significance. Consumer price difference is considered greater between territories located further apart. As a result, spatial correlation between such territories would be lower, while spatial price indexes for neighboring areas may show similar patterns [14,19]. The price level for food products falls with city size [28]. The price level is high in regions that are more expensive, and it changes gradually as one travels from inexpensive to expensive regions [23]. There might also be different spatial trends of prices in different parts of the countries. The classification of Northern/Southern/Eastern/Western regions is well known and well studied [2,12,20,23,25]. The speed of price changes can also vary significantly in regions [18], especially under economic shocks and during crisis periods [20,21,26]. Further, each country may have its own characteristics, including the level of price dispersion [15].
At the same time, there are also product differences. Price growth rates are different for different groups of products [3,11,26,29,30]. It is highly important to understand the features of a particular group of products and its pricing process. There are goods for which a deterministic seasonal pattern in sales is prominent, while the seasonality for other products is stochastic and characterized by a pattern of recurring spikes and dips [30]. The cyclic behavior of prices might be caused by various factors. The frequency of harvest affects price variation for fresh products [3], and different weather shocks might increase this price variability even further [31]. Another regular seasonal component corresponds to the time of the year [30]. Relatively significant change in the regional price structure is marked during the last week of December [15] not only because certain products are sold mostly at Christmas time, but also due to the large population movements during holidays that change the geographical structure of the markets [15]. Some researchers pay attention to the existence of price variations by day of the week [29]. These changes are probably caused by consumer tendencies to go shopping on certain days (weekends, Mondays and Fridays). The retailers, in response, might propose offers and promotions on the other days that are less busy [29]. Therefore, the prices might change cyclically. These spatial correlations are thus far poorly understood and studied. The focus is now primarily on spatial variety in the magnitudes of seasonality and seasonal gaps across space [32]. It is considered that strong seasonal patterns are highly heterogeneous in the product and spatial dimensions [33]. However, some cyclical components indicate that the actions and ’feelings’ of consumers from different territories are aligned [33]. The previous studies have proven that spatial dependencies are not static, but rather dynamic [20,25]. There exists a strict correlation between price spikes and peaks in spatial price variability [24]. The presence of inter-regional dependence and correlation in prices in India was already registered [34]. However, these processes are poorly studied. Mostly such changes are recorded on aggregated data (by years or months). The least studied are weekly and daily changes in spatial relationships.
The spatial relations of price changes in regions of the Russian Federation deserve more attention as well. Most of the research work is based so far on general price indexes, without revealing the characteristics of individual groups of products. The researchers use primarily monthly or yearly data, providing very little, if any, information on the actual rate of spatial price change. The seasonality of spatial price changes is practically ignored in the research. The accumulation of fiscal data from cash registers and its availability to the researchers expands the possibilities for a deeper study of these trends all over the world and in Russia in particular, among the largest countries in terms of area.
This study’s purpose is to identify patterns in the change in the spatial dependence of the prices of some important product categories, such as potatoes, sugar, butter, poultry meat, pasta and candies. These categories are referred to as Potatoes, Sugar, Butter, Poultry meat, Pasta and Candies in this paper. We used the data on prices and sales volumes of respective products in the regions according to the data of cash registers, which is placed in the public domain by the Federal Tax Service. The choice of the object of study is explained by the following: first of all, the use of Big Data is an important trend in statistics and research today. Our data from cash registers certainly characterize actual demand prices best. Secondly, we expect to obtain correct and statistically significant estimates since the daily data are available for a period of more than three years (from Jan 2019 until March 2022). Thirdly, for the purpose of this study, we have chosen a set of socially important products, for which the price changes are closely monitored by the state and local authorities. Finally, the prices of these products fluctuate seasonally for different reasons; this may also affect the resulting estimates of their spatial dependence.
The remaining paper has the following structure: In Section 2, we present the dataset used and the proposed methodology in detail. Section 3 is devoted to the empirical results. Discussion is presented in Section 4. Finally, the conclusions are in Section 5.

2. Materials and Methods

2.1. Data Sources

All data used in the research are in public domain and available from the Federal Tax Service of the Russian Federation (https://www.nalog.gov.ru/opendata/) (accessed on 15 November 2022).
Under current legislation, all purchase information is sent to the Federal Tax Service via fiscal data operators. Due to its nature, the data are not used to estimate the consumer price index today, but serve as an alternative view of price dynamics. Traditionally, the specialists of the territorial bodies of the Federal State Statistics Service “register” the prices displayed in store in order to calculate consumer price index, whereas the data from the Federal Tax Service were obtained through processing the primary information on operations at cash registers upon purchase. These are two different approaches to register prices. As in many other countries, the official statistical prices in Russia are collected at outlets as displayed in store [29]. They differ from the prices provided by cash registers (actually paid by the consumer at the time of purchase) and could also be referred to as demand prices [35]. Such transactions data are distinctly different from official price indexes that are survey based [33]. Prices may vary due to display errors by the store, survey errors when collecting data in store or because of checkout promotions [29]. We assume that the average prices of products from our dataset might also reflect the consumer sentiments to some extent. Some people tend to purchase products/brands that are more expensive on the eve of important holidays, or simply after a rise in their income. The average prices of products sold in certain categories would also increase as a result, even if prices for specific brands of products remain unchanged for this particular category.
In this study, we analyze prices of six different product categories (Potatoes, Sugar, Butter, Poultry meat, Pasta and Candies) from the period from 1 January 2019, until 31 March 2022, (1186 days) in 83 regions of the Russian Federation (Table 1).
The panel data were not complete. Data for regions for certain periods were missing, mostly the data for 1 January. The absolute minimal sample size is registered for Potatoes on 1 January 2020, and represents 77 regions. As for product categories, the least number of missing values is registered for Candies. However, given the daily basis of data, this fact, in our view, did not impact the coherence and stability of the results.

2.2. Spatial Analysis Method and Study Design

There are different approaches for spatial prices analyses. The first implies the calculation of spatial heterogeneity in prices. One typical measure of regional price disparities is the coefficient of variation (CV) [8,23,27,28,34]. There are, however, several more options for deeper analysis since the price data are georeferenced [3]. For example, the estimation of the seasonal variation using the monthly average price and the calculation of the spatial variation based on the average market prices [25]. Since we noticed the variability of the variation of prices in time, we estimated the total variation for all markets for the whole period, as well as spatial price variation for each day of the analyzed period. Another approach considers the relative position of territories, focusing on the similarity and difference in prices among neighbors. There exist different indexes and models to describe the prices of a territory in correlation with the prices of neighboring areas [14,25,27]. Probably, the most famous and widely used is the Moran’s I index [12,20,21,23,27].
The study design was therefore based on both approaches. First, we calculated the total variation for all markets for the whole period and spatial price variation for each day. After that, we estimated respective Moran’s I indexes to assess the spatial autocorrelation. The seasonality of spatial data was analyzed at last.
The coefficients of variation and Moran’s I indexes were calculated as presented in Equations (1) and (2), respectively.
C V t = 1 n ( A P i t A P t ¯ ) 2 A P t ¯
where APit is the average price, by index of region i and day t, and A P t ¯ is the average price for the day t for all regions,
M o r a n I t = N i j w i j i j w i j ( A P i t A P t ¯ ) ( A P j t A P t ¯ ) i ( A P i t A P t ¯ ) 2 ,
where N is the number of regions and wij is the elements of spatial weight matrix for regions i and j.
Two types of spatial weight matrices were used: a binary contiguity spatial weights matrix and an inverse distance weights matrix. In both cases, only the first-order neighbors were included. The values of binary contiguity spatial weights matrix ( w i j b ) are defined by the following:
w i j b = 1 ,   i f   t h e r e s   i s   a   c o m m o n   b o r d e r   b e t w e e n   r e g i o n s   i   a n d   j ; 0 ,   i f   i = j ; 0 ,   i f   t h e r e s   i s   n o   c o m m o n   b o r d e r   b e t w e e n   r e g i o n s   i   a n d   j .
However, regardless of the actual borders between regions, we consider the Sakhalin region as a neighbor to the Primorsky, Khabarovsk and Kamchatka regions. The same applies to the Kaliningrad region, with “neighboring” regions of Saint-Petersburg, Pskov and Smolensk. We recognize the last assumption as controversial, but it allows us to capture the Kaliningrad region in this study and analyze the entire territory as a whole, considering the fact of sea, auto routes, as well as railway connection between these territories. We weighted the values row wise during the calculation of the indexes.
The values of inverse distance spatial weight matrix ( w i j i d ) are defined by the following:
w i j i d = 1 / d ,   i f   t h e r e s   i s   a   c o m m o n   b o r d e r   b e t w e e n   r e g i o n s   i   a n d   j ; 0 ,   i f   i = j ; 0 ,   i f   t h e r e s   i s   n o   c o m m o n   b o r d e r   b e t w e e n   r e g i o n s   i   a n d   j .
where d is the auto route distance between main cities of respective regions.
We used the auto route distances on purpose since they provide better information on connectedness between regions by taking into account the geographical features of the landscape. For example, if we took the distance in a straight line between main cities of the Nenets Autonomous Okrug and the Yamalo-Nenets Autonomous Okrug, it would be approximately 600 km. However, given the geography of the area, the real distance between them by auto routes equals 4000 km, more than 6-fold larger than the straight-line distance.
Another assumption as for the spatial weights matrix is that all regions are considered to be connected by permanent auto routes. This is not applied, e.g., to Chukotsky Autonomous Okrug, the region with only airline and sea route connectedness to other regions. However, the region is not completely cut off from the rest of the country landwise: there are local trails and crossings that open in winter, when the rivers freeze. There were in total five distance values missing after calculation, all of them related to the above-mentioned Chukotsky Autonomous Okrug and the main cities of its neighbors. To fill these values we took the overall maximum distance value (4200 km).
To interpret the indicator, its value was taken relative to the expected level E(I) = −1/(N − 1). If the value of Moran’s I exceeds the expected level, there is a positive spatial autocorrelation meaning the dynamics of prices in neighboring regions is similar. Otherwise, the price indexes in the regions are negatively spatially autocorrelated. The values of Moran’s I close to the expected value indicate that the observations of prices in neighboring territories are random. To assess the statistical significance of the results, we used the Z-score and the corresponding pseudo p-values.
The dynamics of Moran’s I was also compared to the coefficient of variation and price dynamics.

2.3. Seasonality Analysis Methods

At this stage, we analyzed the seasonality of the spatial dependence.
In order to take the seasonality of the data into account, we analyzed the shape of the time series as well as both autocorrelation function (ACF) and partial autocorrelation function (PACF) graphs [36,37]. The ACF expresses the internal correlation between observations in a time series separated by different lags as a function of time lag, and the PACF describes the direct relationship between an observation and its lag. These indicators represent correlations of the residuals that remains after removing the effects, which are explained by the earlier lag(s). The ACF graph helps in choosing the appropriate values for the ordering of moving average terms and the PACF graph is useful for the autoregressive terms [38].
In addition, we conducted the most appropriate statistical tests, such as Welch’s ANOVA test, the Friedman Rank test, the QS test, Ollech and Webel’s combined seasonality test. The last test is based on both the QS test and Kruskal–Wallis test that are calculated on the residuals of auto-ARIMA without seasonality. For example, the seasonality is not rejected by Ollech and Webel’s test in a time series in case the p-value of the QS test is less than 0.01 or that of Kruskal–Wallis test is less than 0.002.
The analysis was carried in R by using ‘sf’, ‘spdep’, ‘ape’, ‘seastest’ and ‘tseries’ packages, as well as GeoDA software.

3. Results

3.1. Spatial Variation

The analysis showed that the regional variation in the price of Potatoes is higher than in other product categories (Table 2). The highest value of the coefficient of variation was 0.599 for Potatoes on 28 September 2019. The lowest value of the coefficient of variation (0.102) was registered for sugar on 24 February 2022.
Figure 1 shows that the dynamics of the average price varies significantly for the selected product categories. Spatial variation also varies across time. The most stable are the dynamics of prices for Butter. The range of the price for this category is the narrowest.

3.2. Spatial Autocorrelation

Moran’s Ib estimates for spatial autocorrelation are presented in Table 3. The highest Moran’s I value (0.88) was registered for Potatoes on 12 August 2021. The closest to its expected value Moran’s I (−0.006 for binary contiguity matrix and −0.027 for inverse distance weights matrix) was recorded for Sugar on 31 October 2020.
The estimates of Moran’s Ib (based on binary contiguity matrix) and Moran’s Iid (based on inverse distance weights matrix) are relatively close. For this reason, we present here the main results for the case with binary contiguity matrix only. The corresponding estimates for the inverse distance weights matrix could be found in Appendix A.
For most of categories, the Moran’s I values vary over a relatively wide range. We recognized in most categories a permanent pattern for Moran’s I to switch randomly from «low spatial autocorrelation levels» (Moran’s I < 0.3) to «high spatial autocorrelation levels» (Moran’s I > 0.6). The least concerned category is Pasta, for which the Moran’s Ib remained in the interval between 0.29 and 0.65.
For most of categories, the spatial dependence estimates were statistically significant (p-value < 0.05). However, for Sugar, it was not the case in the period from 30 October 2020, to 2 July (Figure 2 and Figure A1). The estimates were also insignificant for Sweets twice, on 24 February 2020, (p-value = 0.06) and on 22 May 2020, (p-value = 0.09).

3.3. Seasonality and Cycles in Spatial Autocorrelation

For some product categories, the change in the average price has a certain annual and weekly regularity. We also conducted seasonality tests to identify cycles in spatial autocorrelation (Table 4 and Table A1). The results show that Moran’s I values and the average prices change cyclically.
Most tests indicate the presence of weekly cycles in Moran’s Ib values for all categories, with the only exception of QS test for Potatoes (p-value = 0.13). The annual (for the period of 365.5 days) seasonality of Moran’s Ib values for Potatoes was revealed by all tests except the Friedman Rank test. The non-seasonality is not rejected for Potatoes by Kruskal–Wallis test either (p-value = 0.0096), but the p-value is relatively lower than those for other product categories (Table 4).
Test results for seasonality are similar in case of Morans’ Iid (based on inverse distance weights matrix). The only difference is that the annual seasonality of Moran’s Iid values for Potatoes was revealed by Welch’s ANOVA test, QS test, Ollech and Webel’s combined seasonality tests and rejected by the Friedman Rank test and the Kruskal–Wallis test (Table A1).
We underline that some inconsistency in test results is not a reason to reject the annual seasonality or weekly cycling hypothesis. Different statistical tests may not always lead to consistent results, due to differences in methodological framework [39]. For this reason, we decided not to rely on formal statistical tests only, but also applied another approach to analyze the seasonality.
To consider seasonal and non-seasonal lags we studied the autocorrelation function (ACF) and partial autocorrelation function (PACF) graphs of Moran’s Ib for all categories (Figure 3, Figure A2, Figure A3, Figure A4, Figure A5 and Figure A6). The ACF assesses the correlation between observations in a time series for a set of lags. The partial correlation for each lag shows the pairwise correlation between two observations after partial elimination of intermediate correlations.
For all categories of products, the ACF values decrease quite slowly, which can be an indicator of the non-stationarity of the original data. Therefore, we decided to examine the ACF and PACF graphs for the first differences of the values. Here, we noticed the significance not only of the first two lags, but also for the lag 7 for all categories. This is a good sign for the presence of approximately weekly cycles. We recognized also that the ACF of Moran’s Ib for Potatoes changes in a pattern of a sine curve (Figure 3a). The autocorrelation coefficients are noticeably larger for lags at multiples of the seasonal frequency than for other lags, indicating seasonal patterns.
The PACF was significant for the first three lags, as well as for lags 190 and 365 (Figure 3b). This indicates a mixed process with weekly and yearly periodic elements for Moran’s Ib for Potatoes prices. As for other product categories, no pronounced signs of annual seasonality were revealed from Moran’s Ib dynamics. Some of tests showed annual seasonality for Pasta (Table 4), but these results were not confirmed by ACF/PACF graphs (Figure A2).

4. Discussion

The analysis was carried out on the price data of six product categories. We estimated indicators such as spatial variation (coefficient of variation) and spatial autocorrelation (Moran’s I). The dynamics of the price of product categories varies. Each category’s dynamics is driven by its own characteristics, which affect the resulting estimates of variation and spatial autocorrelation (Figure 1 and Figure 2 and Figure A1).
This corresponds fairly well to the results of the previous studies showing that estimates of spatial variation and convergence of regions for a particular group of products may not coincide with estimates for a general price index [3,11]. Moreover, the spatial relationships may vary for different groups of goods [23], also due to different policies for price regulation in the regions [22]. Thus, the research on separate product categories might benefit with deeper understanding of the spatial dependence of prices, since many of the categories often demonstrate particular spatial price dynamics.
The calculations show that the regional price variation and spatial autocorrelation vary not only across the product categories, but also across time. The estimates calculated for one period may not always accurately characterize the real spatial dependence. We would like to discuss certain factors that may lead to the variability of the estimates in time.

4.1. Holidays and Special Events

As mentioned earlier, this study is based on the average price of sold products, actually paid by the consumer at the time of purchase and registered by cash registers. In this regard our approach differs from one used to calculate the CPI (consumer price index) [29]. However, this approach has an important drawback: the consumer prices are often subject to consumer sentiments, since the average price of sold products depends on the structure of sales and the prices. Consumer spending for some products is known to be uneven during the year with peaks around holidays [33]. This is a reason for the average price not to follow the change in prices evenly. The effect is especially important, e.g., for Candies.
On New Year’s Eve and right before International Women’s Day (8 March) the sales of sweets and candies increase significantly in Russia, not only in terms of volume of sales. Moreover, the consumers tend to buy more expensive sweets at that time. As a result, there are peaks for average sweet prices during these holidays (Figure 1d, Figure 2d and Figure A1d).
This effect is evident even though many chains promote and discount sweets in this period. The prices for Pasta and Butter are also higher on New Year’s Eve (Figure 1 and Figure 2). Meanwhile, the change in prices for other product categories is not significant.
Usually, the highest regional variation of prices is observed during these periods. For example, the highest values of spatial variation (Table 2) correspond to the New Year’s holidays (for Sugar on 1 January 2020; Pasta on 31 December 2019) and for International Women’s Day (for Candies on 8 March 2022).
Spatial autocorrelation of prices on these holidays is also usually quite high for all product categories except for Sugar. The highest value of spatial autocorrelation (Moran’s Ib = 0.75) was recorded on 8 March 2022, for Candies.

4.2. Weekly Cycles

Our study also revealed a weekly cyclicity in spatial autocorrelation. However, the results remain debatable.
The cyclicity of the average price is evident (Figure 1 and Figure 2 and Figure A1). The average price reaches highest values on Sunday. The cycles of the Moran’s I are not so evident. However, we noticed that Moran’s I is mostly lower on Monday than the day before (Figure 4). The only exception are public holidays.
Both statistical tests and ACF/PACF graphs indicate the cyclicity (Table 4, Figure 3, Table A1, Figure A2, Figure A3, Figure A4, Figure A5 and Figure A6).
This cyclicity can be explained by various factors. As Leclair et al. argue, the consumers might prefer going shopping on certain days of the week and retailers might offer a reduced price on the days that are less busy [29]. This might apply well to Russia, even though the study of Leclair et al. showed very little variation of prices by the day of the week, at least for certain products. Another reason for the observed cyclicity might be the alignment of ’consumers feelings’ [33], as people tend buying goods that are more expensive and in larger amounts on the weekend. There were also discussed and identified several examples of co-movement of prices in spatially separated markets in Russia [22]. Interestingly, in some regions the purchase of cheaper brands of goods is more pronounced on Monday. spatial prices for Butter may differ on Sunday and Monday (Figure 5).
The number of regions for which the price of Butter differs from that in neighboring regions is larger on Monday than on the weekend (Figure 5). We notice this effect weekly throughout the whole study period (excluding holidays) and therefore consider it as non-accidental.

4.3. Annual Seasonality

The price level and supply of some food products, mainly vegetables and fruits, is annually variable, depending largely on seasonal production. This applies to potatoes, for example [38]. Prices tend to drop during the harvest period and rise from around New Year’s Eve onwards, when last year’s stocks are over.
Russia has several climatic zones. The period of harvest is earlier in some regions than in the others. Moreover, vegetables are not grown in some regions at all due to cold weather, causing additional effects on the spatial correlations of changes in prices.
The spatial variation and spatial autocorrelation usually decrease when the prices rise because of dwindling stocks from the previous year (Figure 1 and Figure 2 and Figure A1). At the same time, the quality/availability of warehouse storage and the volume of stocks in regions vary significantly, which results in fragmentation of the national market. In this case, the Moran’s I values drop, indicating a higher price difference between neighboring regions. The effect of the season is important, e.g., for Potatoes.
With the beginning of the first harvests, the spatial variation between regions increases. The prices start declining in the south, while they remain relatively high in the north. Spatial variation and spatial autocorrelation grow (Moran’s Ib = 0.88 on 10 August 2021, compared to Moran’s Ib = 0.44 on 5 June 2021) as a result, because the regions are geographically structured according to their specialization in agriculture (Figure 6a,b).
The gradual change in prices is associated with the speed of filling the market with new crop potatoes. In the north, due to more expensive storage and delivery conditions, prices nearly always remain high [22]. Therefore, the spatial variation does not decrease, at least not significantly. At the same time, the spatial autocorrelation decreases due to the fragmentation of the market (uneven reductions in stocks and increases in potato prices in regions).

4.4. External Shocks and State Regulation of Prices

Prices for some products may also change under the influence of external shocks. One example is that of the COVID-19 pandemic, when the retail prices of maize and rice rose rapidly in African countries [26]. Sugar and salt prices are traditionally most affected by external shocks in Russia. Sugar prices rose under both the first and the second COVID-19 pandemics waves (Figure 1). Numerous research papers indicate a strict correlation between price spikes and peaks in spatial variance, as well as stronger fragmentation of the markets during price crises [24].
Analysis of both sugar price dynamics, its spatial variation and autocorrelation indicates that the response to external shocks is mainly aligned across regions in Russia. The sugar prices began to rise during the first wave of COVID-19 in most regions, causing the variation to decrease and the spatial autocorrelation to remain almost unchanged. Perhaps, the fragmentation is more pronounced at lower geographic levels of data aggregation.
The situation changed, however, under the second COVID-19 wave. First, the amount of sugar produced exceeded the amount of consumption at that time. Therefore, prices were relatively low in 2019 and early 2020. Secondly, the sugar harvest in 2020 was low while the stocks were significantly reduced during the first wave of the pandemic. For these reasons, a sharp inflation in sugar prices was registered in the fall of 2020, amplified by the second wave of the pandemic. In many regions, the stocks were insufficient to meet the shock demand levels. Under such social conditions, the local authorities began to impose restrictions on both price-changes and exports of sugar, as among the ‘socially significant’ products in Russia. As a result, the price variation decreased, and the spatial correlations became insignificant. In the summer of 2021, the restrictions were lifted as promising news about the sugar harvest became known and prices stabilized quickly, forming a spatial price equilibrium (Figure 2).

4.5. Spatial Variety vs. Spatial Autocorrelation

As our analysis showed, the change in spatial variety and spatial autocorrelation over time is not the same (Figure 1 and Figure 2 and Figure A1). These are two different indicators: the growth of among them may not coincide with the growth of the other, and vice versa. The same level of a coefficient of variation (0.186) may well coexist both with high (Moran’s Ib = 0.61, p-value < 0.001) and low (Moran’s Ib = 0.12, p-value < 0.04) levels of spatial autocorrelation (Figure 7).
In our view, these indicators can complement each other. Spatial autocorrelation can explain how chaotic the variation is and whether there are connections between neighbors. This is consistent with previous simulation results, which shows that the Moran’s I might show clustering [40]. Therefore, it is important to expand the use of spatial autocorrelation methods in the study of regional price differences.
The calculation of Moran’s I using both binary contiguity matrix and inverse distance weights matrix showed that, in general, the binary matrix gives higher estimates of spatial autocorrelation (Table 3). As it has been shown earlier the distance-based weighting criteria serve better for calculating the Moran’s I values, compared to contiguity-based criteria in terms of the capability of characterizing different forms [40]. In our study, the difference between the results obtained for these two types of weights matrix is not large. At the same time, there are practically no differences in the dynamics of Moran’s Ib and Moran’s Iid indexes (Figure 2 and Figure A1).

5. Conclusions

We studied the spatial distribution of the prices of six product categories, namely Pasta, Potatoes, Sugar, Candies, Poultry meat and Butter based on the data available for the period from 1 January 2019, to 31 March 2022, (1186 days) in the context of 83 regions of Russia. The analysis showed that spatial variation and spatial autocorrelation change over time. Therefore, price analysis on low-frequency periodic data (one month or even a quarter) may not accurately reflect the general situation with the spatial distribution of prices. Changes in prices and their spatial relationship can be cyclical, determined by factors, such as holidays, weekends, and seasonal production. When price changes occur in regions simultaneously, the spatial autocorrelation does not change. A decrease in spatial autocorrelation is observed, however, when the market is fragmented. For example, on weekends, there is an aligned ‘feeling’ of consumers, determined by the will to purchase more expensive goods. Nevertheless, in the following days, prices in the regions may show a higher variation. For seasonally produced potatoes, there is a nearly permanent difference in prices in the north and south of the country all year around. We also revealed that the authorities/states influence the spatial autocorrelation of prices. The spatial autocorrelation was insignificant during the period of price regulation for Sugar.
We conclude that spatial price variation and spatial autocorrelation are complementary measures. Both are important for understanding the spatial equilibrium of prices. At the same time, there has been much more research on the analysis of spatial variation than the analysis of spatial autocorrelation. We hope our study will fill this gap at least partly.
However, our results remain debatable, due primarily to the study design. First, our calculations are based on the average price of products sold. The growth rate for average price differs from CPI, which takes the quality and structure of products into account. Several studies show that 97 percent of the variation in price levels across space in these indexes can be attributed to unobserved heterogeneity in the products [28]. The design of an indicator must be considered when interpreting and comparing the results. At the same time, the advantage of focusing on the average price of goods sold is that it allows for a better understanding of consumer behavior. Secondly, we considered a limited range of factors of spatial price change and did not consider differences in the development of transport and storage infrastructure in the regions. At the same time, the spatial price equilibrium modeling framework emphasizes the importance of transportation costs between markets [41]. Thirdly, there remain a question of an appropriate spatial weights matrix to model the economy of such a spacious and particular country as Russia. Both types of spatial weights matrix have pros and cons to consider.
This study is among the few in which the price analysis was calculated on daily data in the context of several product categories. The results show that the dynamics of prices and their spatial dependence are different in the context of product categories and time periods. More and more detailed datasets will be available for researchers as long as the data engineering processes and technologies develop. This would allow a better understanding of the speed and direction of price changes in the short term and therefore more precise targeting of food/product security measures on behalf of the state/authorities. We also expect to understand the spatial correlation processes in prices better as soon as better-detailed primary data become available in the advent of data lakes epoch. New efficient approaches for economic data analysis are already discussed [42,43]. We underline the importance of appropriate specification of economic models. The models on daily price changes would require a careful selection of independent factors besides of the time and space-lagged variables to increase the accuracy of predictions.

Author Contributions

Conceptualization, V.T.; methodology, V.T. and I.L.; software, V.T. and I.L.; validation, V.T. and V.P.; formal analysis, V.P. and D.K.; investigation, V.T. and D.K.; resources, V.T.; data curation, V.T.; writing—original draft preparation, V.T.; writing—review and editing, I.L., V.P. and D.K.; visualization, V.P.; supervision, V.T.; project administration, V.T.; funding acquisition, V.T. All authors have read and agreed to the published version of the manuscript.

Funding

This research was funded by the Ministry of Science and Higher Education of the Russian Federation (scientific code FZWU-2020-0027).

Data Availability Statement

Not applicable.

Conflicts of Interest

The authors declare no conflict of interest. The funders had no role in the design of the study; in the collection, analyses, or interpretation of data; in the writing of the manuscript, or in the decision to publish the results.

Appendix A

Figure A1. Daily average regional price of Pasta (a), Potatoes (b), Sugar (c), Candies (d), Poultry meat (e), Butter (f) and global Moran’s Iid index (based on inverse distance weights matrix), from 1 January 2019 to 31 March 2022.
Figure A1. Daily average regional price of Pasta (a), Potatoes (b), Sugar (c), Candies (d), Poultry meat (e), Butter (f) and global Moran’s Iid index (based on inverse distance weights matrix), from 1 January 2019 to 31 March 2022.
Forecasting 05 00004 g0a1

Appendix B

Table A1. Tests results for seasonality in spatial autocorrelation (invers distance matrices).
Table A1. Tests results for seasonality in spatial autocorrelation (invers distance matrices).
PastaPotatoesSugar CandiesPoultry MeatButter
Weekly cycle
Kruskal–Wallis36.4,
p-value < 0.000
36.7,
p-value < 0.000
61.8,
p-value < 0.000
290.3,
p-value < 0.000
351.5,
p-value < 0.000
256.3,
p-value < 0.000
Welch’s ANOVA test5.4,
p-value < 0.000
5.1,
p-value < 0.000
7.9,
p-value < 0.000
54.4,
p-value < 0.000
74.1,
p-value < 0.000
62.5,
p-value < 0.000
Friedman Rank test31.6,
p-value < 0.000
38.1,
p-value < 0.000
55.3,
p-value < 0.000
233.1,
p-value < 0.000
307.4,
p-value < 0.000
198.3,
p-value < 0.000
QS test11.7,
p-value = 0.003
5.2,
p-value = 0.075
13.7,
p-value = 0.001
244.9,
p-value < 0.000
301.3,
p-value < 0.000
142.1,
p-value < 0.000
Ollech and Webel’s combined seasonality testTRUETRUETRUETRUETRUETRUE
Annual seasonality
Kruskal–Wallis456.1,
p-value = 0.0008
393.8,
p-value = 0.139
350.9,
p-value = 0.686
346.9,
p-value = 0.738
413.5,
p-value = 0.039
296.5,
p-value = 0.996
Welch’s ANOVA test5.4,
p-value < 0.000
5.1,
p-value < 0.000
7.9,
p-value < 0.000
54.4.
p-value < 0.000
74.1,
p-value < 0.000
62.5,
p-value < 0.000
Friedman Rank test432.5,
p-value = 0.0082
388.8,
p-value = 0.183
346.4,
p-value = 0.744
325.5,
p-value = 0.93
394.5,
p-value = 0.134
284.9,
p-value = 0.999
QS test0,
p-value = 1
11.4,
p-value = 0.003
1.1,
p-value = 0.58
0,
p-value = 1
0,
p-value = 1
0,
p-value = 1
Ollech and Webel’s combined seasonality testFALSETRUEFALSEFALSEFALSEFALSE

Appendix C

Figure A2. Autocorrelation function (ACF) of the Moran’s Ib for Pasta prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Pasta prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Figure A2. Autocorrelation function (ACF) of the Moran’s Ib for Pasta prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Pasta prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Forecasting 05 00004 g0a2aForecasting 05 00004 g0a2b
Figure A3. Autocorrelation function (ACF) of the Moran’s Ib for Sugar prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Sugar prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Figure A3. Autocorrelation function (ACF) of the Moran’s Ib for Sugar prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Sugar prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Forecasting 05 00004 g0a3aForecasting 05 00004 g0a3b
Figure A4. Autocorrelation function (ACF) of the Moran’s Ib for Candies prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Candies prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Figure A4. Autocorrelation function (ACF) of the Moran’s Ib for Candies prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Candies prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Forecasting 05 00004 g0a4aForecasting 05 00004 g0a4b
Figure A5. Autocorrelation function (ACF) of the Moran’s Ib for Poultry meat prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Poultry meat prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Figure A5. Autocorrelation function (ACF) of the Moran’s Ib for Poultry meat prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Poultry meat prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Forecasting 05 00004 g0a5aForecasting 05 00004 g0a5b
Figure A6. Autocorrelation function (ACF) of the Moran’s Ib for Butter prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Butter prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Figure A6. Autocorrelation function (ACF) of the Moran’s Ib for Butter prices of the original time series (a) and of the first differences (c); Partial autocorrelation function (PACF) of the Moran’s Ib for Butter prices of the original time series (b) and of the first differences (d). The Moran’s Ib indexes are calculated based on binary contiguity matrices.
Forecasting 05 00004 g0a6aForecasting 05 00004 g0a6b

References

  1. Mehrhoff, J. Introduction—The Value Chain of Scanner and Web Scraped Data. Econ. Stat. 2019, 509, 5–11. [Google Scholar] [CrossRef] [Green Version]
  2. Tiziana, L.; Polidoro, F. Using Scanner Data for Computing Consumer Spatial Price Indexes at Regional Level: An Empirical Application for Grocery Products in Italy. J. Off. Stat. 2022, 38, 23–56. [Google Scholar] [CrossRef]
  3. Benedetti, I.; Laureti, T.; Palumbo, L.; Rose, B.M. Computation of High-Frequency Sub-National Spatial Consumer Price Indexes Using Web Scraping Techniques. Economies 2022, 10, 95. [Google Scholar] [CrossRef]
  4. Abraham, K.G.; Jarmin, R.S.; Moyer, B.C.; Shapiro, M.D. Introduction: Big Data for Twenty-First-Century Economic Statistics: The Future Is Now. In Big Data for Twenty-First-Century Economic Statistics; Abraham, K.G., Jarmin, R.S., Moyer, B.C., Shapiro, M.D., Eds.; NBER Studies in Income and Wealth; University of Chicago Press: Chicago, IL, USA, 2022; Volume 79, pp. 1–22. [Google Scholar]
  5. Konny, C.G.; Williams, B.K.; Friedman, D.M. Big Data in the US Consumer Price Index: Experiences and Plans. In Big Data for Twenty-First-Century Economic Statistics; Abraham, K.G., Jarmin, R.S., Moyer, B.C., Shapiro, M.D., Eds.; NBER Studies in Income and Wealth; University of Chicago Press: Chicago, IL, USA, 2022; Volume 79, pp. 69–98. [Google Scholar]
  6. Mayer-Schönberger, V.; Cukier, K. Big Data. A Revolution That Will Transform How We Live, Work, and Think; Mann, Ivanov and Ferber: Moscow, Russia, 2014. (In Russian) [Google Scholar]
  7. O’Neill, K. Killer Big Data: How Mathematics Became a Weapon of Mass Destruction; AST, cop: Moscow, Russia, 2014. (In Russian) [Google Scholar]
  8. Majumder, A.; Ray, R. National and subnational purchasing power parity: A review. Decision 2020, 47, 103–124. [Google Scholar] [CrossRef]
  9. Samuelson, P.A. Spatial price equilibrium and linear programming. Am. Econ. Rev. 1952, 42, 283–303. [Google Scholar]
  10. Girardin, E.; Sall, C.A.T. Inflation Dynamics of Franc-Zone Countries Determinants, Co-movements and Spatial Interactions. Open Econ. Rev. 2018, 29, 295–320. [Google Scholar] [CrossRef]
  11. Kitenge, E.M.; Morshed, A.K.M.M. Price convergence among Indian cities: The role of linguistic differences, topography, and aggregation. J. Asian Econ. 2019, 61, 34–50. [Google Scholar] [CrossRef]
  12. Wu, G.; Zhang, C.; Liu, P.; Ren, W.; Zheng, Y.; Guo, F.; Chen, X.; Higgs, R. Spatial quantitative analysis of garlic price data based on ArcGIS technology. Comput. Mater. Contin. 2019, 58, 183–195. [Google Scholar] [CrossRef] [Green Version]
  13. Rokicki, B.; Hewings, G.J.D. Regional price deflators in Poland: Evidence from NUTS-2 and NUTS-3 regions. Spat. Econ. Anal. 2019, 14, 88–105. [Google Scholar] [CrossRef]
  14. Montero, J.-M.; Laureti, T.; Mínguez, R.; Fernández-Avilés, G. A Stochastic Model with Penalized Coefficients for Spatial Price Comparisons: An Application to Regional Price Indexes in Italy. Rev. Income Wealth 2020, 66, 512–533. [Google Scholar] [CrossRef]
  15. Léonard, I.; Sillard, P.; Varlet, G.; Zoyem, J.-P. Spatial Differences in Price Levels between French Regions and Cities with Scanner Data. Econ. Stat. 2019, 509, 69–82. [Google Scholar] [CrossRef]
  16. Gluschenko, K.; Davidson, W. Distribution Dynamics of Russian Regional Prices. In WDI Working Paper Number 1061; William Davidson Institute (WDI) at the University of Michigan: Ann Arbor, MI, USA, 2013. [Google Scholar]
  17. Sinelnikov-Murylev, S.G.; Perevyshin, Y.N.; Trunin, P.V. Inflation Differences in the Russian Regions: An Empirical Analysis. Econ. Reg. 2020, 16, 479–493. (In Russian) [Google Scholar] [CrossRef]
  18. Tsyplakov, A.A. Statistical analysis of the dynamics of regional price levels. Bull. NSU Ser. Soc. Econ. Sci. 2000, 1, 5–19. (In Russian) [Google Scholar]
  19. Kirillov, A.M. Spatial Analysis of Food Inflation in Russian Regions. Prostranstvennaya Ekon. Spat. Econ. 2017, 4, 41–58. (In Russian) [Google Scholar] [CrossRef] [Green Version]
  20. Timiryanova, V.M.; Zimin, A.F.; Zhilina, E.V. The Spatial Change of the Indicators of Consumer Market. Econ. Reg. 2018, 14, 164–175. (In Russian) [Google Scholar] [CrossRef]
  21. Korneychenko, E.N.; Novopashina, A.N.; Pikhteev, Y.N. Exchange rate pass-through in Russian regions: Searching for spatial dependencies. Izv. Saratov Univ. Econ. Manag. Law 2021, 21, 398–409. (In Russian) [Google Scholar] [CrossRef]
  22. Goodwin, B.K.; Grennes, T.J.; McCurdy, C. Spatial price dynamics and integration in Russian food markets. J. Policy Reform 1999, 3, 157–193. [Google Scholar] [CrossRef]
  23. Weinand, S.; von Auer, L. Anatomy of Regional Price Differentials: Evidence from Micro Price Data. Spat. Econ. Anal. 2020, 15, 413–440. [Google Scholar] [CrossRef] [Green Version]
  24. Distefano, T.; Chiarotti, G.; Laio, F.; Ridolfi, L. Spatial Distribution of the International Food Prices: Unexpected Heterogeneity and Randomness. Ecol. Econ. 2019, 159, 122–132. [Google Scholar] [CrossRef] [PubMed]
  25. Cedrez, C.B.; Chamberlin, J.; Hijmans, R.J. Seasonal, annual, and spatial variation in cereal prices in Sub-Saharan Africa. Glob. Food Secur. 2020, 26, 100438. [Google Scholar] [CrossRef]
  26. Adewopo, J.B.; Solano-Hermosilla, G.; Colen, L.; Micale, F. Using crowd-sourced data for real-time monitoring of food prices during the COVID-19 pandemic: Insights from a pilot project in northern Nigeria. Glob. Food Secur. 2021, 29, 100523. [Google Scholar] [CrossRef] [PubMed]
  27. Chakrabarty, M.; Majumder, A.; Ray, R. A Framework for the Simultaneous Measurement of Spatial Variation and Temporal Movement in Prices in a Heterogeneous Country: The Dynamic Household Regional Product Dummy Model. Rev. Income Wealth 2018, 64, 703–730. [Google Scholar] [CrossRef]
  28. Handbury, J.; Weinstein, D.E. Goods Prices and Availability in Cities. Rev. Econ. Stud. 2015, 82, 258–296. [Google Scholar] [CrossRef] [Green Version]
  29. Leclair, M.; Léonard, I.; Rateau, G.; Sillard, P.; Varlet, G.; Vernédal, P. Scanner Data: Advances in Methodology and New Challenges for Computing Consumer Price Indices. Econ. Stat. 2019, 509, 13–29. [Google Scholar] [CrossRef] [Green Version]
  30. Fok, D.; Franses, P.H.; Paap, R. Seasonality and non-linear price effects in scanner-data-based market-response models. J. Econom. 2007, 138, 231–251. [Google Scholar] [CrossRef]
  31. Kakpo, A.; Mills, B.F.; Brunelind, S. Weather shocks and food price seasonality in Sub-Saharan Africa: Evidence from Niger. Food Policy 2022, 112, 102347. [Google Scholar] [CrossRef]
  32. Baruah, P. Seasonality in commodity prices across India: Extent and implications. In Proceedings of the 94th Annual Conference, Leuven, Belgium, 15–17 April 2020. [Google Scholar] [CrossRef]
  33. Guha, R.; Ng, S.A. A Machine Learning Analysis of Seasonal and Cyclical Sales in Weekly Scanner Data. NBER Work. Pap. 2019, 25899. [Google Scholar] [CrossRef]
  34. Ray, R. Spatial Differences in Prices in India, State Rankings and Inequality. In Household Behaviour, Prices, and Welfare. Themes in Economics; Springer: Singapore, 2019; pp. 119–178. [Google Scholar] [CrossRef]
  35. Kalinin, A.M.; Volin, I.A. Data Sources for CPI: Big Data of the Internet and the Systems of the Federal Tax Service of Russia. Vopr. Stat. 2022, 29, 44–51. (In Russian) [Google Scholar] [CrossRef]
  36. Banaśa, J.; Utnik-Banaś, K. Evaluating a seasonal autoregressive moving average model with an exogenous variable for short-term timber price forecasting. For. Policy Econ. 2021, 131, 102564. [Google Scholar] [CrossRef]
  37. Wanjuki, T.M.; Wagala, A.; Muriithi, D.K. Evaluating the Predictive Ability of Seasonal Autoregressive Integrated Moving Average (SARIMA) Models using Food and Beverages Price Index in Kenya. Eur. J. Math. Stat. 2022, 3, 28–38. [Google Scholar] [CrossRef]
  38. Kumar, R.R.; Baishya, M. Forecasting of Potato Prices in India: An Application of Arima Model. Econ. Aff. 2020, 65, 473–479. [Google Scholar] [CrossRef]
  39. Molinaro, A.; DeFalco, F. Empirical assessment of alternative methods for identifying seasonality in observational healthcare data. BMC Med. Res. Methodol. 2022, 22, 182. [Google Scholar] [CrossRef] [PubMed]
  40. Tsai, Y.-H. Quantifying Urban Form: Compactness versus ‘Sprawl’. Urban Stud. 2005, 42, 141–161. [Google Scholar] [CrossRef]
  41. Nagurney, A.; Besik, D. Spatial price equilibrium networks with flow-dependent arc multipliers. Optim. Lett. 2022, 16, 2483–2500. [Google Scholar] [CrossRef] [PubMed]
  42. Caruccio, L.; Deufemia, V.; Naumann, F.; Polese, G. Discovering Relaxed Functional Dependencies Based on Multi-Attribute Dominance. IEEE Trans. Knowl. Data Eng. 2021, 33, 3212–3228. [Google Scholar] [CrossRef]
  43. Naumann, F. Data profiling revisited. SIGMOD Rec. 2014, 42, 40–49. [Google Scholar] [CrossRef]
Figure 1. Daily average regional price of Pasta (a), Potatoes (b), Sugar (c), Candies (d), Poultry meat (e), Butter (f) and respective coefficients of variation from 1 January 2019 to 31 March 2022.
Figure 1. Daily average regional price of Pasta (a), Potatoes (b), Sugar (c), Candies (d), Poultry meat (e), Butter (f) and respective coefficients of variation from 1 January 2019 to 31 March 2022.
Forecasting 05 00004 g001aForecasting 05 00004 g001b
Figure 2. Daily average regional price of Pasta (a), Potatoes (b), Sugar (c), Candies (d), Poultry meat (e), Butter (f) and global Moran’s Ib index (based on binary contiguity matrix), from 1 January 2019 to 31 March 2022.
Figure 2. Daily average regional price of Pasta (a), Potatoes (b), Sugar (c), Candies (d), Poultry meat (e), Butter (f) and global Moran’s Ib index (based on binary contiguity matrix), from 1 January 2019 to 31 March 2022.
Forecasting 05 00004 g002aForecasting 05 00004 g002b
Figure 3. Autocorrelation function (ACF) of the Moran’s Ib for Potatoes prices for original time series (a) and for the first differences (c); partial autocorrelation function (PACF) of the Moran’s Ib for Potatoes prices for original time series (b) and for the first differences (d).
Figure 3. Autocorrelation function (ACF) of the Moran’s Ib for Potatoes prices for original time series (a) and for the first differences (c); partial autocorrelation function (PACF) of the Moran’s Ib for Potatoes prices for original time series (b) and for the first differences (d).
Forecasting 05 00004 g003aForecasting 05 00004 g003b
Figure 4. Daily average price and global Moran’s Ib index for Candies (a), Poultry meat (b), and Butter (c), from 15 March 2021 to 31 April 2022.
Figure 4. Daily average price and global Moran’s Ib index for Candies (a), Poultry meat (b), and Butter (c), from 15 March 2021 to 31 April 2022.
Forecasting 05 00004 g004
Figure 5. Spatial price of Butter on Sunday: 28 March 2021 (a), 11 April 2021 (c), 25 April 2021 (e), and Monday: 29 March 2021 (b), 12 April 2021 (d), 26 April 2021 (f).
Figure 5. Spatial price of Butter on Sunday: 28 March 2021 (a), 11 April 2021 (c), 25 April 2021 (e), and Monday: 29 March 2021 (b), 12 April 2021 (d), 26 April 2021 (f).
Forecasting 05 00004 g005
Figure 6. Spatial price of Potatoes price, 5 June 2021 (a), 10 August 2021 (b). All regions, for which the data are not available for these dates, are marked as “undefined”.
Figure 6. Spatial price of Potatoes price, 5 June 2021 (a), 10 August 2021 (b). All regions, for which the data are not available for these dates, are marked as “undefined”.
Forecasting 05 00004 g006
Figure 7. Spatial distribution of Sugar price, 10 June 2021 (a) and 7 September 2021 (b). All regions, for which the data are not available for these dates, are marked as “undefined”.
Figure 7. Spatial distribution of Sugar price, 10 June 2021 (a) and 7 September 2021 (b). All regions, for which the data are not available for these dates, are marked as “undefined”.
Forecasting 05 00004 g007
Table 1. Descriptive statistics.
Table 1. Descriptive statistics.
PastaPotatoesSugar CandiesPoultry MeatButter
Price, ruble for kg
Min32.045.686.7177.8847.96117.45
Max214.12151.44188.572034.55423.811041.46
Average82.7835.2943.95310.48175.88531.98
SD20.016.413.380.637.597.6
Number of observations
Total97,52496,54595,90197,70097,38797,116
Min./day797778818078
Table 2. Coefficient of variation, from 1 January 2019 to 31 March 2022.
Table 2. Coefficient of variation, from 1 January 2019 to 31 March 2022.
PastaPotatoesSugar CandiesPoultry MeatButter
Total spatial variation for all regions0.240.460.300.260.210.18
Minimum value of spatial variation0.1510.1520.1020.1421400.115
Maximum value of spatial variation 0.2680.5990.4040.3720.2520.260
Table 3. Global Moran’s I.
Table 3. Global Moran’s I.
PastaPotatoesSugarCandiesPoultry MeatButter
Moran’s Ib (binary contiguity matrix)
Min0.290.39−0.010.110.290.17
Max0.650.880.680.750.770.77
Mean0.530.680.380.440.630.47
Median0.540.690.450.460.640.48
SD0.040.080.180.100.080.09
Moran’s Iid (invers distance matrix)
Min0.300.42−0.030.120.290.20
Max0.610.880.640.720.740.78
Mean0.510.680.360.460.600.50
Median0.510.680.410.480.610.51
SD0.030.070.170.090.070.09
Table 4. Tests results for seasonality in spatial autocorrelation (based on binary contiguity matrix).
Table 4. Tests results for seasonality in spatial autocorrelation (based on binary contiguity matrix).
PastaPotatoesSugar CandiesPoultry MeatButter
Weekly cycle
Kruskal–Wallis72.7
p-value < 0.000
35.5
p-value < 0.000
65.1
p-value < 0.000
327.4
p-value < 0.000
361.1
p-value < 0.000
304
p-value < 0.000
Welch’s ANOVA test12.1
p-value < 0.000
4.8
p-value = 0.001
8.2
p-value < 0.000
63.4
p-value < 0.000
77
p-value < 0.000
8.7
p-value < 0.000
Friedman Rank test62.6
p-value < 0.000
32.8
p-value < 0.000
54.4
p-value < 0.000
267.9
p-value < 0.000
308.1
p-value < 0.000
239.5
p-value < 0.000
QS test27.7
p-value < 0.000
4.1
p-value = 0.13
9.0
p-value = 0.011
311.6
p-value < 0.000
304.3
p-value < 0.000
206.4
p-value < 0.000
Ollech and Webel’s combined seasonality testTRUETRUETRUETRUETRUETRUE
Annual seasonality
Kruskal–Wallis447.3
p-value = 0.002
400.1
p-value = 0.096
339.6
p-value = 0.82
342.4
p-value = 0.79
395.4
p-value = 0.127
273.7
p-value = 0.99
Welch’s ANOVA test12.1
p-value < 0.000
4.8
p-value = 0.001
8.2
p-value < 0.000
63.4
p-value < 0.000
77.0
p-value < 0.000
8.7
p-value < 0.000
Friedman Rank test425.3
p-value = 0.015
391.6
p-value = 0.158
340
p-value = 0.817
322.7
p-value = 0.944
373.2
p-value = 0.37
26.6
p-value = 1
QS test0
p-value = 1
9.4
p-value = 0.009
0.5
p-value = 0.798
0
p-value = 1
6.2
p-value = 0.045
0
p-value = 1
Ollech and Webel’s combined seasonality testFALSETRUEFALSEFALSEFALSEFALSE
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content.

Share and Cite

MDPI and ACS Style

Timiryanova, V.; Lakman, I.; Prudnikov, V.; Krasnoselskaya, D. Spatial Dependence of Average Prices for Product Categories and Its Change over Time: Evidence from Daily Data. Forecasting 2023, 5, 102-126. https://doi.org/10.3390/forecast5010004

AMA Style

Timiryanova V, Lakman I, Prudnikov V, Krasnoselskaya D. Spatial Dependence of Average Prices for Product Categories and Its Change over Time: Evidence from Daily Data. Forecasting. 2023; 5(1):102-126. https://doi.org/10.3390/forecast5010004

Chicago/Turabian Style

Timiryanova, Venera, Irina Lakman, Vadim Prudnikov, and Dina Krasnoselskaya. 2023. "Spatial Dependence of Average Prices for Product Categories and Its Change over Time: Evidence from Daily Data" Forecasting 5, no. 1: 102-126. https://doi.org/10.3390/forecast5010004

Article Metrics

Back to TopTop