Modelling physics with Microsoft Excel /
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) :
Morgan & Claypool Publishers,
[2014]
|
| Series: | IOP concise physics.
|
| Subjects: | |
| Online Access: | Connect to the full text of this electronic book |
Table of 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.