Guide to using Multiple Regression in Excel (MRCX v.1.1) for Removal of River Stage Effects from Well Water Levels

Mackley, Rob D. ; Spane, Frank A. ; Pulsipher, Trenton C. ; Allwardt, Craig H.

关键词: COMPUTERS;    COMPUTER CODES;    PROGRAMMING;    REMOVAL;    RIVERS;    WATER;    WELLS water level;    river-stage;    regression;    deconvolution;   

DOI  :  10.2172/1000163
RP-ID  :  PNNL-19775 Rev. 1.
PID  :  OSTI ID: 1000163
Others  :  Other: 830403000
Others  :  TRN: US201106%%855

学科分类：社会科学、人文和艺术（综合）

美国|英语

来源: SciTech Connect

【 摘 要 】

A software tool was created in Fiscal Year 2010 (FY11) that enables multiple-regression correction of well water levels for river-stage effects. This task was conducted as part of the Remediation Science and Technology project of CH2MHILL Plateau Remediation Company (CHPRC). This document contains an overview of the correction methodology and a user???s manual for Multiple Regression in Excel (MRCX) v.1.1. It also contains a step-by-step tutorial that shows users how to use MRCX to correct river effects in two different wells. This report is accompanied by an enclosed CD that contains the MRCX installer application and files used in the tutorial exercises.