Modelling physics with Microsoft Excel®
By: Bernard V Liengme
Series: IOP Concise Physics; IOP concise physics
Publisher: Morgan & Claypool
Published: 2014
Place of publication: San Rafael, CA
Language: eng
Number of pages: 96
ISBN-13: 9781627054195; 9781627054188
Subjects: Physics; Data processing; Mathematics; Electronic spreadsheets; Mathematical modelling; SCIENCE; Mathematical & Computational; Commerce; Business & Economics; Marketing & Sales
Other titles: Modeling physics with Microsoft Excel
Description: "The purpose of this work is to show some of the ways in which Microsoft Excel may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly Excel is never going to out-perform the wonderful symbolic algebra tools that we have today---Mathematica. Mathcad, Maple, MATLAB, etc. However, from a pedagogical stance Excel has the advantage of not being a 'black box' approach to problem solving. The user must do a lot more work than just call up a function. The intermediate steps in a calculation are displayed on the worksheet---of course this is not true with the Solver add-in which is a wonderful 'black box'. Another advantage is the somewhat less steep learning curve. A high school student can quickly lean how to get Excel to do useful calculations."
Notes: Includes bibliographical references.
Table of contents: title: Projectile trajectory; title: The pursuit problem; title: Equation solving with and without Solver; title: Temperature profile; title: Numerical integration; title: Approximate solutions to differential equations; title: Superposition of sine waves and Fourier series; title: Fast Fourier transform; title: Applying statistics to experimental data; title: Electrostatics; title: Random events.