Modelling physics with Microsoft Excel

Başlık

:
Modelling physics with Microsoft Excel

Dil

:
English

ISBN

:
9781627054195

Yazar

:
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.

Seri

:
IOP concise physics.

Genel Not

:
"Version: 20141001"--Title page verso.

"A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso.

İçerik

:
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.

Özet

:
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 Konumu | Mevcut Konumu |
---|---|---|---|---|

E-Kitap | 1830376-1001 | QA76.95 .L546 eb | IOP E-Kitap Lokasyonu | IOP E-Kitap Koleksiyonu |