Abstract
Modelling responses of groundwater levels in aquifer systems, which occur as a reaction to changes in aquifer system boundary conditions such as river or stream stages, is commonly being studied using statistical methods, namely correlation, cross-correlation and regression methods. Although correlation and regression analysis tools are readily available in Microsoft Excel, a widely applied spreadsheet industry standard, the cross-correlation analysis tool is missing. As a part of research of groundwater pressure propagation into alluvial aquifer systems of the Sava and Drava/Danube River catchments following river stages rise, focused on estimating groundwater pressure travel times in aquifers, an Excel spreadsheet data analysis application for cross-correlation modelling has been designed and used in modelling surface water – groundwater interaction. Examples of fi eld data from the Zagreb aquifer system and the Kopacki rit Nature Park aquifer system are used to illustrate the usefulness of the cross-correlation application.
Highlights
Modelling of surface water – groundwater interaction, namely groundwater pressure propagation into alluvial aquifer systems of the Sava and Drava/Danube River catchments, as a response to changes in aquifer system boundary conditions i.e. following Sava, Drava and Danube River stage rise, has been conducted using the cross-correlation data analysis application
Modelling responses of groundwater levels in aquifer systems, which occur as a reaction to changes in aquifer system boundary conditions such as river or stream stages, is commonly being studied using statistical methods, namely correlation, cross-correlation and regression methods
Crosscorrelation is a process of comparing a time series, for example river stage and groundwater level time series, at successive lags in order to determine the lag or offset in time or distance between them at their position of maximum equivalence (Davis, 2002)
Summary
Modelling of surface water – groundwater interaction, namely groundwater pressure propagation into alluvial aquifer systems of the Sava and Drava/Danube River catchments, as a response to changes in aquifer system boundary conditions i.e. following Sava, Drava and Danube River stage rise, has been conducted using the cross-correlation data analysis application. Cheng-Mau Wu et al (2005) used cross-correlation analysis to investigate effects of heterogeneity in aquifer parameters, transmissivity (T) and storage (S), on the analysis of traditional aquifer tests using the Theis analytic solution They used cross-correlation analysis to represent distributions of the crosscorrelations between the observed head and transmissivity field as well as distributions of the cross correlations between the observed head and storage coefficient field. Interaction between stream water and groundwater by analysing their temperatures using cross-correlation analysis was studied in a work of Lee et al (2013). Their goal was to identify potential stream-groundwater exchange using vertical flow calculation.
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
