Physics with Excel and Python: Using the Same Data Structure Volume II – Applications to Particles, Waves, Fields and Random Processes – Paperback

In this second volume of Physics with Excel and Python, more advanced topics are introduced through a series of case studies that apply programming techniques to solve physical and mathematical problems. Building on the foundations established in Volume 1, the book demonstrates how computational methods can be used to explore and analyze a wide range of phenomena covered in undergraduate Physics courses. Topics covered include vibrations, motion in the plane, steady-state Schrdinger equations, partial differential equations, Monte Carlo methods, wave optics, statistical physics, and variational calculus applied, e.g., to Fermat’s principle of optics. Each chapter begins with an introduction to the underlying physical problem before developing practical solutions using MS Excel and Python. All spreadsheet solutions and Python programs are available on GitHub. Following the pedagogical approach established in the first volume, the book emphasizes hands-on problem solving and developing computational skills alongside physical understanding. By working through the examples and exercises, students gain the confidence to tackle physical problems independently and to apply computational techniques in a variety of academic and business contexts. Designed for students of physics and related disciplines, this volume extends readers’ understanding of both physics and scientific computing. It will also be of interest to educators seeking effective ways to introduce more advanced computational methods into their teaching. Combining theory, computation, and practical application, the book provides a valuable resource for the study of modern physics and mathematical modeling.