Numerical calculation for physics laboratory projects using Microsoft EXCEL® / Shinil Cho.

Format:

Book

Author/Creator:

Cho, Shinil, author.

Contributor:

Institute of Physics (Great Britain), publisher.

Series:

IOP (Series). Release 6.

IOP concise physics 2053-2571.

[IOP release 6]

IOP concise physics, 2053-2571

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Physics--Data processing.

Physics.

Physical Description:

1 online resource (various pagings) : illustrations (some color).

Place of Publication:

Bristol [England] (Temple Circus, Temple Way, Bristol BS1 6HG, UK) : IOP Publishing, [2019]

System Details:

Mode of access: World Wide Web.

System requirements: Adobe Acrobat Reader, EPUB reader, or Kindle reader.

text file

Biography/History:

Shinil Cho attended Rikkyo University in Tokyo, Japan for his BS degree, Seoul National University in Seoul, Korea for MS, and the Ohio State University for Ph.D. He held post-doctoral fellowships at the Ohio State University and University of Florida, a visiting professor at University of South Carolina. He has been at La Roche University since 1995. Currently he is an Associate Professor at La Roche. His current research interest includes quantum computation, biometrics, and physics education.

Summary:

This book covers essential Microsoft EXCEL®'s computational skills while analyzing introductory physics projects. Topics of numerical analysis include; multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.

Contents:

1. Response time of the nervous system

1.1. Objectives

1.2. Theory and procedure

1.3. Data analysis

1.4. Central limit theorem

2. Constant acceleration motion

2.1. Objectives

2.2. Theory and procedure

2.3. Data analysis

3. Equation of motion

3.1. Objectives

3.2. Theory and procedure

3.3. Data analysis

3.4. Solving equation of motion using the Euler method

3.5. Runge-Kutta method

3.6. Runge-Kutta method for simultaneous ordinary differential equations

4. Periodic motions

4.1. Objectives

4.2. Theory and procedure

4.3. Data analysis

4.4. Further investigation

minimum period of a physical pendulum

4.5. More periodic motions

5. Lissajous figures

5.1. Objectives

5.2. Theory and procedure

5.3. Lissajous figures using EXCEL

5.4. Animation of graphs

6. Kirchhoff's law

6.1. Objectives

6.2. Theory and procedure

6.3. Circuit under measurement

6.4. Data analysis

7. Equipotential surface

7.1. Objectives

7.2. Measurement procedure

7.3. Data analysis

7.4. Further investigation

8. Magnetic field profile

8.1. Objectives

8.2. Theory and procedure

8.3. Measurement

8.4. Additional study

9. Law of refraction

9.1. Objective

9.2. Theory and procedure

9.3. Data analysis

9.4. Projectile motion based on the least action principle

9.5. Eigen value problems using Solver

10. Quantum particle trajectories

10.1. Objectives

10.2. Theory

Nelson's approach

10.3. Analysis of quantum particle trajectories.

Notes:

"Version: 20191001"--Title page verso.

Includes bibliographical references.

Title from PDF title page (viewed on November 18, 2019).

Other Format:

Print version:

ISBN:

9781643277264

9781643277240

OCLC:

1128001600

Access Restriction:

Restricted for use by site license.