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
http://iopscience.iop.org/book/978-1-627-05419-5


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