Modelling physics with Microsoft Excel
Modelling physics with Microsoft Excel



Liengme, Bernard V., author.

Yayın Bilgileri
San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) : Morgan & Claypool Publishers, [2014]
Bristol [England] (Temple Circus, Temple Way, Bristol BS1 6HG, UK) : IOP Publishing

Fiziksel Tanımlama
1 online resource (96 pages) : illustrations.

IOP concise physics.

Genel Not
"Version: 20141001"--Title page verso.
"A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso.

Preface -- Acknowledgments -- Author biography
Projectile trajectory -- Football trajectory -- Adding air resistance
The pursuit problem -- The numerical approach -- Comparison with the analytical solution
Equation solving with and without Solver -- The van der Waals equation : the fixed point iteration method -- van der Waals equation : using Solver -- Finding roots graphically -- Newton-Raphson method -- Using Solver to obtain multiple roots -- The secant method and goal seek -- The inverse quadratic method -- Solving systems of linear equations -- Solving a system of non-linear equations -- Closing note on Solver
Temperature profile -- A formula method -- A matrix method -- A Solver method
Numerical integration -- Trapezoid rule and Simpson's 1/3 rule -- Centroid of a plane using Simpson's 1/3 rule -- Monte Carlo method I -- Monte Carlo method II -- Buffon's needle
Approximate solutions to differential equations -- Ordinary differential equations (ODEs) -- Euler's method -- The Runge-Kutta method -- Testing for convergence -- Systems of ODEs and second-order ODEs
Superposition of sine waves and Fourier series -- Addition of sine waves; generation of beats -- Fourier series -- Parametric plots and Lissajous curves
Fast Fourier transform
Applying statistics to experimental data -- Comparing averages -- Comparing variances -- Are my data normally distributed?
Electrostatics -- Coulomb's law -- Electrostatic potential -- Discrete form of Laplace equation
Random events -- Random walk and Brownian motion -- A random self-avoiding walk.

This book demonstrates 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. Another advantage is the somewhat less steep learning curve. This book shows Excel in action in various areas within Physics. Some Visual Basic for Applications (VBA) has been introduced, the purpose here is to show how the power of Excel can be greatly extended and hopefully to whet the appetite of a few readers to get familiar with the power of VBA. Those with programming experience in any other language should be able to follow the code.

Reading Level
Professional and scholarly.

Konu Başlığı
Physics -- Data processing.
Mathematics -- Data processing.
Electronic spreadsheets.
Mathematical modelling.
SCIENCE / Physics / Mathematical & Computational.

Ek Kurum Yazarı
Institute of Physics (Great Britain),

Elektronik Erişim

Materyal TürüDemirbaş NumarasıYer NumarasıRaf KonumuMevcut Konumu
E-Kitap1830376-1001QA76.95 .L546 ebIOP E-Kitap LokasyonuIOP E-Kitap Koleksiyonu