Naslov
Cross-correlation Modelling of Surface Water – Groundwater Interaction Using Excel Spreadsheet Application

Autori
Posavec, Kristijan ; Vukojević, Perica ; Ratkaj, Matija ; Bedeniković, Tea

Izvornik
Rudarsko-geološko-naftni zbornik (0353-4529) 32 (2017), 1; 25-32

Vrsta, podvrsta i kategorija rada
Radovi u časopisima, članak, znanstveni

Ključne riječi
cross-correlation; Excel spreadsheet application; surface water-groundwater interaction

Sažetak
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, cross-correlation analysis tool is though 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 field data from Zagreb aquifer system and Kopački rit Nature Park aquifer system are used to illustrate the usefulness of cross-correlation application.

Izvorni jezik
Engleski

Znanstvena područja
Rudarstvo, nafta i geološko inženjerstvo

POVEZANOST RADA