Skip to main content
SpringerLink
Log in

Physics with Excel and Python

Using the Same Data Structure Volume I: Basics, Exercises and Tasks

  • Textbook
  • © 2022

Overview

Authors:
  1. Dieter Mergel

    1. Fakultät für Physik, Universität Duisburg-Essen, Duisburg, Germany

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Combines physics, math and programming

  • Exemplary topics include electromagnetism, statistical mechanics and quantum mechanics

  • Additional multimedia content accessible in browser

  • 9218 Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (10 chapters)

  1. Front Matter

    Pages i-xvii
    Download chapter PDF

  2. Introduction

    • Dieter Mergel
    Pages 1-14

  3. Data Structures, Excel and Python Basics

    • Dieter Mergel
    Pages 15-73

  4. Formula Networks and Linked Diagrams

    • Dieter Mergel
    Pages 75-113

  5. Macros with Visual Basic and Their Correspondences in Python

    • Dieter Mergel
    Pages 115-180

  6. Basic Mathematical Techniques

    • Dieter Mergel
    Pages 181-225

  7. Superposition of Movements

    • Dieter Mergel
    Pages 227-267

  8. Integration of Newton’s Equation of Motion

    • Dieter Mergel
    Pages 269-306

  9. Random Numbers and Statistical Reasoning

    • Dieter Mergel
    Pages 307-364

  10. Evaluation of Measurements

    • Dieter Mergel
    Pages 365-417

  11. Fitting Trend Curves to Data Points

    • Dieter Mergel
    Pages 419-474

  12. Back Matter

    Pages 475-482
    Download chapter PDF
Back to top

Keywords

About this book

This book is intended to serve as a basic introduction to scientific computing by treating problems from various areas of physics - mechanics, optics, acoustics, and statistical reasoning in the context of the evaluation of measurements. After working through these examples, students are able to independently work on physical problems that they encounter during their studies. For every exercise, the author introduces the physical problem together with a data structure that serves as an interface to programming in Excel and Python. When a solution is achieved in one application, it can easily be translated into the other one and presumably any other platform for scientific computing. This is possible because the basic techniques of vector and matrix calculation and array broadcasting are also achieved with spreadsheet techniques, and logical queries and for-loops operate on spreadsheets from simple Visual Basic macros. So, starting to learn scientific calculation with Excel, e.g., at High School, is a targeted road to scientific computing. The primary target groups of this book are students with a major or minor subject in physics, who have interest in computational techniques and at the same time want to deepen their knowledge of physics. Math, physics and computer science teachers and Teacher Education students will also find a companion in this book to help them integrate computer techniques into their lessons. Even professional physicists who want to venture into Scientific Computing may appreciate this book.


Authors and Affiliations

  • Fakultät für Physik, Universität Duisburg-Essen, Duisburg, Germany

    Dieter Mergel

About the author

Dieter Mergel studied physics in Göttingen, obtained his doctorate at the Technical University of 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 is Professor of Technical Physics at the University of Duisburg-Essen. His professional activities include research in the field of solid-state layers and lectures for students in teaching and medical professions.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation