Mathematical Methods for Physics using Microsoft EXCEL

In Mathematical Methods for Physics using Microsoft EXCEL, readers will investigate topics from classical to quantum mechanics, which are often omitted from the course work. Some of these topics include rocket propulsion, Rutherford scattering, precession and nutation of a top under gravity, parametric oscillation, relativistic Doppler effect, concepts of entropy, kinematics of wave packets, and boundary value problems and associated special functions as orthonormal bases. Recent topics such as Lagrange point of the James Webb Space Telescope, a muon detector in relation to Cherenkov’s radiation, and information entropy and H-function are also discussed and analysed. Additional interdisciplinary topics, such as self-avoiding random walk for polymer length, and population dynamics, are also described. This book will allow readers to reproduce and replicate the data and experiments often found in Physics textbooks, with a stronger foundation of knowledge.

While investigating these subjects, readers will follow a step-by-step introduction to computational algorithms for solving differential equations for which analytical solutions are often challenging to find. For computational analysis, features of Microsoft EXCEL® including AutoFill, Iterative Calculation, and Visual Basic for Applications are useful to conduct hands-on projects. For visualization of computed outcomes, the Chart output feature can be readily used. There are several first-time attempts introduced by this book such as 3D-like graphics using Euler’s angle, and behavior of wave functions of harmonic oscillator and hydrogen atom near the true eigne values.