Physics with Excel and Python II

Using the Same Data Structure Volume II - Applications to Particles, Waves, Fields and Random Processes
Erscheinungsjahr 2027
ISBN: 978-3-032-46622-8
Verlag: Springer

Buch, Englisch, Format (B × H): 155 mm x 235 mm

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 Schrödinger 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 and results in a data structure that may serve as the basis for spreadsheet designs and Python programs, some of which are reported in the book. 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 at high school. Combining theory, computation, and practical application, the book provides a valuable resource for the study of modern physics and mathematical modeling.

Zielgruppe

Lower undergraduate

Autoren/Hrsg.

Mergel, Dieter

Fachgebiete

• Naturwissenschaften Physik Physik Allgemein Theoretische Physik, Mathematische Physik, Computerphysik
• Mathematik | Informatik Mathematik Mathematische Analysis
• Technische Wissenschaften Bauingenieurwesen Bauingenieurwesen
• Mathematik | Informatik Mathematik Numerik und Wissenschaftliches Rechnen Optimierung

Inhaltsverzeichnis

1 Introduction.- 2 One-dimensional oscillations.- 3 movements in one plane.- 4 Schrödinger equation.- 5 partial differential equations.- 6 Electrical and magnetic fields.- 7 Variational calculus.- 8 Geometric optics with Fermat's principle.- 9 Model distributions by simulation of physical processes.- 10 Stochastic Movement.- 11 Monte Carlo Methods.- 12 Wave Optics.- 13 Statistical Mechanics.- 14 Mathematical Additions.- 15 Conclusions.- Bibliography.- Index.

Über Autor(innen)

Dieter Mergel studied physics in Göttingen, obtained his doctorate at the TU Clausthal in the field of solid-state physics and worked 11 years in the Philips research laboratories Hamburg / Aachen on automatic speech recognition and optical data storage. Since 1993 he has been Professor of Technical Physics at the University of Duisburg-Essen, and is now retired. His professional activities included research in the field of solid-state layers, lectures for Teacher Education students and Physics Engineers, and advanced courses on Excel applications.