Mathematical modeling using Microsoft Excel
Emmons, Nelson L
Weir, Maurice D.
Mansager, Bard K.
MetadataShow full item record
The entry into higher mathematics begins with calculus. Rarely, however, does the calculus student recognize the full power and applications for the mathematical concepts and tools that are taught. Frank R. Giordano, Maurice D. Weir, and William P. Fox produced A First Course in Mathematical Modeling a unique text designed to address this shortcoming and teach the student how to identify, formulate, and interpret the real world in mathematical terms. Mathematical modeling is the application of mathematics to explain or predict real world behavior. Often real world data are collected and used to veriiy or validate (and sometimes formulate) a hypothetical model or scenario. Inevitably, in such situations, it is desirable and necessary to have computational support available to analyze the large amounts of data. Certainly this eliminates the tedious and inefficient hand calculations necessary to validate and apply the model (assuming the calculations can even be reasonably done by hand). The primary purpose of Mathematical Modeling Using Microsoft Excel is to provide instructions and examples for using the spreadsheet program Microsoft Excel to support a wide range of mathematical modeling applications. Microsoft Excel is a powerful spreadsheet program which allows the user to organize numerical data into an easy to follow on-screen grid of columns and rows. Our version of Excel is based on Microsoft Windows. In this text, it is not the intent to teach mathematical modeling, but rather to provide computer support for most of the modeling topics covered in A First Course in Mathematical Modeling. The examples given here are support that text as well
Approved for public release; distribution is unlimited
Showing items related by title, author, creator and subject.
Bhargava, Hemant K.; Krishnan, Ramayya; Mukherjee, Sumitra (Monterey, California. Naval Postgraduate School, 1991-09-26); No. 91-05; AD-A242 733; NPS-AS-91-05This paper examines ways in which the addition of data modeling features can enhance the capabilities of mathematical modeling languages, and demonstrates how such integration might be achieved as an application of the ...
Phillips, Donovan D. (Monterey, California. Naval Postgraduate School, 1998-12);Mathematical modeling forms a bridge between the study of mathematics and the application of mathematics with the intent of explaining or predicting real world behavior. In their book A First Course in Mathematical Modeling, ...
Workforce modeling and simulation education and training for lifelong learning : Modeling and simulation education catalog Catalano, Jean; Didoszak, Jarema M. (2007-03); NPS-SE-07-M01This technical report describes the contents of a Microsoft Access database developed in support of the Workforce Modeling and Simulation Education and Training for Lifelong Learning project. The catalog contains searchable ...