The availability of large environmental datasets and increased computational capability has motivated researchers to propose innovative techniques to mine information from data. The Evolutionary Polynomial Regression (EPR) is a hybrid data-driven technique that combines genetic algorithms and numerical regression for developing easily interpretable mathematical model expressions. EPR is a multiobjective search paradigm for producing multiple models by simultaneously optimizing accuracy and parsimony of resulting expressions. Here the EPR MOGAXL v.1 is presented. It is an MS-Excel add-in that allows the user to launch an EPR run as a function in MS-Excel, thereby exploiting a familiar environment to perform data-driven modeling. Inputs and outputs can be easily selected from a spreadsheet, while a separate sheet containing all EPR modeling options can be modified and retrieved for future analyses. The expression(s) of model(s) obtained, the model predictions and fitness indicators are stored in a separate Excel file, allowing subsequent multiple analyses. An application of EPR-MOGA-XL is presented and discussed.

EPR-MOGA-XL: from Hydroinformatics an Excel based solution to expedite data-driven modelling / Laucelli, Daniele Biagio; Doglioni, Angelo; Simeone, Vincenzo; Giustolisi, Orazio. - (2012). (Intervento presentato al convegno 5th International Perspective on Water Resources & the Environment Conference (IPWE 2012) tenutosi a Marrakech (Morocco) nel 4-7 January 2012).

EPR-MOGA-XL: from Hydroinformatics an Excel based solution to expedite data-driven modelling

LAUCELLI, Daniele Biagio;DOGLIONI, Angelo;SIMEONE, Vincenzo;GIUSTOLISI, Orazio
2012-01-01

Abstract

The availability of large environmental datasets and increased computational capability has motivated researchers to propose innovative techniques to mine information from data. The Evolutionary Polynomial Regression (EPR) is a hybrid data-driven technique that combines genetic algorithms and numerical regression for developing easily interpretable mathematical model expressions. EPR is a multiobjective search paradigm for producing multiple models by simultaneously optimizing accuracy and parsimony of resulting expressions. Here the EPR MOGAXL v.1 is presented. It is an MS-Excel add-in that allows the user to launch an EPR run as a function in MS-Excel, thereby exploiting a familiar environment to perform data-driven modeling. Inputs and outputs can be easily selected from a spreadsheet, while a separate sheet containing all EPR modeling options can be modified and retrieved for future analyses. The expression(s) of model(s) obtained, the model predictions and fitness indicators are stored in a separate Excel file, allowing subsequent multiple analyses. An application of EPR-MOGA-XL is presented and discussed.
2012
5th International Perspective on Water Resources & the Environment Conference (IPWE 2012)
EPR-MOGA-XL: from Hydroinformatics an Excel based solution to expedite data-driven modelling / Laucelli, Daniele Biagio; Doglioni, Angelo; Simeone, Vincenzo; Giustolisi, Orazio. - (2012). (Intervento presentato al convegno 5th International Perspective on Water Resources & the Environment Conference (IPWE 2012) tenutosi a Marrakech (Morocco) nel 4-7 January 2012).
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11589/22647
Citazioni
  • Scopus ND
  • ???jsp.display-item.citation.isi??? ND
social impact