LineFit.xls: a Microsoft Excel template for fitting 11 regression models to Y-X data
Keywords:
data fitting, data modeling, fit comparasion, MS Office softwareAbstract
An essential challenge in any environmental field (forestry, agriculture, etc.), which places an emphasis on data analysis for the purpose of decision making and problem solving, is the estimation of a dependent environmental variable (Y) through an independent one (X). In this work, a Microsoft Excel template is proposed for assessing a set of eleven popular regression Y-X models. Any researcher can use LineFit.xls as a modeling tool for assessing these eleven regression models and selecting the one that best fits their data by running tests on all regression assumptions and comparing models using the most common fitting comparison criteria. Microsoft Excel, being a widely used and user-friendly program, makes it easy to update, expand, and personalize the tests to meet specific needs.
Downloads
Additional Files
Published
Issue
Section
License
Copyright (c) 2024 Prof. Dr. Kyriaki Kitikidou, PhD, Prof. Dr. Elias Milios, PhD
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.