INTERACTION BETWEEN EXCEL AND LANGUAGE R, AN APPLICATION IN FISHERY BIOLOGY

Authors

  • Raúl Carvajal Facultad de Informática Mazatlán, Universidad Autónoma de Sinaloa/Centro Regional de Investigaciones Pesqueras, Instituto Nacional de Pesca
  • Juan Madrid Centro Regional de Investigaciones Pesqueras, Instituto Nacional de Pesca
  • Pedro Valdez Centro Regional de Investigaciones Pesqueras, Instituto Nacional de Pesca
  • Aníbal Zaldívar-Colado Facultad de Informática Mazatlán, Universidad Autónoma de Sinaloa

DOI:

https://doi.org/10.36825/RITI.01.01.003

Keywords:

Spreadsheet, Excel, R Language, Population Dynamics, Fisheries

Abstract

In this paper we present the basic methodology to use the mathematical - statistical package R and its programming language, from an Excel spreadsheet. An example is presented in which, from the length data from a sampling of the catch of a certain fishery, the descriptive statistics and the corresponding histogram are obtained. The size distribution is calculated in later times, using the Von Bertalanffy growth equation and the natural mortality curve. Finally, using the weight - length relationship, an estimate of the biomass is made.

References

TIBCO Spotfire. URL:http://spotfire.tibco.com/Products/S- Plus-Overview.aspx. (31.11.2009).

Becker, R. A.; Chambers, J. M. A Language and System for Data Analysis. Bell Laboratories Computer Information Service, Murray Hill, New Jersey, 1981.

The R Project for Statistical Computing.

URL:http://www.r-project.org. (31.11.2009).

Ihaka, R; Gentleman, R. R: A language for data analysis and graphics. Journal of Computational and Graphical Statistics, 5, 3(1996), pp. 299-314.

Heiberger, R. M.; Neuwirth, E.; Through, R. Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics. Springer Verlag, New York, 2009.

Baier, T.; Neuwirth, E. Statconn projects. URL:http://rcom.univie.ac.at/. (04.11.2009).

The European Bioinformatics Institute.

URL:http://www.ebi.ac.uk/microarray- srv/frontendapp/rworkbench.jnlp. (04.11.2009).

Dalgaard, P. Introductory Statistics with R, 2nd ed.

Springer, New York, 2008.

Haddon, M. Modelling and quantitative methods in fisheries. Chapman & Hall/CRC, New York, 2001.

Sullivan, P. J.; Lai, H. L.; Gallucci, V. F. A catch-at-length analysis that incorporates a stochastic model of growth.

Can. J. Fish. Aquat. Sci. 47 (1990), pp. 184-198.

Sparre, P.; Venema, S.C. Introducción a la evaluación de recursos pesqueros tropicales. FAO, Roma, 1997.

Chambers, J. M. Software for Data Analysis: Programming with R. Springer, New York, 2008.

Downloads

Published

2013-03-13

How to Cite

Carvajal, R., Madrid, J., Valdez, P., & Zaldívar-Colado, A. (2013). INTERACTION BETWEEN EXCEL AND LANGUAGE R, AN APPLICATION IN FISHERY BIOLOGY. Revista De Investigación En Tecnologías De La Información, 1(1), 12–17. https://doi.org/10.36825/RITI.01.01.003

Issue

Vol. 1 No. 1 (2013): Enero-Junio

Section

Artículos

License

Copyright (c) 2013 Revista de Investigación en Tecnologías de la Información

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Esta revista proporciona un acceso abierto a su contenido, basado en el principio de que ofrecer al público un acceso libre a las investigaciones ayuda a un mayor intercambio global del conocimiento. 

El texto publicado en la Revista de Investigación en Tecnologías de la Información (RITI) se distribuye bajo la licencia Creative Commons (CC BY-NCCc-by new.svgCc-nc.svg), que permite a terceros utilizar lo publicado citando a los autores del trabajo y a RITI, pero sin hacer uso del material con propósitos comerciales.

Most read articles by the same author(s)