Abstract
<p>In this paper, we present an example of linear optimization in the context of degrees in Economics or Business Administration and Management. We show techniques that enable students to go deep and investigate in real problems that have been modelled using the Excel platform. The model shown here has been developed by a student and it consists in minimizing the absolute deviations over the average expected return of a portfolio of securities, using the solver tool that it is included in this software.</p>
Full Title
Modelo de selección de cartera con Solver
Primary Author
P. Fogués Zornoza
Co-Authors
E. Jiménez Fernández
Publication Type
Journal Article
Year
2012
Journal
Modelling in Science Education and Learning
Volume / Issue
Vol. 5, No. 0
Pages
57–63
Category
Business Administration
Institution
External / Open Access
Access
Open Access
Added to Library
March 24, 2026
Cite This Publication
APA
P. Fogués Zornoza, E. Jiménez Fernández (2012). Modelo de selección de cartera con Solver. *Modelling in Science Education and Learning*, 5(0), 57–63.
MLA
P. Fogués Zornoza. "Modelo de selección de cartera con Solver." *Modelling in Science Education and Learning*, vol. 5, no. 0, 2012, pp. 57–63.
DOI
https://doi.org/10.4995/msel.2012.2133