Modelling physics with Microsoft Excel /

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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Liengme, Bernard V. (Autor)
Formato: Electrónico Video
Idioma:Inglés
Publicado: San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) : Morgan & Claypool Publishers, [2014]
Colección:IOP concise physics.
IOP (Series). Release 1.
Temas:
SCIENCE / Physics / Mathematical & Computational.
Mathematical modelling.
Electronic spreadsheets.
Mathematics > Data processing.
Physics > Data processing.
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Random events
  • Random walk and Brownian motion
  • A random self-avoiding walk.
  • Electrostatics
  • Coulomb's law
  • Electrostatic potential
  • Discrete form of Laplace equation
  • Applying statistics to experimental data
  • Comparing averages
  • Comparing variances
  • Are my data normally distributed?
  • Fast Fourier transform
  • Superposition of sine waves and Fourier series
  • Addition of sine waves; generation of beats
  • Fourier series
  • Parametric plots and Lissajous curves
  • 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
  • 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
  • Temperature profile
  • A formula method
  • A matrix method
  • A Solver method
  • 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
  • The pursuit problem
  • The numerical approach
  • Comparison with the analytical solution
  • Projectile trajectory
  • Football trajectory
  • Adding air resistance
  • Preface
  • Acknowledgments
  • Author biography

Ejemplares similares