Electronic Proceedings of the Twelfth Annual International Conference on Technology in Collegiate Mathematics
San Francisco, California, November 4-7, 1999
Solving a Nonlinear Optimization Problem Using Excel
Department of Mathematics
Saint Peter's College
2641 Kennedy Blvd.
Jersey City, NJ 07306
Phone: (908) 233-7399
|Click to access this paper:|
|Additional file(s) associated with this paper:|
In the paper, we discuss how to set up the problem in the spreadsheet and how it can be used as a teaching tool in a mathematical modeling course. An Excel workbook covering all aspects of this example accompanies the paper.