CROSS-CORRELATION MODELLING OF SURFACE WATER – GROUNDWATER INTERACTION USING THE EXCEL SPREADSHEET APPLICATION
Autor: | Tea Bedeniković, Kristijan Posavec, Matija Ratkaj, Perica Vukojević |
---|---|
Jazyk: | angličtina |
Rok vydání: | 2017 |
Předmět: |
Hydrology
lcsh:TN1-997 geography geography.geographical_feature_category Cross-correlation Industry standard lcsh:QE1-996.5 Microsoft excel Geology Regression analysis Aquifer surface water-groundwater interaction cross-correlation Geotechnical Engineering and Engineering Geology lcsh:Geology General Energy Pressure propagation General Earth and Planetary Sciences Environmental science Excel spreadsheet application Surface water Groundwater lcsh:Mining engineering. Metallurgy Water Science and Technology |
Zdroj: | Rudarsko-geološko-naftni Zbornik, Vol 32, Iss 1, Pp 25-32 (2017) |
ISSN: | 1849-0409 0353-4529 |
Popis: | 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. |
Databáze: | OpenAIRE |
Externí odkaz: |