Mathematics with Excel

Av David Sjöstrand

190 sidor, Studentlitteratur 1994, 210 kr (exkl. moms och frakt)

This book leads you through some beautiful parts of the mathematical landscape and shows that Excel is a superb exploration tool. It shows how Excel can be used to visualize important mathematical ideas and make them concrete. The graphical features of Excel are used frequently.

Intended for students at secondary school and college level, the book contains many examples with detailed instructions and exercises. It can be used by students with little or no experience of spreadsheets as well as by advanced Excel-users. The reader is assumed to have access to Excel 5.0 although readers with older versions or other spreadsheets will find it useful.

The following topics are covered. Introduction to worksheets, charts and workbooks. Worksheet formulas. Copying formulas using absolute and relative references. Customizing Excel using Visual Basic macros and user-defined functions. Graph plotting in 2 and 3 dimensions. Shifts, reflections and rotations of curves. Numerical calculation of derivatives and integrals. Numerical solution of equations, systems of equations and differential equations. Direction fields. Simulation of motion. Matrices. Linear and non-linear optimization. Sets and algebraic structures, groups. Combined use of spreadsheets and computer algebra (DERIVE).

Contents:

• Worksheet formulas
• Copying formulas using absolute and relative references
• Customizing Excel using Visual Basic macros and user-defined functions
• Graph plotting in 2 and 3 dimensions
• Shifts, reflections and rotations of curves
• Numerical calculation of derivatives and integrals
• Numerical solution of equations
• Systems of equations and differential equations
• Direction fields
• Simulation of motion
• Matrices
• Linear and nonlinear optimization
• Sets and algebraic structures
• Groups
• Combined use of spreadsheets and computer algebra (DERIVE)

Reprint with amendments.