Getting the best out of Excel

Author: Heys, Chris

Source: Teaching Mathematics and its Applications, Volume 27, Number 1, 3 March 2008 , pp. 48-52(5)

Buy & download fulltext article:

Price: $42.29 plus tax (Refund Policy)

Abstract:

Excel, Microsoft's spreadsheet program, offers several tools which have proven useful in solving some optimization problems that arise in operations research.

We will look at two such tools, the Excel modules called Solver and Goal Seekthis after deriving an equation, called the cash accumulation equation, to be used in conjunction with them.

Document Type: Research article

DOI: http://dx.doi.org/10.1093/teamat/hrm013

Publication date: 2008-03-03

More about this publication?

The journal provides a forum for the exchange of ideas and experiences which contribute to the improvement of mathematics teaching and learning for students from upper secondary/high school level through to university first degree level. A distinctive feature of the journal is its emphasis on the applications of mathematics and mathematical modelling within the context of mathematics education world-wide. The journal's readership consists of mathematics teachers, students, researchers and those concerned with curriculum development and assessment, indeed anyone concerned about the education of users of mathematics.