Başlık:
Modelling physics with Microsoft Excel
Yazar:
Liengme, Bernard V., author.
ISBN:
9781627054195
Ek Yazar:
Fiziksel Tanım:
1 online resource (96 pages) : illustrations.
Series:
IOP concise physics,
IOP concise physics.
General Note:
"Version: 20141001"--Title page verso.
"A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso.
Contents:
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.
Abstract:
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.
Added Corporate Author:
Electronic Access:
http://iopscience.iop.org/book/978-1-627-05419-5