O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11

Modeling I

Publisher Summary

The objective of this chapter is to show how to layout a worksheet, which is difficult for many users. The chapter comprises many exercises that include population model, vapor pressure of ammonia, stress analysis, and circuit analysisIt observes how population model predicts the changing populations and examines the sensitivity of the model to the values of the parameters. Stress analysis exercise demonstrates a practical use of matrix algebra to solve a system of linear equations. In the exercise pertaining to centroid of a polygon, an example is shown of a UDF that solves a real world problem. It is wished to enter the coordinates of the vertices of a polygon into a worksheet and have the UDF return the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required