LineFit.xls: a Microsoft Excel template for fitting 11 regression models to Y-X data

Authors

  • Prof. Dr. Kyriaki Kitikidou, PhD Democritus University, Department of Forestry and Management of the Environment and Natural Resources, 68200, Orestiada, Greece
  • Prof. Dr. Elias Milios, PhD Democritus University, Department of Forestry and Management of the Environment and Natural Resources, 68200, Orestiada, Greece

Keywords:

data fitting, data modeling, fit comparasion, MS Office software

Abstract

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

2024-03-26

Issue

Section

Preliminary communication