Related Experiment Video
Updated: Jul 20, 2026

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data
Published on: December 9, 2015
A visual basic spreadsheet macro for recession curve analysis
Kristijan Posavec1, Andrea Bacani, Zoran Nakić
1Faculty of Mining, Geology and Petroleum Engineering, Department of Geology and Geological Engineering, University of Zagreb, Pierottijeva 6, Zagreb, 10000, Croatia. kposavec@rgn.hr
Abstract:
A Visual Basic program for an Excel spreadsheet was written to construct a master recession curve (MRC), using the adapted matching strip method, for recession analysis of ground water level time series. The program uses five different linear/nonlinear regression models to adjust individual recession segments to their proper positions in the MRC. The program can also be used to analyze the recession segments of other time series, such as daily stream discharge or stage. Some examples of field data from Croatia are used to illustrate the usefulness of its application.
Related Concept Videos
Microsoft Excel: Regression Analysis
To perform regression...
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Overview of Microsoft Excel as a Data Analysis Tool
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis
Mean: The arithmetic average of all data points. It is calculated by adding all the values together and dividing by the number of values. The mean is sensitive to extreme values (outliers).
Median: The middle value when the data points are arranged in ascending or descending...
Microsoft Excel: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data Analysis...
Microsoft Excel: Plotting Mean, SD, and SE
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...

